cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
qyz225 Frequent Visitor
Frequent Visitor

Sharepoint List: OData refresh with organisational account

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:

Capture.PNG

 

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

 

 

 

 

 

4 REPLIES 4
Moderator v-yuezhe-msft
Moderator

Re: Sharepoint List: OData refresh with organisational account

@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.
1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
qyz225 Frequent Visitor
Frequent Visitor

Re: Sharepoint List: OData refresh with organisational account

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?

Moderator v-yuezhe-msft
Moderator

Re: Sharepoint List: OData refresh with organisational account

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dunbarko New Member
New Member

Re: Sharepoint List: OData refresh with organisational account

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?