Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Load xlsx from sharepoint // load more excel files from sharepoint folder

Hello all,

We have a sharepoint were weekly reports are uploaded in the "2019" folder which is inside the "Weekly Reports" folder on our teams sharepoint.  I have 2 issues:

1) can't connect power bi to any of the excel files on the sharepoint, I get "contains corrupted data "  when trying to get the file from sharepoint.  When I save the file from sharepoint on my PC and load in power bi from pc, it works. This is the address I enter to load from: https://"mycompany".sharepoint.com/teams/$$$$$$$$$/Weekly%20KPI%20Reports/FY%202019/week%2012.xlsx?web=1 

errors below for the link with and without the "?web=1"

 

2) I'd like to be able to link BI to connect to get data from a folder inside a sharepoint folder , how do I do that ? 

 

Thanks,

 

Mihnea 

 

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks for help.

      The video is not helping me a lot. 

       

      In BI I don;t get (anymore) to the sign in options (Anonymous / Windows / Organizational account) even though I tried to get data several times from the sharepoint. 

      How do I get the option to sign in again?

      When I try to access the same sharepoint in BI and in Excel Power Querry, in BI I get the error and in Excel it works....

       

      • vanessafvg's avatar
        vanessafvg
        Icon for Community Champion rankCommunity Champion
        7 years ago

        Anonymous  what version of power bi desktop are you on?

         

        i think you can remove your settings in your global settings - file /options / data source settings.  you can clear your logins there and try relogin.