Forum Discussion
Adding measure while using SSAS tabular datasource corrupt the whole report
HI Dars,
I might be misunderstanding but I think the problem is because you are using a SSAS Tabular datamodel, not a local PBI datamodel. Thus you need to add the measures to the remote SSAS data model. Same for SSAS MD I would have thought?
If you have chosen the SSAS Tabular data connection my understanding is that the data is coming direct from SSAS, not being stored in the local PBIX, so not able to add measures or calculated columns in the local data model.
Anybody else agree / disagree?
Rob
The following article suggests that you can't add measures when using a Live connection.
However the following article says you can (section pulled out)
https://docs.microsoft.com/en-us/power-bi/desktop-analysis-services-tabular-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.
This second version is why PBI Desktop allows you to add measures in a Live connected report, though the table page and data model are hidden. Shoing the Data model would be crazy useful, as would sample data. Why these aren't shown in a READ ONLY mode I'm not sure, they are inherently there in the backend, they're just obviosuly not being passed to what is now a dumb client app! It's just that as these measures get more complex (changing the context for example) they seem to cause issues on the SSAS backend. Like behaving badly as described above.
Like many early versions of MS software its a bit rough around the edges...
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.