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
The columns already exist in the Bi file. I just want to bring in another column to the table. How do I do that?
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
How to edit the underlying Power Query query?