How to view the DAX formula of a measure for a report published by someone else on service

[Anonymous]

Hi Community,

I am new to Power BI and was looking up on the reports(published to service) that were created by someone else who has left the organization.

I am unable to view the dax formula used behind the measures.

I have tried downloading the datamodel associated to the reports to my desktop application. But i cannot see the measures in that datamodel(as they are report level measures)

I have tried DAX studio tool  as well but still not able to view the measures.

Can anyone suggest a way on how I can view the dax behind those measures?

Any help would be appreciated.

[bmirsidikov]

Solved: Re: View DAX Code behind Filters. - Microsoft Power BI Community

[v-deddai1-msft]

Hi @Anonymous ,

If you can't see data view in the left, your report is in live connection mode. So you can't view Dax formula of measures.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[amitchandak]

@Anonymous , if they are DAX measures, you should be able to see them on Desktop.

Can share some screenshot .

For power query, you can change details if it erroring and check https://youtu.be/59PUFuuCrbY

[aj1973]

Hi @Anonymous 

You need to verify the Connection Mode of the report. If it's a live connection mode then the measures if any are in the Database.

[dk_dk]

Hi Amine,

Do you know if there is any way to inspect the underlying DAX code for a measure that comes from a live connection, assuming I do not have edit access to the original model.

My use case: We are building our own Usage Metrics report for our workspace, and there are pre-made measures that appear when  connect to the data model. I would like to know what they each do to understand how and where to use them.

I have tried with DAX Studio / Tabular Editor to no avail, and if I convert the report to a local model / direct query then all the measures get "wrapped" into an EXTERNALMEASURE function and I still cannot see the original DAX. Example of this:

P-10 trend = EXTERNALMEASURE("P-10 trend", DOUBLE, "DirectQuery to AS - Usage Metrics Report")

 I appreciate if you have any insight or solution!

Br,
Daniel

[PowerBIUser2jan]

I have the same question as Daniel. I am using an already created semantic model (owned by another team). I have the build rights. All the measures are encapsulated in Measure Calculation. If I have to create a new measure, I would like to see the DAX behind the original ones. But I am not able to do so.