Blackjack's avatar
Blackjack
Icon for Advocate I rankAdvocate I
9 years ago
Status:
Done

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! 

Gateways
Report Server
Reports

6 Comments

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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

  • v-haibl-msft's avatar
    v-haibl-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    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

  • HrabinaJan's avatar
    HrabinaJan
    Frequent Visitor
    9 years ago

    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;

Completed Ideas