Share just measures of a dataset, with out all the tables

[Marko33]

Hi,

I want to share with some folks meatrics I have created through a measure. As the underlying dataset contains sensitive data I don´t want to provide access to all the table in the background. They want to use this metrics in their own PBI report and incorporate them in a dashboard.

Any idea how to solve that?

[Jayee · Accepted solution]

Hi @Marko33 

Open your report in desktop and open the DAX studio and run below query it will load all the measures in you dataset and also you can export it to Excel or CSV etc as you like

Select * from $system.TMSCHEMA_MEASURES

If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!

[arvindsingh802]

You can create template report and share with them

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-templates