Publish without refresh

[thanksforhelp22]

Hi

I have made changes to the query and saved the desktop PBI file. I don't want to refresh because there is around 14 millions records in one query and my bandwidth is very bad it will never complete. I want to publish and schedule it to run. Old version of schedule is working fine with 2 hrs of refresh time. Please help with the workaround.

thanks

[v-xinruzhu-msft]

Hi @thanksforhelp22 

When you publish the report to the service, the report will not refresh automatically unless you schedule a refresh, you can schedule a refresh after republishing the report to the workspace, you can refer to the following link.

Configure scheduled refresh - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

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

[thanksforhelp22]

Hi, my question will all the changes made to the query will be applied without complete refesh. since when I open the local copy in my desktop it keep saying. I am saving the file with appy later option.

yes, I can schedule refresh later in the service for updated data.

thanks  

[v-xinruzhu-msft]

Hi @thanksforhelp22 

If you make changes in query, you need to update them if you want to apply them to desktop, otherwise your changes will not be applied to the table.

Best Regards!

Yolo Zhu

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