Data Source Changes in Incremental Refresh

[vikramkumawat]

Hi,
I Need some help regarding Incremental refresh. 
I have created a report using SQL data and implemented Incremental refresh in that. I have created a parameter to switch data source from dev to prod,And I can not chagne parameter in desktop.
but In this I am facing an issue that when I have published the report and changed the parameter and refreshed the report, it only updated the data of refresh parameters range, and Achive partition data is still of older datasource.
I need help to understand the possible cause and the solution for this issue. 
Thanks!

[v-yilong-msft · Accepted solution]

Hi @vikramkumawat ,

Based on your problems, here are my answers.I think you need to perform an initial full refresh after changing the data source. In another way you can verify the incremental refresh policy settings in Power BI Desktop. This document may help you: Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft...

One thing you mentioned is you can not change the parameters in Desktop, so consider using Power BI Services to update the parameters.

Also this document may help you too: Edit parameter settings in the Power BI service - Power BI | Microsoft Learn

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FarhanAhmed]

This is because when you publish a report, it published with data and data model.

In your case, you are changing the parameter of data source at PBI Service. In this case data that already resides in PBI Dataset will remain as is unless it will overwrite for that period of time.

Or you must use the data of PRD while publishing the report.

One more thing that you can do it to save the file as PBI template. It will remove all the data from the file. Use this file to save again your PBIX file without refreshing the data, then upload this file in PBI Service and refresh the data model, this probably will resolve your issue.