Error 'Couldn't load the data for this visual' w/ Measures from DirectQuery for SAP BW (Bex Query)
Hello, i got the same issue.
If it would be helpful, find the log bellow and mention files could be downloaded here:
frownsnapshot: https://ulozto.cz/!6ERsX3GOMUCd/frownsnapshot1472194668-zip
performance traces: https://ulozto.cz/!xitHmAYejlAs/performancetraces-zip
Feedback Type:
Frown (Error)
Timestamp:
2017-08-04T07:51:46.2307497Z
Local Time:
2017-08-04T09:51:46.2307497+02:00
Product Version:
2.48.4792.721 (PBIDesktop) (x64)
Release:
July 2017
IE Version:
11.1480.14393.0
OS Version:
Microsoft Windows NT 10.0.14393.0 (x64 cs-CZ)
CLR Version:
4.6.2. or later [Release Number = 394802]
Workbook Package Info:
1* - cs-CZ, Query Groups: 0, fastCombine: Disabled, runBackgroundAnalysis: True.
Peak Working Set:
408 MB
Private Memory:
316 MB
Peak Virtual Memory:
33.8 GB
Error Message:
V jednom nebo víc polích je chyba: (Klíčové hodnoty) Hodnota netto: Nejde najít zdroj dat ve funkci EXTERNALEXPRESSION.
User ID:
b65cc189-cdcd-4ee1-94cb-8b619eda4511
Session ID:
dc4b481f-ddec-4288-8b01-938af34a7b8b
Telemetry Enabled:
True
Model Default Mode:
DirectQuery
Snapshot Trace Logs:
C:\Users\hrabinaj\AppData\Local\Microsoft\Power BI Desktop\FrownSnapShot1472194668.zip
Performance Trace Logs:
C:\Users\hrabinaj\AppData\Local\Microsoft\Power BI Desktop\PerformanceTraces.zip
Enabled Preview Features:
PBI_shapeMapVisualEnabled
PBI_EnableReportTheme
PBI_numericSlicerEnabled
PBI_PbiServiceLiveConnect
PBI_daxTemplatesEnabled
CustomConnectors
Disabled Preview Features:
PBI_SpanishLinguisticsEnabled
Enabled DirectQuery Options:
PBI_DirectQuery_Unrestricted
Cloud:
GlobalCloud
ID aktivity:
null
Čas:
Fri Aug 04 2017 09:47:22 GMT+0200 (Střední Evropa (letní čas))
Client Error Code:
Missing_References
DPI Scale:
100%
Supported Services:
Power BI
Formulas:
section Section1;
shared Cube = let
Zdroj = SapBusinessWarehouse.Cubes("192.168.30.24", "00", "100", [ScaleMeasures=false]),
#"$INFOCUBE" = Zdroj{[Name="$INFOCUBE"]}[Data],
#"$/IMO/V_SD30" = #"$INFOCUBE"{[Id="$/IMO/V_SD30"]}[Data],
#"Přidané položky" = Cube.Transform(#"$/IMO/V_SD30",
{
}),
AddUniqueIds = let
NewDimensions = Table.TransformColumns(Cube.Dimensions(#"Přidané položky"),
{
"Data",
(dimTable) => List.Accumulate(
Table.ColumnNames(dimTable),
dimTable,
(table, column) => Table.AddColumn(table, column & ".UniqueId", each Cube.AttributeMemberId(Record.Field(_, column)))
)
}),
NewCube = Cube.ReplaceDimensions(#"Přidané položky", NewDimensions)
in
NewCube
in
AddUniqueIds;