Power BI with Azure SQL Data Warehouse

[parry2k]

Hello,

I have sample Azure SQL Datawarehouse and trying to connect using PowerBI Desktop, getting error saying, "User not exist" but at the same time I connect using Power BI Service.

I already added our IP address on the firewall so that is not the issue, I checked it with using SSMS.

Any idea.

Thanks,

P

[parry2k]

Actual message is "The user was not authorized"

[Anonymous]

@parry2k Have you tried to manually edit the connection? You can go to File -> Options and Settings -> Data Source Settings and manually edit the connection.

[parry2k]

Yes, I looked into that too, it allows me to add the whatever credentials I want and doesn't validate.

And if I go back to connec to Azure Data Warehouse, it comes with user dialogue box and will not continue becuase of user issue.

I'm not fully sure if editing the connection manually makes any difference. Thanks for the help thou.

P

[Anonymous]

@parry2k The only other things I know to check would be that you are fully qualifying the server name, and that when you set your firewall settings that you ensure the rules for the database are configured to "Allow access to Azure services". - which you may have already done.