2

I am trying to connect to azure database from Power Bi. I can connect to the database using Managment studio and I can connect using power bi if I do not specify the database name.

If I put the database name (needed when I want to run a query), PowerBI not not connecting and it's telling me that the IP address is not registered (I have added the IP address on the azure firewall, which is proved by the fact I can perfectly connect and import tables if I just put the server name).

Improve this question

1 Answer 1

Reset to default
2

step 1 clean the stored credentials in the power bi -file>option and setting> data source setting> find your azure server and delete/clear permission

and then try to login to your azure sql

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

2 Comments

it worked! Fantastic! I had asked several colleagues that work with PowerBI and nobody knew the answer. Thank you!
Hey I glad that you find it useful, please vote it up

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.