Edit Credentials only showing Anonymous

[Tim1234567890]

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

[innov8iv]

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.

[GilbertQ]

Hi @Tim1234567890 

What happens if you change it to version 14?

[Tim1234567890]

Hi @GilbertQ That wont work as well. Version 15 is working on the other Reports.

[GilbertQ]

Hi @Tim1234567890 

I am not sure what else to do, it has worked for me in the past!

[Tim1234567890]

Hi GilbertQ,

sadly i still cannot change my authentification method from anonymous.

In Power BI Desktop it works for this exact report, sadly not in Power BI Online....

Any ideas?

Best regards

Tim

[GilbertQ]

Hi @Tim1234567890 

What version of the SharePoint API are you using as there is version 14 and version 15?

SharePoint.Contents - PowerQuery M | Microsoft Docs

SharePoint Folder Connector fails for API 15 - Microsoft Power BI Community

You could also connect using Excel and putting in the SharePoint URL and see if that resolves your issue?

[Tim1234567890]

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]

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.

[Tim1234567890]

Hi GilbertQ,

thanks for your reply, when I'm in Power BI Desktop, I can normally update the Dataset and select, which authentication I want to use.

When going for that information in first link, I'm receiving information, that it's ApiVersion = 15.

Best regards

Tim