cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Helper I
Helper I

Power Query downloads data from local disk (temp) instead of sharepoint

Hi PBI community,

 

I am experiencing an issue with Power Query. I have set my data source as sharepoint, however for some reason the actual source that is used when updating datat is on my local computer in Temp folder. I need it to update only from sharepoint. I already cleared the cache but it didn't help. Please advice, thank you. 

download_error.png

5 REPLIES 5
Community Support
Community Support

Hi @michael163 ,

 

What's your data source? SharePoint folder, SharePoint Online List or SharePoint list?

sharepoint.JPG

 

 

Best regards

Icey

Hi @Icey , I use SharepointFolder

Community Support
Community Support

Hi @michael163 ,

 

Is the site url when connecting typed like this: https://company.sharepoint.com/sites/yoursite

If not, please change it.

If it is, please try to

  • clear the data source permission and re-connect to it;
  • upgrade Power BI Desktop to the latest version: 2.87.1061.0.

 

data source.jpgclear.JPG

 

 

In addition, is this the case for all reports where the data source is SharePoint Online?

 

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

Hi @Icey , I did everything you said:

- updated PBI

- cleared and reconnected permissions

- I already had the name right

 

However I still get the same result

michael163_0-1606815645084.png

 

Addition: I have similar cca 10 apps running with sharepoin connection and everything besides this one works correctly.

Community Support
Community Support

Hi @michael163 ,

 

This is so strange.🤔

Then, I'll suggest you create a support ticket to get further help. 

 

Support Ticket.gif

 

 

Best regards

Icey

 

If this post helps, then consider Accepting it as the solution to help other members find it faster.

Helpful resources

Announcements
secondImage

Happy New Year from Power BI

This is a must watch for a message from Power BI!

December Update

Check it Out!

Click here to read more about the December 2020 Updates!

Community Blog

Check it Out!

Click here to read the latest blog and learn more about contributing to the Power BI blog!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors