Refresh SharePoint online list on Power BI Premium report

[ScottyR]

I have a Power BI Premium report that connects to an Oracle database (on premise) and a SharePoint list (online - actually a document library)

I have a gateway for the oracle refresh that is working fine. However, I can't figure out how to set up refreshes for the online sharepoint list data.

It works fine on PowerBI desktop using my "Organizational Account"/"Microsoft Account" credentials. But in Premium, the only credential options I have are "Anonymous" and "Windows". Neither of these work.

Any ideas?

[v-diye-msft · Accepted solution]

Hi @ScottyR 

Please kindly refer to the official document:

https://docs.microsoft.com/en-us/power-bi/refresh-desktop-file-onedrive 

https://docs.microsoft.com/en-us/power-bi/refresh-data#accessing-on-premises-and-cloud-sources-in-th... 

and the trouble-shooting blog:

https://www.qumio.com/Blog/Lists/Posts/Post.aspx?ID=44 

and make sure you've ticked the option under your gateway:

[GilbertQ]

Hi there

if you have got a SharePoint Online list it would have to via the Gateway if it is in the same Power BI report as the Oracle source.

I would suggest creating the data source in the Gateway?

[ScottyR]

you wrote "if you have got a SharePoint Online list it would have to via the Gateway if it is in the same Power BI report as the Oracle source. I would suggest creating the data source in the Gateway?"

I'm not sure what you mean by that. Do you mean create a gateway for the sharepoint online source? If so, I can't do that. It only provides "Windows" and "anonymous" credentials options. Neither of them work.

[GilbertQ]

Hi there

Do you connect to SharePoint online using a URL?

If so there should be an option to use an Organizational account?