Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
When adding Azure SQL Database to the gateway using OAuth2 authentication, it failed with the following message.
I tried 2 different accounts:
Both of them are in AAD and added to the `db_datareader` role in SQL Database. Both can access the data in Power BI Desktop.
Any insights and/or solutions are very much appreciated.
Thanks.
Hi @Anonymous,
What type of data source are you work? Azure SQL or SQL server that hosts in an azure VM?
If you mean the second one, you need to double-check your gateway client to ensure it can be accessed to that VM and data source. (according to the error message, it shows the '400' error which means the request/access invalid)
Regards,
Xiaoxin Sheng