Unable to refresh SharePoint data

[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!

[edhans]

Why are you not bringing in the files via SharePoint.Files or SharePoint.Contents? Those are much more suited to rapid ETL for CSV/XLSX and other files if it is in SharePoint vs opening it effectively as a web view and scraping it.

And I've never had refresh issues using the SharePoint* connectors.

To use SharePoint.Contents, just connect to SharePoint then change the function in the Source line. The difference between Files and Contents is Files shows all files, then you filter down. Contents lets you navigate to a particular folder, which is often faster than the Files connector.