Forum Discussion
PowerBi Desktop data refresh and export to PDF
Hi Anonymous,
1. How many data sources are there? Do they all use that parameter?
2. Did you apply the changes?
3. Did you refresh the report before exporting a PDF?
Best Regards,
Hello v-jiascu-msft - Thanks for getting back. please find below respose to your questions.
How many data sources are there? Do they all use that parameter?
Report is using single data source (Azure SQL server). Location level parameter is used to calculate most of the measure against this data source.
Did you apply the changes?
We go to “Edit Parameter” and select the location , Apply changes
Refresh Location Parameter table manually. This additional step is taken because only after refreshing the parameter table the value of parameter is updated/refreshed.
Did you refresh the report before exporting a PDF?
We were not refreshing the whole report as till very recently all the visualisations were getting refreshed (with correct values) after following steps mentioned above.
But after encountering this issue as a workaround we have tried refreshing the whole report also but still we have found reports retaining values with the old parameter rather than the updated one.
I don't think issue is with export to PDF, its with refresh of data set/visaulization after change in parameter.
Hi Anonymous,
I agree with you. The issue should be from the refreshing of dataset or reports.
1. What will happen if you interact with the retained values?
2. Which version of the Desktop do you have?
3. Which visuals? Are they custom visuals?
4. Could you make it more clear, please? Location level parameter is used to calculate most of the measure against this data source. I'm afraid we can't use a parameter in a measure. Maybe you did something else.
Best Regards,
What will happen if you interact with the retained values?
We don’t interact with retained values – this is a scorecard and after refresh just needs to be published to business stakeholders using PDF exports.
Which version of the Desktop do you have?
2.65.5313.1381 64-bit (December, 2018)
Which visuals? Are they custom visuals?
We are not using any custom visuals – we are using all PBI pre-packaged visuals (tables, matrix and graphs/line chart) all of them have issue.
Could you make it more clear, please? Location level parameter is used to calculate most of the measure against this data source. I'm afraid we can't use a parameter in a measure. Maybe you did something else.
We use input parameters to build measures using DAX.
Find below example of one of the measures – it is using 2 parameters (snapshotDate and SiteLocation) to calculate MTD revenue based on SiteLocation
MTDRevenue = CALCULATE(SUM('MeasureAggregatedGL'[MTDAmount]),FILTER(MeasureAggregatedGL,MeasureAggregatedGL[Lineage]="Actual"),FILTER(SitePnL,SitePnL[GLHierarchyCatDesc - Copy.2]<>"OtherIncome"),FILTER(ALL(SitePnL[GLHierarchyCatDesc]),SEARCH("Revenue_",SitePnL[GLHierarchyCatDesc],1,0)>0),FILTER('MeasureAggregatedGL',MeasureAggregatedGL[SiteLocationDim.Site]=SELECTEDVALUE(SiteLocation[SiteLocation])),FILTER(MeasureAggregatedGL,MeasureAggregatedGL[Date.End of Month].[Date]=SELECTEDVALUE(SnapshotDate[SnapshotDate])))