SSAS Olap Cube - Calculated measures - Misbehavior

[CSND]

We are experiencing a misbehavior with OLAP Cube calculated measures in Power BI. Excel is doing it right.

Power BI is only showing the right number when both measures used in the third measures also is included in the visual.

Data source: OLAP Cube

Power BI version: 2.62.5222.761 64-bit (September 2018)

So the question is:

Is OLAP cubes supported in Power BI?

Please contact me and I can't send the image illustrating the problem.

[v-qiuyu-msft]

Hi @CSND,

Power BI does support get data from SSAS cube, see: https://docs.microsoft.com/en-us/power-bi/desktop-ssas-multidimensional. 

For your issue , please share some screenshots to clarify it. You can upload them to your OneDrive and share the link here. 

Best Regards,
Qiuyun Yu 

[CSND]

Hi Qiuyun Yu

Here is the link illustrating why I am been sarcastic about if Power BI supports OLAP.

Power BI OLAP error

Regards

Claus

[v-qiuyu-msft]

Hi @CSND,

I don't have permission to access the link. Please double check it. 

Best Regards,
Qiuyun Yu 

[CSND]

Link updated to dropbox

https://www.dropbox.com/s/2hc58gssn63vdsp/PowerBIOlapError.png?dl=0

[v-qiuyu-msft]

Hi @CSND,

Would you please share pbix file and .abf file of the SSAS cube with us? You can upload them to your Dropbox and send the share link to me via private message. 

By the way, there is a Power BI desktop October version released, please update your desktop to this version 2.63.3272.40262 if possible. 

Best Regards,
Qiuyun Yu 

[CSND]

Hi

Thanks Qiuyun for taking the time to response.

In then mean time I have received the answar from the support case I also issued that

- "Technically it is by design and it is due to the different query patterns we have."

Meaning difference between Old DAX and Super DAX.  And SuperDAX is not avialabe for MD. 😞

So please develop / enabling SuperDax on MD servers.

Conclusion Power BI does not support all aspects of MD cubes.