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).
