Forum Discussion
olap cube live connection
Community SupportHi,
Based on my test connecting to SSAS Tabular database using Connect live mode, creating a measure is ok. Please update Power BI Desktop to the latest version 2.69.5467.2151 , try it again.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, my version of power BI is : 2.70.5494.562 64-bit (giugno 2019), but Ican't create new measure.
- v-xicai
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.
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.
Many thanks.
In this way I can create only measures not add column. Right?
