CSND's avatar
CSND
Regular Visitor
7 years ago
Status:
New

SSAS Olap Cube - Calculated measures - Misbehavior

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

  • CSND's avatar
    CSND
    Regular Visitor

    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's avatar
    v-qiuyu-msft
    Community Support

    Hi CSND,

     

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

     

    Best Regards,
    Qiuyun Yu 

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community 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 

  • CSND's avatar
    CSND
    Regular 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.