Forum Discussion

bsnow's avatar
bsnow
New Member
11 years ago

how do I connect to SQL Server from Power BI desktop?

How to I connect to SQL Server? I have just downloaded the newest version of Power BI desktop (7/24) and when I Get Data from SQL server, it prompts me for a database name and optional database and o...
cdotzenrod's avatar
cdotzenrod
Advocate I
11 years ago

Get Data>Choose SQL Server>User current credentials or enter sql credentials>Then choose from the list of databases that popup.

 

You don't have to write sql or enter a database upfront. Those are just options you can use if you know what you want to connect to right away.  Otherwise, you can use the visual editor to pick tables.  From there you can optionally choose the edit button to remove fields or add custom calulated fields.   

ricamiller's avatar
ricamiller
Frequent Visitor
11 years ago

Hi there,

 

When you are using Power BI Desktop on a machine that is not on the same domain as the server, this does not seem to work.,

 

Is there a work around for this?

 

Thanks,

Ric

  • cdotzenrod's avatar
    cdotzenrod
    Advocate I
    11 years ago

    I would try one to the following:

     

    1)  Try a runas command like this:  RUNAS /user:domain\userid /netonly "C:\Program Files\...[POWERBI EXECUTEBLE] 

    Use the domain and user you want to connect with and enter the password when prompted

     

    2)  Create a saved windows credential for the SSAS server you want to connect to

     

    3) Go to the security of your SSAS severver and give read access to the other domain user you use with your desktop domain.  I've don't that with our test domain here and it works fine as long as your sysadmin is fine with it.  

     

    Let me know if those ideas work.  

     

    Chad