Forum Discussion

JammyHamster's avatar
JammyHamster
Frequent Visitor
3 years ago

PBI Dataset to Excel Table

I have an Excel table set up via a connection to a PBI Dataset per instructions here;
Solved: Connect to dataset from Excel as a TABLE, not PIVO... - Microsoft Power BI Community

 

I can't however seem to retrieve measures into my table. For example if I have a simple table [item], [units sold] and [unit price] and create a simple measure called Revenue ([unit sold] x [unit price]) I can see this measure in the pivot table, and it works perfectly. However, when creating an Excel Table using connection string EVALUATE [tblname] the measures are not displayed.

Is there anyway to show measures in an Excel table?

 

In addition the table headers all return the table name followed by the filed name. Is there anyway to prevent the table name being prefixed?

 

TIA

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi  JammyHamster ,

    According to my test on my local, my table name is displayed fine, and Measure is also displayed and used in the table.

    Official documentation shows: Your dataset in Power BI must have pre-defined measures.

    For more related restrictions, please refer to the following link:

    Connect Excel to Power BI datasets - Power BI | Microsoft Learn

     

     

    Best Regards,

    Liu Yang

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

    • JammyHamster's avatar
      JammyHamster
      Frequent Visitor
      3 years ago

      Hi Anonymous,

      I can see the measures fine in a pivot table. It is when I use an Excel Table the issue occurs. If you double click a value in your pivot I believe you will not see any of the fx measures. The fields will also be prefixed with the table name.

      Thanks,

      Jamie