Sharepoint List: OData refresh with organisational account

[qyz225]

Hi all

I just hopt to find a way to use organizational account for dataset refresh.

I created a report to pull data from sharepoint list, via Organizational Account. The report worked fine in Power BI Desktop.

However when the report was deployed into Power BI Service, I got the error "Your data source cannot be refereshed because the credentials are invlaid...". Opened the credential configuration I couldn't find organizational account option:

Anyone knows how to get organizational account option in the setting? Thanks in advance.

[Dunbarko]

Hi all, i have same problem with files on One Drive, Power BI Pro desktop refresh working, Cloud Power BI don't, but OAuth2 authentication type or Organizational account is not on the list, just Anonymous, Windows, Basic. Anyone know how to help?

[v-yuezhe-msft]

@qyz225,

Do you connect to SharePoint online list or on-premises SharePoint list? If you connect to on-premises SharePoint list, please use Windows credential to connect to the data source in Power BI Desktop. 

However, if you connect to SharePoint Online list, gateway is not required, and you should be able to find OAuth2 authentication type.


Regards,
Lydia

[qyz225]

Hi Lydia

Thanks for the response.  However the situation is the sharepoint list is hosted in another on-premise space, so I have to use organizational account to access the list.

After configure the data source via organiational account, the report can be refreshed locally, without any issue.

However when deployed into Power BI service, the organizational account option is missing from Edit Credential dropdown box.

I had tried to use data sources such as oData service and Sharepoint List, I also tried to embed the basic authentication string into the http header through api call. But it seems I have to use organizational account to pass the authentication setting.

Does that mean we cannot feed data from different domains?

[v-yuezhe-msft]

@qyz225,

You connect to on-premises sharepoint list, right? If so, try to configure Windows Pass-Through Authentication, and use Windows type credential to connect to the data source.

Regards,

Lydia