Forum Discussion
Problem after SAP BW connection
aquilano76,
What is the version of your Power BI Desktop and do you define any queries in the cube? If you need to connect to the queries, you would need to enable the option that you mentioned.
Regards,
LydiaDear Lydia, we solved the problem allowing the flag "allow external access to this query".
Thank you, kind regards
Andrea
aquilano76,
Are you able to view these cubes when using other client tool such as BEx Query Designer to connect to SAP?Power BI exposes queries and cubes exposed by the BW Open Analysis Interface OLAP BAPIs.
And if you need to perform BEx queries in Power BI Desktop , you would need to turn on "Allow external access to this query" in SAP.
Reference:
https://docs.microsoft.com/en-us/power-bi/desktop-sap-bw-connector
Regards,
Lydia
Dear Lydia,
i tryed with BEx Analyzer and we are able to see the infoareas and cubes.
So the problem is on PowerBI side, isn't it?
What could be the problem? Thanks, Andrea
Have you clicked the triangle to expand the cube?
Regards,
LydiaYes Lydia, and nothings happen.
May the problem be related to “allow external access to this query” option?
Thank you,Andrea
aquilano76,
What is the version of your Power BI Desktop and do you define any queries in the cube? If you need to connect to the queries, you would need to enable the option that you mentioned.
Regards,
Lydia