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
If columns already exist in the Power BI dataset, you would just need to modify the Excel query.
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.
This works if the column already exists in the dataset. You can also remove columns here if needed.
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