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...