Unable to connect Power BI to SQL server db on the same computer

[Sachinhitachi]

Hi All,

I am unable to connect with Azure SQL DB views using Dataflows in Power BI service.

In SSMS, I use MFA Authentication to login to server and DB.

We are planning to move to Dataflows frmo Azure Analysis services. Is this option apt a switch ?

Thanks in Advance 🙂

[v-lili6-msft]

hi, @Sachinhitachi 

What is the error details, could you share the screenshot?

and if you have set it well as below:

https://docs.microsoft.com/en-us/power-bi//service-dataflows-data-sources

https://docs.microsoft.com/en-us/power-bi//service-dataflows-create-use

Best Regards,
Lin