Forum Discussion

LoraBennett's avatar
LoraBennett
Frequent Visitor
6 years ago
Solved

oData Data Source Credentials issue

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....
Need Help
  • LoraBennett's avatar
    LoraBennett
    6 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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's avatar
LoraBennett
Frequent Visitor
6 years ago

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.