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.
6 Comments
- v-qiuyu-msftCommunity Support
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 - CSNDRegular Visitor
Hi Qiuyun Yu
Here is the link illustrating why I am been sarcastic about if Power BI supports OLAP.
Regards
Claus
- v-qiuyu-msftCommunity Support
- CSNDRegular Visitor
- v-qiuyu-msftCommunity Support
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 - CSNDRegular Visitor
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.