Forum Discussion

silcambro's avatar
silcambro
Frequent Visitor
5 years ago
Solved

Incremental refresh best practice

 

Hello,

 

I have a table of 30 millions record in Azure Synapse Sql serverless and setup incremental refresh in my Power bi Desktop, everything works.

 

Now I need to apply some changes to the Power bi reports, what’s the best strategy? Do I need to refresh locally in Desktop and then publish or publish to the service and then refresh in the Power bi  service?

 

What is the best practice in this scenario?

 

Thanks

Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    Hi silcambro ,

     

    "Now I need to apply some changes to the Power bi reports, what’s the best strategy?"

    If you need to modify the data model and need to reconfigure incremental refresh, you must modify them in Power BI Desktop and then publish it to the Service again.

    If your incremental refresh plan does not need to be reconfigured and you do not need to modify the data model, then you can modify the report on the Service.

     

    Best regards,
    Lionel Chen

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

     

1 Reply

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi silcambro ,

     

    "Now I need to apply some changes to the Power bi reports, what’s the best strategy?"

    If you need to modify the data model and need to reconfigure incremental refresh, you must modify them in Power BI Desktop and then publish it to the Service again.

    If your incremental refresh plan does not need to be reconfigured and you do not need to modify the data model, then you can modify the report on the Service.

     

    Best regards,
    Lionel Chen

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