I guess this was a "feature" that was introduced six years ago (Power BI Desktop May Feature Summary | Microsoft Power BI Blog | Microsoft Power BI_. You can create measures in a report that is attached to SSAS Tabular with Live Connection.
What do people think about this?
I am less than impressed. It has been difficult to find the source of an issue. I start in the report and find that the measure that is not working has a name like "_measure test" with an expression that includes measures like XXX and Test3. Occasionally there is an informative measure name in the expression (MTD Sales). But then I have to figure out if MTD Sales is in the report or it is hidden in the report.
Most of the measures I am seeing in the reports were added because the equivalent measure in the SSAS model was not working. I would much rather figure out what is broken rather than putting together a bunch of brittle scaffolding.
My data environment
Ok it is a feature. But here are my thoughts.
- Use it to figure out how the measure might be fixed, but have it fixed in the SSAS model asap
- Ask whether this measure is truly specific to this report. I mean if you are going to create a similar report based on the current one, putting a measure in the report is a maintenance nightmare
- If the measure is truly specific to the report, prefix the name of the measure with the name of the report as a kind of namespace identifier. That way it will be harder for someone to create a measure with the same name that will break the measure.
Sorry, this has been bugging me.