Forum Discussion
OAuth Authentication method isn't supported for this datasource error Power bI dataflow
I have a dataflow and I am using below connectors to connect to data. until this morning all scheduled and on demand refresh were working fine and now I am getting series of errors within my dataflow (roughly 11 erros in different Workspaces and all occuring in dataflow)
I tried opening the dataflow and went through all the Applied steps in Power query IN PBI Service save and close the dataflow, no issues here, and then when I hit refresh it then fails the refresh throwing below shown error
ALl our datasource are in the cloud and we DO NOT use any gateway to connect,
3 Replies
NOTE: I have also tried changing the all 4 privacy levels, (Private, Organizational, Public, None) but the same error crops up, any hint or solution how to solve this is highly appreciated, Thanks
Hi smjzahid
If your data source require authentication through OAuth or Azure Active Directory-based authentication and the URL is correct, you can use the built-in Web or OData connectors to authenticate, you can refer to the following link:
Authentication with a data source - Power Query | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Just had this with a brand new environment, uploading a PBIX and connecting for the first time. The connection worked fine in PBI Desktop, but I got the error above when I tried to set the "Data Source credentials" in the App Service settings. I found that if you tick the "Skip test connection", then refresh your dataset, it actually worked. Seems to be something wrong with the test connection:
