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
My understanding is once a table is created from a Power BI dataset, its structure is fixed. New columns cannot be added to the table itself, you must either edit the underlying Power Query query or use a PivotTable for dynamic access.
Maybe other users would have better perspectives.
thanks
How to edit the underlying Power Query query?
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
Hi homboy27 ,
Please follow the below steps,
1. download the dataset file and add new column and publish it again
2. In your excel, go to Data->Refresh All
then, you should be able to see your new column in excel.
