Forum Discussion

StephanDenker's avatar
StephanDenker
Frequent Visitor
5 years ago

Power BI, Analyse in Excel, Offline Olap, error without Error-Message

Hey Community, If I try to use Offline Olap function for PivotTable connected with Power BI Dataset I get an Error without an errrormessage. Does offline olap work for anybody?   Am I right, that...
Need Help
StephanDenker's avatar
StephanDenker
Frequent Visitor
5 years ago

Thank you, v-yingjl ! I understand., Offline Olap would be the solution of my problem. So I just have to figure out, why I'm getting an Error. Maybe there are some limitations? 

  • v-yingjl's avatar
    v-yingjl
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi StephanDenker ,

    Based on my research, here are some limitations:

    • Offline cubes are only available on Multidimensional Analysis Services connections.
    • Distinct Count measures are not supported.
    • Dimensions with binary data are not supported.
    • When you add a parent-child hierarchy, levels and filters on a parent-child hierarchy are ignored and the entire parent-child hierarchy is included.

    You can also refer:

    creating offline SSAS cube  

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.