Forum Discussion

michael163's avatar
michael163
Helper II
5 years ago

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. 

Need Help

5 Replies

  • Icey's avatar
    Icey
    Community Support
    5 years ago

    Hi michael163 ,

     

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

     

     

    Best regards

    Icey

      • Icey's avatar
        Icey
        Community Support
        5 years ago

        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.

         

         

         

        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.