Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tehseennawaz
New Member

Deployment issue after implementing incremental refresh in powerbi report

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.

1 REPLY 1
v-yueyunzh-msft
Community Support
Community Support

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.