olap cube live connection

Hi Anonymous ,

Did you connect to SSAS Multidimensional Models in connect live mode now ? Currently, only Tabular model supports to create report level measures in Power BI Desktop. For multidimensional cubes, you can't create any measures or calculated columns. You can see:

Connect to SSAS Multidimensional Models in Power BI Desktop

Analysis Services Tabular data in Power BI Desktop

Followings are the related ideas shared on Power BI Ideas forum. You can vote them up and add your comments there to improve Power BI in the feature. 

Calculated measures when live connected to MDX cubes

SSAS Get Data multiple data sources

It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

We also submitted this feedback to the product group internally, so that the product group can pay attention to this problem and speed up the issue repairing.

Best Regards,

Amy

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

@simone74

You can create measures when live-connected to OLAP cubes by following the steps:

- create a report connected live to the OLAP cube on the ssas server. 

- publish this report to the Power BI service and share the dataset. If the server is on-prem, you will have to use a gateway.

- create a report connected live to the shared dataset. Then in this report, you can create measures using DAX functions.