Forum Discussion

homboy27's avatar
homboy27
Helper III
1 year ago
Solved

Creating excel tables from Published PI Reports

I have a dashbaord that is published on power bi workspace. I have then created tables from the dashboard by linking to the powerbi workspace. Once I refresh the powerbi, I open the excel and refresh...
Need Help
Show and Tell
Tips and Tricks
  • MasonMA's avatar
    MasonMA
    1 year ago

    Does this already exist in your dataset as a Measure? if not then try creating a Measure like 

    Total Sales =
    SUM ( Table[SalesAmount] 

    first in the dataset. That way the calculation is handled by the dataset, and Excel will respect it

homboy27's avatar
homboy27
Helper III
1 year ago

How to edit the underlying Power Query query?

MasonMA's avatar
MasonMA
Super User
1 year ago

That was mentioned in my second response:) 

  • homboy27's avatar
    homboy27
    Helper III
    1 year ago

     

    MasonMA 

    Below was your response - but i am not able to find where to locate the new column 

     

    In Excel, Data, Queries & Connections. Find the query that pulls data from the Power BI dataset. In the Navigator/Fields panel, locate and select the new column you want to include. 

     

     

  • MasonMA's avatar
    MasonMA
    Super User
    1 year ago

    Hello homboy27 

     

    We might have misunderstood each other somewhere in the threads. The connection is actually a live OLAP connection. Unlike imported data, it doesn’t create a query in Power Query, so you won’t see it under Data- Queries & Connections, and you can’t edit it the same way. the only way to add/remove columns is by dragging them in a PivotTable.

     

     

    For details please refer to from Microsoft. 

    https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-excel-power-bi-datasets