Unable to refresh data connected to SharePoint

[Anonymous]

Hi everyone,

I am trying to build a report. Data source is CSV file saved on SharePoint of my organization. I have used the path of sharepoint to import CSV using 'Web' source in PowerBI. Once the file is imported, I run a python script on it. 

Now everytime I update CSV file, I want to update my report automatically/manually. 

I used following resources to do this:

1. Refresh a dataset created from a .CSV file on OneDrive or SharePoint Online
2. How to add a REFRESH DATA BUTTON in your Power BI Reports using Power Automate // Beginners Guide

But data does not refreshes. I have also tried with Excel but no luck. 

The error is: Data source error: Unable to refresh the model (id=97xxxxxx) because it references an unsupported data source.

Also, when I checked under Settings -> Datasets: It throws following error: You can't schedule refresh for this dataset because the following data sources currently don't support refresh: Data source for Query1

Also, under Settings -> Dataset, I cannot see any refreshing options though file has been imported from SharePoint/OneDrive. (Note: I have used file path from SharePoint which is https/orgnization/sharepoint/folder/file.csv  )

Note 2: I not looking for scheduled refresh. I want automatic refresh once CSV data on SharePoint/OneDrive is updated or manual trigger using Power Automated (as mentioned in the above-mentioned links). 

Does anyone has idea why it is not refreshing?

Thanks!

[v-chenwuz-msft]

Hi @Anonymous ,

Is that you use a python script in power bi? If yes, you need a personal gateway to refresh the data than standard gateway. 

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

As the first link which I have shared, mentions that SharePoint or OneDrive data can be refreshed automatically or manually. Once I edit the data on either SharePoint or OneDrive, PowerBI shoud automatically (or manually) refresh which is not happening. 

The link you have shared uses reverse of what I want. I want PowerBI to refresh (just like PowerBI Desktop 'refresh' button).

[TheoC]

Hi @Anonymous 

Unfortunately you cannot set up a Web source to refresh.  This is a limitation in Power BI to the best of my knowledge.

However, you can use the "Sharepoint" data source (Sharepoint Data Source Link) and this should eliminate the issue.

Hope this helps.

Theo