cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
sylfree9999
Frequent Visitor

Could not auto refresh the report if the datasource(csv file) is saved on OneDrive

Hi,

 

I've been reading a lot about puting the data source on the OneDrive. From my understanding, as long as I change the csv stored in OneDrive, PowerBI will auto sync the updated datasource, then the visualization within an hour. But unfortunately, it's not the case I am seeing. I have waited about 1.30hours and checked the refresh history, there is no OneDrive refresh history. Here are the scenarios that I have tried:

 

1. Just put the datasource file(csv) on the OneDrive

  • Create report in PowerBI Desktop
  • The DataSource is chosen from web -> OneDrive csv file link -> Organization Authentication
  • Publish to PowerBI service from PowerBI Desktop
  • Publish to Web from the PowerBI service
  • Change the csv data and save the changes in OneDrive
  • Wait for an hour to see if the visualization is updated  -->NO

2. Put the whole pbix file on the OneDrive

  • Create report in PowerBI Desktop
  • The DataSource is chosen from web -> OneDrive csv file link -> Organization Authentication
  • Put the pbix file on OneDrive
  • Go to PowerBI service -> Create New Report -> Get file from OneDrive
  • Publish to Web
  • Change the csv data and save the changes in OneDrive
  • Wait for an hour to see if the visualization is updated -->NO(I guess it will only update if I changed the pbix file, just the datasource file is not sufficient enought. Please correct me if I am wrong. BTW, If I was right about this, will it also update the dataset linked to the report?)

One thing worth mentioning is that if I manually refresh the dataset, wait for an hour, the visualization will change in both scenarios. So it seems that just the OneDrive sync is not working. 

 

Did I do anything wrong? Is it possible for PowerBI to auto refresh the dataset in scenario1(just datasource on OneDrive) without manual interference or without setting the SCHEDULE REFRESH?

 

Many thanks,

S

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support
Community Support

Re: Could not auto refresh the report if the datasource(csv file) is saved on OneDrive

Hi @sylfree9999

For scenario1, according to this article,

To use a OneDrive for Business file as a data source in the Power BI service, with Service Refresh enabled for that file, make sure you select OAuth2 as the Authentication method when configuring your refresh settings.

3.png

 

For scenario2, 

for Power BI Service, its direct datasource is pbix file stored on the OneDrive instead of file(csv) (original data source),

so by default only when you change the pbix, then refresh from Service, it reflects the changes.

Reference:https://docs.microsoft.com/en-us/power-bi/refresh-desktop-file-onedrive

 

Best Regards

Maggie

 

 

 

 

 

 

View solution in original post

Community Support
Community Support

Re: Could not auto refresh the report if the datasource(csv file) is saved on OneDrive

Hi @sylfree9999

In your scenario, when you go to dataset->setting ->schedule refresh, then you need to edit credential for this data source.

i don't find a option to change the data soucre to a web folder.

 

If you say connect to a web folder on OneDrive with Power BI Desktop, then publish to Service and set the refresh setting.

 

There is no built-in connector for OneDrive for business folder in Power BI, it is not possible to directly connect to the source.

To work around the issue in your scenario, you can sync the OneDrive for Business files to local folder of your computer, then use Folder connector in Power BI Desktop to get data from the local folder.

Or enter the following URL in SharePoint Folder connector, this way, you can connect to OneDrive for Business folder in Power BI Desktop.

https://mydomain-my.sharepoint.com/personal/user_mydomain_com

 

Additionally please refer to this thread which indicates a solution.

https://community.powerbi.com/t5/Integrations-with-Files-and/Need-to-load-all-Excel-files-in-a-given...

 

Best Regards

Maggie

 

 

View solution in original post

3 REPLIES 3
Community Support
Community Support

Re: Could not auto refresh the report if the datasource(csv file) is saved on OneDrive

Hi @sylfree9999

For scenario1, according to this article,

To use a OneDrive for Business file as a data source in the Power BI service, with Service Refresh enabled for that file, make sure you select OAuth2 as the Authentication method when configuring your refresh settings.

3.png

 

For scenario2, 

for Power BI Service, its direct datasource is pbix file stored on the OneDrive instead of file(csv) (original data source),

so by default only when you change the pbix, then refresh from Service, it reflects the changes.

Reference:https://docs.microsoft.com/en-us/power-bi/refresh-desktop-file-onedrive

 

Best Regards

Maggie

 

 

 

 

 

 

View solution in original post

sylfree9999
Frequent Visitor

Re: Could not auto refresh the report if the datasource(csv file) is saved on OneDrive

Hi @v-juanli-msft  Maggie,

 

Thanks for your reply.

I've changed the Authentication to OAuth2 according to your suggestion and it worked!

 

BTW, can I set the datasource to a web folder on the OneDrive?

 

Many thanks,

Ss

Community Support
Community Support

Re: Could not auto refresh the report if the datasource(csv file) is saved on OneDrive

Hi @sylfree9999

In your scenario, when you go to dataset->setting ->schedule refresh, then you need to edit credential for this data source.

i don't find a option to change the data soucre to a web folder.

 

If you say connect to a web folder on OneDrive with Power BI Desktop, then publish to Service and set the refresh setting.

 

There is no built-in connector for OneDrive for business folder in Power BI, it is not possible to directly connect to the source.

To work around the issue in your scenario, you can sync the OneDrive for Business files to local folder of your computer, then use Folder connector in Power BI Desktop to get data from the local folder.

Or enter the following URL in SharePoint Folder connector, this way, you can connect to OneDrive for Business folder in Power BI Desktop.

https://mydomain-my.sharepoint.com/personal/user_mydomain_com

 

Additionally please refer to this thread which indicates a solution.

https://community.powerbi.com/t5/Integrations-with-Files-and/Need-to-load-all-Excel-files-in-a-given...

 

Best Regards

Maggie

 

 

View solution in original post

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.