Forum Discussion
Creating excel tables from Published PI Reports
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
That was mentioned in my second response:)
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.
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