sap bw app server, some cubes expand, some don't expand.

[dlau-etl-1]

Hi all,

If some cube doesn't expand, would it mean that the user logged in, doesnt have view priviliges to see the underlying data?

Or some server setting to change?

If not a cube security setting, what could it be?

Installed are the latest versions:

• sap .net connector 3 for .net 4
• Version: 2.99.862.0 64-bit (November 2021)
• Gateway 3000.106.11 (November 2021)

[v-luwang-msft]

Hi @dlau-etl-1 ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi @dlau-etl-1 ,

TO check if with limitations for the user to access the specific SAP BW cube, the permission should be set on SAP BW side, you can contact your SAP BW administrator for help.

There is a official document which introduces SAP BW connector in Power BI desktop, please take a look: Use the SAP BW Connector in Power BI Desktop.

Best Regards

Lucien