Forum Discussion

Tim1234567890's avatar
Tim1234567890
Frequent Visitor
5 years ago

Edit Credentials only showing Anonymous

Hello,

after publishing my Power BI Report from Desktop into a workspace, i tried to authenticate the connection to the Sharepoint List, as usual.

--> Settings --> Datasource Authentication --> edit credentials --> Microsoft Account --> Login --> Done

 

When selecting "Edit credentials" i usually get the option to select from Anonymous, Windows/ Microsoft Account or OAuth2 Account.

Somehow for this specific Datasource I can only select Anonymous, the other Reports which refer to similar SharePoint Lists, don't have this complication.

This leads to the problem, my SharePoint won't allow me to access my Data, because I cannot properly authenticate my credentials.

 

Has anyone faced this issue before? 

I've tried to:

- only republishing the report

- set credentials in Power BI Desktop (even refreshing works here without an issue)

- deleting and republishing the report  & Datasource

- reloading Browser

9 Replies

  • I had the very same problem and finally found out why (at least for me). By default, the SharePoint Online URL that Power BI used included the http protocol instead of https. (Seems like a bad decision to me.)

    The protocol is actually hidden when selecting the data source. I was able to edit the data source to https... in PBI desktop without losing anything.

     

    • Tim1234567890's avatar
      Tim1234567890
      Frequent Visitor

      Hello GilbertQ,

       

      thanks for your reply.

      I cannot really answer your question, as I do not properly know, where to find that information. Maybe it will help if I specify a little more, what I'm trying to do.

       

      Attached you find a picture of the issue I'm facing. I have published the report into Power BI Online, and I'm trying to verify my credentials, so I can set up an automatic refresh.

       

      The report refers to a SharePoint List containing not documents, but elements which I'm using to create the report.

      I cannot really decide, which API to use, as I only publish the report and already get this message. Also i cannot recall to ever have to specify which API I want to use. 

       

      Hope this helps..

       

      Best regards

      Tim

       

       

       

       

       

      • GilbertQ's avatar
        GilbertQ
        Super User

        Hi Tim1234567890 

         

        You could please need to go through the link I sent which explains in detail how to change the API version and see if that works.