PBI cloud datasets can connect to AD universal MFA?
The connection to the synapse analytics uses AD Universal MFA as the authentication method, and I am able to successfully connect to Synapse using SSMS and Power BI Desktop. However, I am unable to refresh the published PBI dataset, which is pointing to Synapse, on power BI services with auth2 connection.
For Power BI gateway setup we have only 2 types supported i.e. Basic and OAuth.
What type of connection authentication needs to be created for Synapse and Power BI cloud?
You can't have MFA set on a userid that is doing automatic refresh. Therefore, the best way around this is to have a service account or other account that does not require MFA and then the automatic refresh will work fine. This is more the issue that I think you are encountering than the type of connection.
Did I answer your question? Mark my post as a solution!
Proud to be a Datanaut! Private message me for consulting or training needs.