Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
- I'm loading dimensions and measures (key figures) from SAP BW 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;
Has anyone run into the same problem using DirectQuery (beta) and Data Gateway connecting to a SAP BW Query?
Thanks!
Hi @ALL,
There is a feature request, please review and vote it.
Best Regards,
Angelia
I will vote for it when (if) I find it. Please can you post the link to feature request.
Hi @Anonymous,
Here is the link:https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15287457-live-directquery-to-sap-bw. I forget to add it in reply above. Sorry for inconvenience.
Best Regards,
Angelia
Hi @v-huizhn-msft, the feature "Live/DirectQuery to SAP BW" from the link you posted was implemented in june. The error I reported in this thread is about an error that is triggered when this featured is used and after only the report with DirectQuery and therefor Data Gateway connection is upload to Power Bi service. The metrics cause the report to throw the error message "MdxScript(Model) (5, 42) Cannot find data source '' in function 'EXTERNALEXPRESSION'". Note that this error does not happen to any dimensions nor the same error happens with the metrics when the report is being created in Power BI desktop.
Can you please point out a link where the issue can be officially reported to MSFT, once the option "Send a Frown (Error)" is not available in the error message window to report the technical issue. This seems to be an important issue related to the DirectQuery (beta) that would be worth reporting to the developers.
Thank you.
Blackj.
Reported in the Issues area with the following link: https://community.powerbi.com/t5/Issues/Error-Couldn-t-load-the-data-for-this-visual-w-Measures-from...
Please all, upvote the issue.
Blackj
Hi @Blackjack,
In your gateway, please confirm if you have added the data resouce? And please try get data from other resouce, add data resouce and publish it to service, check if it works fine. If it won't, many the error is caused by your data gateway.
Best Regards,
Angelia
Hi @v-huizhn-msft (Angelia),
Data resource in Data Gateway has been setup correctly. I can see all the dimensions from the model, the issue only happens with the measures once the report is published on Power BI Service.
Thank you.
BlackJack
Hi Guys
I'm also having the same issue, any luck so far .. will appreciate any sort of help.
Rgds
Pankaj
Hi Guys
I'm also having the same issue, any luck so far .. will appreciate any sort of help.
Rgds
Pankaj
HI,
I have the same problem.
When trying to solve the prolbem I did some:
- upgrade On-Premise Gateway on last version,
- check data source setting on Power BI, test it (test show that everything is OK)
- do the new publishing of report,
Problem is still here:
... MdxScript(Model) (47, 32) Cannot find data source '' in function 'EXTERNALEXPRESSION' ....
Any Solutions?
Best Regards!
Neno
Hi All,
There are some limitations in DirectQuery for SAP Business Warehouse (BW). For example, it is not possible to use an aggregate function over a table. More details, please review the limitations in this article. Please check if your report use the corresponding features.
Best Regards,
Angelia
I'm aware of all limitations, but I can't get any visulization to work when report is published, on Power BI Desktop everthing work more then fine.