Forum Discussion
homboy27
Helper III
Helper IIICreating excel tables from Published PI Reports
I have a dashbaord that is published on power bi workspace. I have then created tables from the dashboard by linking to the powerbi workspace. Once I refresh the powerbi, I open the excel and refresh...
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
homboy27Helper III
Helper IIIHow to edit the underlying Power Query query?
Aburar_123
Solution Supplier
Solution SupplierHi 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.