Forum Discussion
Seeing Measure data in the Data Hub
- 4 years ago
Hello, Tomascid!
This is a fantastic question that I get on a semi-regular basis.
When other people have explained this issue to me, they have also described it as 'sharing a table in excel with a formula(s) included.'
This is where Excel and Power BI differ in some ways depending upon how you choose to implement a given solution.
In Power BI, a measure is an aggregation value that sits on top of a data model that can be comprised of hundreds of tables, relationships, security, etc. Therefore, to be able to share a measure, you need to share the data model underneath the measure.
Two Options:
1. Create an MDX extract from your tabular model into a table and share that with the user (not recommended)
2. Create a Power BI Datamart that includes the data in your model, create a SQL query of the table you want to share (including the appropriate aggs to represent the measures), and then share that query in either the datamart or into a separate Dataflow to the user.
MDX Info: Announcing improved MDX query performance in Power BI | Microsoft Power BI Blog | Microsoft Power BI
Power BI Datamarts: Introduction to datamarts - Power BI | Microsoft Docs
This is where a Power BI Datamart may be a useful solution for you.
Good Luck; I hope this helps!
Hello, Tomascid!
This is a fantastic question that I get on a semi-regular basis.
When other people have explained this issue to me, they have also described it as 'sharing a table in excel with a formula(s) included.'
This is where Excel and Power BI differ in some ways depending upon how you choose to implement a given solution.
In Power BI, a measure is an aggregation value that sits on top of a data model that can be comprised of hundreds of tables, relationships, security, etc. Therefore, to be able to share a measure, you need to share the data model underneath the measure.
Two Options:
1. Create an MDX extract from your tabular model into a table and share that with the user (not recommended)
2. Create a Power BI Datamart that includes the data in your model, create a SQL query of the table you want to share (including the appropriate aggs to represent the measures), and then share that query in either the datamart or into a separate Dataflow to the user.
MDX Info: Announcing improved MDX query performance in Power BI | Microsoft Power BI Blog | Microsoft Power BI
Power BI Datamarts: Introduction to datamarts - Power BI | Microsoft Docs
This is where a Power BI Datamart may be a useful solution for you.
Good Luck; I hope this helps!