Deployment issue after implementing incremental refresh in powerbi report

[tehseennawaz]

We have powerbi reports that load data from azure sql database. We develope reports on DEV database and then deploy powerbi report on DEV, QA and PROD. We had a powershell script in which we use a Rest Request to replace the datasource during deployment. It was working fine, recently we had implemented incremental refresh. After that when i deploy on QA, 'replace data source' thastep failed. I had debug that powershell script it keep the DEV datasource and also add QA data source instead of replacement.

[v-yueyunzh-msft]

Hi , @tehseennawaz 

Based on your issue description, you are using the incremental refresh now for the rest API "dataset update data souce" calling using PowerShell script has failed, I think this is mainly because the incremental refresh dataset has the partitions created which may cause some error between the usage of the rest API "dataset update data souce". May due to the difference in partitions with your old and new datasets.

However, I just found actually there's one official-provided feature called the deployment pipeline with rules to change data source during the pipeline process, you may consider directly use it instead of performing API calling using PowerShell script, and it can support the incremental refresh dataset:

Overview of Power BI deployment pipelines - Power BI | Microsoft Learn

The Power BI deployment pipelines process - Power BI | Microsoft Learn

Thank you for your time and sharing, and thank you for your support and understanding of PowerBI! 

Best Regards,

Aniya Zhang

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