Refresh data automatically if .xls / .pbix are saved in oneDrive for business

[Anonymous]

Hi all,

I have read that reports in online services refresh dataset every hour if source is saved in onedrive for business.

I load data from an excel file (table) to powerbi desktop app and created a report - both files are saved in onedrive for business, but my dataset does not refresh accordingly within an hour? I've waited several hours by now. 
Have I misunderstood? 

[sagarsankhe]

Hi Lin,

Is there a way I can find exact path of the PBIX file placed on OneDrive using REST API ?

I tried using imports, but it only shows that "source": "Sharepoint". It does not show path. 

Thanks,
Sagar S

[v-lili6-msft · Accepted solution]

hi  @Anonymous 

Onedrive refresh is that you upload .xls / .pbix file to onedrive and then in power bi service you click get data->file->onedrive-business, now onedrive refresh is available.

https://docs.microsoft.com/en-us/power-bi/refresh-data#onedrive-refresh

Regards,

Lin

[Anonymous]

Hi @v-lili6-msft - thank you!