cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Unable to refresh data connected to SharePoint

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!

 

3 REPLIES 3
v-chenwuz-msft
Community Support
Community Support

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
Not applicable

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
Super User
Super User

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

 

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Difinity Conference

Difinity Conference 2022

Difinity is the largest Microsoft Data, AI, Power BI, Power Platform and Business Applications Conference in New Zealand.

European Share Point Conference

European Share Point Conference

This conference returns live and in-person in Copenhagen this 28 November-01 December with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.