Dataflows credential issue when connecting to a database table in Azure SQL Server

Question

I have a database table created in Azure SQL Server. From SSMS, I use "Azure Active Directory - Universal with MFA" authentication to connect.

I've been informed that the server is configured with disabled public network access, so we

Had the Power BI gateway vm "whitelisted" on the Azure SQL server
In the dataflow, we use the gateway to connect.
Created a database user account for the dataflow connection.

However, we still get "invalid" credential error. Do I miss anything? Thank you for the help.

Did you set the user as active directory admin in SQL server ? — Bhavani
– Bhavani, Commented Jun 28, 2023 at 17:18
@Bhavani The database user account is "test". You mean setting "test" user as active directory admin in Azure Portal? No, we didn't. — Glyphfever
– Glyphfever, Commented Jun 28, 2023 at 21:18
Are you having issue with PowerBI or SSMS ? Could you please add some more information? — Bhavani
– Bhavani, Commented Jun 29, 2023 at 7:39
@Bhavani No, I don't have issue in Power BI desktop or SSMS. The connection credential issue only occurs in creating a dataflow. — Glyphfever
– Glyphfever, Commented Jun 29, 2023 at 11:46
Did you check credentials which you are provided are correct? — Bhavani
– Bhavani, Commented Jun 30, 2023 at 13:54

Naveen Sharma · Accepted Answer · 2023-07-03 15:48:29Z

0

I created User “test” in my database db from created login using below code:

CREATE USER [test] FOR LOGIN [testLogin];

I tried to create dataflow with Azure SQL server I got the same error:

enter image description here

Even though I have given correct credentials I am getting above error. In my case issue is with my database name when connecting to database I have given"[db]" as database name instead of “db” I resolved the issue by giving proper name of the database.

enter image description here

It connected successfully without any error:

enter image description here

answered Jul 3, 2023 at 15:48

Naveen Sharma

1,5541 gold badge6 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Dataflows credential issue when connecting to a database table in Azure SQL Server

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related