Forum Discussion
Problem after SAP BW connection
Dear All,
we have installed SAP RFC libraries and, after SAP BW connection, it appears a tree with the name of the server (root) and the node with the string $INFOCUBE. Expanding this node appears the message "No items selected for preview". But, what kind of SAP BW authorizations we need to assign to login user in order to see the infocubes?
Thank you, kind regards
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,
LydiaDear Lydia, we solved the problem allowing the flag "allow external access to this query".
Thank you, kind regards
Andrea
6 Replies
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,
LydiaDear 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,
Lydia