Forum Discussion

Atif's avatar
Atif
Resolver I
7 years ago
Solved

Power BI Desktop Automatic Refresh

My excel file and Power BI report both are saved on Onedrive Personal.   In order to get the pbix file refreshed every hour I fetched data by "Get Data>Web" option using the URL https://onedrive.li...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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.

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Atif ,

As I know, if you use import mode when you get data, the data source in power bi desktop need to click refresh button to update manually. We only could set schedule refresh in power bi service.

So for your scenario, I think you need to manually click the refresh button.

Only the live connection and the direct query mode which will update automatically when you open the pbix in power bi desktop.

Best  Regards,

Cherry

 

 

Atif's avatar
Atif
Resolver I
7 years ago

v-piga-msftDear Cherry,

 

I am fetching data in Power BI Desktop by using "Web" option thereby providing URL of the relevant file duly saved on Onedrive Personal.

 

This option of linking data is used when the data is prone to change and is especially used to get data from the internet.

 

The basic reason of creating a report in Power BI Desktop is that it allows the required transformation and create measures.

 

Best,

 

Atif