Forum Discussion

tehseennawaz's avatar
tehseennawaz
New Member
3 years ago

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 Re...
Need Help
v-yueyunzh-msft's avatar
v-yueyunzh-msft
Community Support
3 years ago

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