Forum Discussion

parry2k's avatar
parry2k
Super User
10 years ago

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 alrea...
Need Help
parry2k's avatar
parry2k
Super User
10 years ago

Actual message is "The user was not authorized"

Anonymous's avatar
Anonymous
Not applicable
10 years ago

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's avatar
    parry2k
    Super User
    10 years ago

    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's avatar
      Anonymous
      Not applicable
      10 years ago

      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.