Problem after SAP BW connection

[aquilano76]

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 

[v-yuezhe-msft · Accepted solution]

@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

[v-yuezhe-msft]

@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

[aquilano76]

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

[v-yuezhe-msft]

@aquilano76,

Have you clicked the triangle to expand the cube?


Regards,
Lydia

[aquilano76]

Yes Lydia, and nothings happen.

May the problem be related to “allow external access to this query” option?

Thank you,

Andrea

[v-yuezhe-msft · Accepted solution]

@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

[aquilano76 · Accepted solution]

Dear Lydia, we solved the problem allowing the flag "allow external access to this query".

Thank you, kind regards

Andrea