Forum Discussion
Power BI with Azure SQL Data Warehouse
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
4 Replies
- parry2kSuper User
Actual message is "The user was not authorized"
- AnonymousNot applicable
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.
- parry2kSuper User
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