Power BI Desktop data refresh

[sokninn]

Dear All Friends;

I would like to make more understand about the data refreshing workflow. After data refreshing have done by power BI service through scheduling in the gateway. So we can see the report update in our service and also mobile. And what's about the desktop? They have refreshed also?

Please help to explain to me as your kind everyone (^_^)

Mr. Soknin

[v-xicai · Accepted solution]

Hi @sokninn ,

The Power BI Desktop is designed as a development tool, and the Power BI Desktop files are static files. As such an auto-refresh doesn't make sense and isn't practical. If you make changes on the desktop file, there is no immediate link between that change and anything you have published.  When you next publish, it will overwrite whatever dataset/reports you have created with the same name.  Most of the time you are doing this with just changes to an existing files, so generally things like Dashboards often continue to work.

While The Power BI Service is like a sharing and consuming portal, the online environment can be connected to a gateway that can implement the data refresh. If you make changes online , and you want to keep those changes also work on the desktop file, you can select the dataset online and select the option "Download .pbix", which will show the change in Desktop once you open the pbix file.

In a word ,the change on Power BI Service will not sync change on Desktop for the same original created and published pbix file.

If you need the data of Power BI Desktop is the same with data source, the way to implement data refresh will be different according the way of getting data. when your data is gotten in Import mode, once the data source changed, you need to import the changed data again. When your data is gotten in DirectQuery mode or Connect live mode , you can click the refresh button under Home ribbon to get the newest data of data source.

You can learn more: https://docs.microsoft.com/en-us/power-bi/refresh-data .

Best Regards,

Amy

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

[sokninn]

Dear @v-xicai 

I would like to say thank you so much for your help to explain to me. Now I got it clearly. 

Thank you so much again

Best Regards;

Mr. Soknin 

[vivran22]

@sokninn 

Hello Mr. Sokninn,

As per my understanding and experience, Power BI Desktop doesn't have the functionality of auto refresh. You need to manually refresh the dataset using the Refresh button on the Home tab.

Hope this answers your query.

Regards,

Vivek