oData Data Source Credentials issue

[LoraBennett]

Hello all

I've mananged to publish 3 Power BI reports to our PBIRS successfully, all have in-built data source connections to oData, with the string provided from the published report themselves. 

Though despite the report being uploaded with an authentication type of Organization, when it gets to the server it's defaulted to Anonymous and therefore fails to reload.

I've tried changing this to both windows and then to basic, providing it  with the Power BI service account  credentials(which has an admin PWA licence and a Power BI Pro licence), however it tells me that my login or password is incorrect.

I've also asked another PWA Admin (who refreshes the same Power BI reports manually) to try his credentials to see whether it an issue with the service account however he also gets the same error.

Any ideas where I'm going wrong?

[Anonymous]

Hello,

I have similar problems.

In fact, all this account service thing do not have much documentation.

Can we have help on this?

thx

[LoraBennett · Accepted solution]

I eventually raised this with Microsoft themselves and got a response...connection to SPOL or POL is not possible with PBIRS.

Basically, Sharepoint Online REST API uses Forms Authentication and PBIRS doesn't support the forms authentication as Power BI Service does. Due to this Power BI Desktop can't authenticate against the REST API using OData type connections.

You can use Sharepoint Online Type connections to build a report against the SPOL site but this type of connection is not supported for server side refresh operations therefore would require manual update by the report designer, which means editing the report and pulling data  and saving to PBIRS again.

In a nutshell, computer says no.