Forum Discussion

dskeane's avatar
dskeane
Helper I
4 years ago
Solved

PBI connection to SQL

Trying to connect to SQL server from Power BI using the SQL connection.    Can confirm that sa login credentials are working from the database source using management studio Can confirm that remot...
Need Help
  • dskeane's avatar
    dskeane
    4 years ago

    SA does work from the database source, what i found was connecting to another user name with permissions to access tables did work. Not sure why SA wouldnt though? 

     

    Either way I now have access to my database connecting from Power BI. 

     

    Thanks for the suggestions.

dskeane's avatar
dskeane
Helper I
4 years ago

SA does work from the database source, what i found was connecting to another user name with permissions to access tables did work. Not sure why SA wouldnt though? 

 

Either way I now have access to my database connecting from Power BI. 

 

Thanks for the suggestions.