Hello,
I hope my email finds you well.
I'm trying to use Direct Query with Power BI on Apache Kylin's cubes, without
any luck.
We've develloped a custom connector witch support Direct Query on Kylin's
cubes, but once we add the fields to the graphiques I have this error (please
find attached the error's details)
Does Apache kylin support Direct Query from Power BI ?
Thanks,
Best regards
Zakaria,
Feedback Type:
Frown (Error)
Timestamp:
2021-08-20T08:32:48.1233153Z
Local Time:
2021-08-20T10:32:48.1233153+02:00
Session ID:
3c0bda9a-0474-46a9-95dc-52621dc3c035
Release:
January 2021
Product Version:
2.88.2361.0 (20.12) (x64)
Error Message:
Erreur OLE DB ou ODBC: [Expression.Error] Nous n'avons pas pu plier
l'expression sur la source de données. Essayez une expression plus simple..
OS Version:
Microsoft Windows NT 10.0.18363.0 (x64 fr-FR)
CLR Version:
4.7 or later [Release Number = 528040]
Peak Virtual Memory:
38.6 GB
Private Memory:
558 MB
Peak Working Set:
606 MB
IE Version:
11.1139.18362.0
User ID:
0ecd571d-356e-461b-b4b4-53133d33f2d9
Workbook Package Info:
1* - fr-FR, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Telemetry Enabled:
True
Snapshot Trace Logs:
C:\Users\zee0231n\AppData\Local\Microsoft\Power BI Desktop
SSRS\FrownSnapShotc513cb1f-0ad7-4e74-a17d-997828e77b7b.zip
Model Default Mode:
DirectQuery
Model Version:
PowerBI_V1
Is Report V3 Models Enabled:
False
Performance Trace Logs:
C:\Users\zee0231n\AppData\Local\Microsoft\Power BI Desktop
SSRS\PerformanceTraces.zip
Enabled Preview Features:
PBI_NewWebTableInference
Disabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_SpanishLinguisticsEnabled
PBI_JsonTableInference
PBI_ImportTextByExample
PBI_ExcelTableInference
PBI_qnaLiveConnect
PBI_v3ModelsPreview
PBI_eimInformationProtectionForDesktop
PBI_azureMapVisual
PBI_dataPointLassoSelect
PBI_compositeModelsOverAS
PBI_narrativeTextBox
PBI_dynamicParameters
PBI_anomalyDetection
PBI_newFieldList
PBI_cartesianMultiplesAuthoring
Disabled DirectQuery Options:
TreatHanaAsRelationalSource
Cloud:
GlobalCloud
DPI Scale:
150%
Supported Services:
Power BI Report Server, Power BI
Formulas:
section Section1;
shared DIMETATIEP = let
Source = Kyligence.Database("kylin.bulot.had.enedis.fr", "443",
"test_OSCAR", []),
DEVLABCBI_Schema = Source{[Name="DEVLABCBI",Kind="Schema"]}[Data],
DIMETATIEP_Table = DEVLABCBI_Schema{[Name="DIMETATIEP",Kind="Table"]}[Data]
in
DIMETATIEP_Table;
