Forum Discussion
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...
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
That's very strange. OAuth2 is the right protocol for SharePoint Online, I'm not sure why you would be getting an error that it is not supported. I have used it successfully in the past although I am going to give it another try just to be sure.