Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Get data from SharePoint Online

I have an excel online file stored in a sharepoint 365 document library. I had tried get data from a Sharepoint Folder and also from Odata and enter the Sharepoint site URL However when I do this by...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi,

Please try the below steps,

Power Bi Desktop-Go to-File-Options & Settings-Datasource Setting.

First remove sharepoint credential from the list and again add share point site with below settings,

Credentials:Organizational Account

Privacy Level:none

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello，

    I had reset the data source as you said but the error message is as below.

    I am sure that I signed in in the same ID of the sharepoint, is there any possibility that the reason is because of the sharepoint permission?

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

      Please click on "sign in as diffrent user" and try it or use WINDOWS (second options) authorization. 

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        I had tried both of the suggestions but I only have one ID so that I can only signin by the same Identity.

        eventhough I use the  "sign in as diffrent user", the same result come out with the same ID.

        Thank you for your reply but unfortunately none of them can solve this...