Forum Discussion
Power BI Desktop Automatic Refresh
Power BI desktop is a development tool. If you are talking about an Import model, its a static file that only updates when you update it. Its not different to a word document or excel file. You can't automatically refresh the static file. You need to open it with Power BI desktop and click refresh if you want to download new information.
If you have a live connected power bi file, it will always be up to date as the data never lives in the file.
Automatic refresh on the service is different, because the service hosts the file and organises the periodic refresh.
Thanks for the response Anonymous.
My primary concern is that my Power BI Desktop file is not getting refreshed. Although it is supposed to get updated on hourly basis.
For Power BI Service I have fetched pbix file from the Desktop. Since my excel file and pbix file both are on Onedrive Personal I received the following message.
You don't need a gateway for this dataset, because all of its data sources are in the cloud, but you can use a gateway for enhanced control over how you connect.
The Power BI Service is also supposed to get updated on hourly basis while the Schedule Refresh will take place @ 0000 hours tomorrow. Let's see if any of the two or both update work.
Your .pbix file will not be refreshed. When you publish to the service it makes a copy of your model. When you set up the refresh it is the model in the service (PowerBI.com) that pulls the data. Your .pbix will only update if you open it and hit Refresh.
Thanks a bunch jdbuchanan71.
Does this mean that files requiring some sort of transformation etc. created on the desktop version can only get refreshed manually?
Does this mean that if someone wants to have the data refreshed automatically s/he should use Power BI service and that the desired output should only be carried out in data file(s)?
Best,
Atif
Power BI desktop is a development tool. If you are talking about an Import model, its a static file that only updates when you update it. Its not different to a word document or excel file. You can't automatically refresh the static file. You need to open it with Power BI desktop and click refresh if you want to download new information.
If you have a live connected power bi file, it will always be up to date as the data never lives in the file.
Automatic refresh on the service is different, because the service hosts the file and organises the periodic refresh.
Thank you! Anonymous.