Forum Discussion

jwadams's avatar
jwadams
New Member
10 years ago

Cannot schedule or demand a refresh for SharePoint Online List in Power BI

I have a power Bi file that was created in Power BI desktop and published. The data sources are a sharepoint online list and a local excel spreadsheet. When I go into Power BI I can see the report an...
Need Help
jwadams's avatar
jwadams
New Member
10 years ago

I read about using the OAuth option but when I select OAuth2 from the list,  it says "The OAuth authentication method isn't supported for this data source. Contact your admin."

 

 

 
When I try to refresh now, I get the following which I think is because the SharePoint credentials aren't set correctly.
 
Something went wrong.
 
An error occurred while processing the data in the dataset.

 

Data source type
Processing errorThe credential stored in the cloud is missing.
Cluster URIWABI-WEST-US-redirect.analysis.windows.net
Activity IDc36f048a-3935-41fb-9e22-1f37bbde382b
Request ID6e926297-3d47-7da1-02d6-e69bb4a6e838
Time2016-03-14 21:21:17Z

 

Between this and the fact the drill doesn't work on the dashboard, it may be that Power BI is not quite ready for how we would like to use it.  I'm hoping not but seems like using O365 with anything seems to be problematic.

 

Thanks.  -JA

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

jwadams - OK, I just tested this. I created a new PBIX file in Desktop and connected to a SharePoint Online list. I used Organizational Account in Desktop to connect. I then published to Power BI Service. In Power BI Service, clicked the data set's ellipses and whent to Schedule Refresh. It told me that my data source credentials were invalid. I hit "Edit credentials" and chose OAuth2 and it made me log in to O365 account (work/organizational account) and everything seems good to go. 

 

I'm not sure why you would receive that OAuth2 is unsupported unless you aren't really connecting to SharePoint Online but rather SharePoint on-premises? Can't think of what else might be going on there.