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
I am talking about adding the column in the excel data set that is linked to the PowerBi file that is on Workspace server. I have already created a table in excel file but not availbale to make changes to table that is already created.
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:)
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.
