Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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,
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:
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.
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