Power BI with Azure SQL Data Warehouse

parry2k · ‎01-27-2016

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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

parry2k · ‎01-27-2016

Actual message is "The user was not authorized"

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎01-27-2016

@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 · ‎01-27-2016

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

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎01-27-2016

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