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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors