Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
AKhan
Regular Visitor

Power Bi sharepoint access CSV files and auto refresh

Hi all,
I have created a Report in Power Bi desktop with sharepoint that has a folder and many CSV files.
The report is working fine but auto refresh(Within 1 hour) is not working.
Any suggestions.
 
Thanks
 
share_5.png

 

1 ACCEPTED SOLUTION

@AKhan,

I test the scenario as yours.

What changes do you make in your report? If you want to make hourly refresh work after making changes to CSV files, please directly connect to the CSV stored on SharePoint Online folder from Power BI Service rather from Power BI Desktop.

However, when you connect to CSV files from Power BI Desktop, you would need to store the PBIX file in SharePoint online, then connect to the PBIX file via "Get Data->Files->SharePoint Team Sites" entry in order for automatic refresh to work. In this case, when you add new measures, change column names, or edit visualizations in Power BI Desktop file, once you save, those changes will be updated in Power BI , usually within about an hour. When you make changes in the CSV file, you can only manually refresh the dataset by using Refresh now or set up a refresh schedule by using Schedule Refresh. For more details, please review this article.

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
v-yuezhe-msft
Employee
Employee

@AKhan,

Do you store the CSV files on SharePoint Online folder or on-premises SharePoint folder?

Automatic refresh is possible when you store CSV files on SharePoint Online. And please publish your Power BI Desktop file to Power BI Service, then go to Settings->Datasets and find your dataset in Power BI Service, make sure you edit the credential for the SharePoint Online data source.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Lydia Thanks for reply,

 

 

sorry, for delay response beacuse I was on leave but Auto refresh is not working.

 

 

Thanks

Are you looking for a way to set up scheduled refresh on the Server to get updates from SharePoint Online document library merging all new files rather than updates on individual files?

Anonymous
Not applicable


@jwang_QAL wrote:

Are you looking for a way to set up scheduled refresh on the Server to get updates from SharePoint Online document library merging all new files rather than updates on individual files?


@jwang_QAL Yes this is what I am looking for!

@AKhan,

I test the scenario as yours.

What changes do you make in your report? If you want to make hourly refresh work after making changes to CSV files, please directly connect to the CSV stored on SharePoint Online folder from Power BI Service rather from Power BI Desktop.

However, when you connect to CSV files from Power BI Desktop, you would need to store the PBIX file in SharePoint online, then connect to the PBIX file via "Get Data->Files->SharePoint Team Sites" entry in order for automatic refresh to work. In this case, when you add new measures, change column names, or edit visualizations in Power BI Desktop file, once you save, those changes will be updated in Power BI , usually within about an hour. When you make changes in the CSV file, you can only manually refresh the dataset by using Refresh now or set up a refresh schedule by using Schedule Refresh. For more details, please review this article.

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors