Forum Discussion
Adding measure while using SSAS tabular datasource corrupt the whole report
Hi Anonymous,
I think the question / Answer you highlight only applies if you have IMPORTED the data into a local PBI data model, and are then effectively working off-line to the SSAS Tab data. And Not if you are using a Live SSAS Tabular connection. Reading the introduction to the link you provide seems to confirm this, but the answer to the question you highlight is not very well phrased.
My opinion remains that if you use the Live connection, and thus get updated SSAS Tabular data everytime you load the PBI report you cannot create local measures and calc columns.
Rob
HI Rob
You can create measures in PBI Desktop (it's not actually disabled) and the question as it is answered suggests that this is by design as it says "live connection" which is not "importing the data"
Question: If I created a live connection, can I edit the model or query in Power BI Desktop?
Answer: You can create report level measures in the Power BI Desktop, but all other query and modeling features are disabled when exploring live data.
So local report measures are "supposed" to work when connected using a Live Query to a SSAS data source. If the goal posts have moved subsequently then that's entirely fine, they just need to disable the add measure capability. Maybe that's what will turn up in the imminent release. Though it would be a serious step back in capability as importing our reporting cubes is impractical as no one is fitting that much data onto their laptop instance.