Forum Discussion

tomascid's avatar
tomascid
Frequent Visitor
4 years ago
Solved

Seeing Measure data in the Data Hub

Aloha! (Sorry in advance  if I'm getting the terminology wrong!)   I've created a dashboard with a measure, and now my colleagues would like to use the data from a view of that measure in other das...
  • KratosBI's avatar
    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!