Not able to load SAP BW Query data in Power BI- The model doesn´t have a named expression named Cube

[Michael_Rau]

Dear all,

we´re getting the below message while trying to load SAP BW Query data in Power BI.

Copy friendly message:
Create connections
Cube
The model doesn´t have a named expression named Cube.

Screenshot of the message:

Does anyone faced the same issue? Or what could be the reason behind this message?

Thank you.
Best regards,
Michael

[Michael_Rau · Accepted solution]

After installing the newest Power BI "September 2021" version (so far "January 2021" version was used) the message "The model doesn´t have a named expression named Cube." no longer appears and BW data can be accessed again via Power BI as usual.

[MaWa]

This worked for me, too! Thank you!

[Anonymous]

Hi  @Michael_Rau ,

Check the post below. These other methods to identify the possible cause of this problem:

https://community.powerbi.com/t5/Issues/Error-message-quot-quot-The-model-doesn-t-have-a-named/idi-p...

https://www.youtube.com/watch?v=jp0-ryvw9EM

https://forum.enterprisedna.co/t/error-messages-when-refreshing/6946/5

https://community.powerbi.com/t5/Issues/Existing-Desktops-will-not-open-after-installing-March-updat...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Michael_Rau , in Option and Setting -> Option, under direct query, you have the option to treat SAP HANA as a relational source. Try that

[Michael_Rau]

@amitchandak, thank you for your response and for your proposal. I tried it out but it has NO positive effect. The error message is the same.

Thank you.
Best regards,
Michael

[MaWa]

Positive effect or no effect?

[Michael_Rau]

thanks for the hint. Sorry I missed the "NO". The made setting has no effect.

[MaWa]

Hello, I have exactly the same problem "The model doesn´t have a named expression named Cube" when trying to establish a DirectQuery to SAP BW. It does not work with any Cube I tested. Loading/importing works fine.

The check box "treat SAP HANA as a relational source" does not have any affect.

I am using Implementation 2.0 (with SAP .NET Connector 3.0).