Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Error 'Couldn't load the data for this visual' w/ Measures from DirectQuery for SAP BW (Bex Query)

Greetings, 

 

I'm having trouble loading my report measures when using DirectQuery for SAP BW on Power BI cloud service.
Here is the error message:

"Couldn't load the data for this visual

 
MdxScript(Model) (5, 42) Cannot find data source '' in function 'EXTERNALEXPRESSION'.
Please try again later or contact support. If you contact support, please provide these details.

 

Activity IDba46f5a8-2e0e-40a5-99c8-3849f2baaaab
Request IDec00dc39-9f95-5c3c-e6ee-5e4e95fb06aa
Correlation ID0c939e55-b820-03e1-3024-c14d1d51cb13
Version13.0.1781.239"

Some facts: 

- I'm loading dimensions and measures (key figures) from Bex Query perfectly well in Power BI Desktop;

- The issue happens only with Measures on the Power Bi Service after publishing the report;

- Dimensions and Hierarchies are loading seamlessly on Power BI service;  
- The Data Gateway is up and running;
- I've tried to convert the measures into currency format but to no avail;

"Send a Frown (Error)" is not available in the error message window to report the technical issue;

Has anyone run into the same problem using DirectQuery (beta) and Data Gateway connecting to a Bex Query? (SAP BW)

Thanks! 

Status: Delivered
Comments
Anonymous
Not applicable

I have exact same issue.

On Power BI Desktop everything works fine but on published report visuals can not be displayed with error

"...Cannot find data source '' in function 'EXTERNALEXPRESSION'...."

 

Problems are with measures (Key Figures) because slicers are displayed with data as it should be.

 

 

 

 

 

v-haibl-msft
Microsoft Employee

@Blackjack @Anonymous

 

I can repro the same issue as you. I’ve reported it internally to Power BI Team: CRI 42253989
I’ll post here once I get any update about it.

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Status changed to: Accepted
 
v-haibl-msft
Microsoft Employee

@Blackjack @Anonymous

 

I’ve got response from the Product Team.

 

SAP BW Direct Query mode is still in beta (this is noted when you select DQ).  It is a known issue that it doesn't work in the service yet.

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Status changed to: Delivered
 
HrabinaJan
Frequent Visitor

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;