Forum Discussion
Impactful IndividualAccessing report level measures from an external tool. Is it possible?
Helper Iavatorl did you find and solution for your issue? I see this topic is very old, but I'm also struggling with same issue.
I have live connection with plenty of measures, which are based on datamart which for unknown reasons crashed, so I cant show implemented logic.
Would be perfect if someone know how to show implemented logic from live connection.
I tried use DAX Studio, or Azure Data Studio, but both show just - "EXTERNALMEASURE("name", DOUBLE' "name of datamart connection")
Thanks
Unfortunately, PBI doesn't seem to have enabled connectivity to report layer measures with external tools.
We have the same problem in my organization - We deliver the Centralized Data Model via Live Connection, which is used by many report creators that also create report level measures via PBIX. The problem is that creating bulk report level measures in the PBIX can become time consuming, and also you cannot do version control on it - if someone leaves and something breaks, you would literally have to go through all PBIXs and figure out what has been done there.
After researching a lot on this topic, the only work around I found was to PUSH the report measures to the Centralized Data Model and place them in a specific folder.
The method is described here:
https://www.elegantbi.com/post/reportlevelmeasures
Not ideal, but depending on your scenario, it should do.Also a big issue in our SSAS setup - best tool so far is the extension tool Power BI helper:
To export RLM - go through three panes in the UI:
1. Model Analysis > Connect to model
2. Visualisation > Select PBIX
3. Documentation > Create Power BI file's documentation
Output is a HTM file with all objects used in the report including page/visual number and Report level measure DAX expressions
