Forum Discussion
Solved
Creating 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
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
yes it already exisits in my data set as a column. who does that it not work if its already in the dataset?