Forum Discussion

cheid_4838's avatar
cheid_4838
Icon for Helper IV rankHelper IV
2 years ago
Solved

Connecting to 2 Servers

I have SQL logic (below) that connects to two different servers (in bold) and databases.  I know how to connect to one server in Power BI, but is there anyway to utilize this logic in Power BI when m...
Need Help
  • Wilson_'s avatar
    Wilson_
    2 years ago

    cheid_4838,

     

    Without looking at the query, it sounds like you could create this query as a stored procedure or a view in SQL server, then reference it in Power Query.


    ----------------------------------
    If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

     

    P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.

Wilson_'s avatar
Wilson_
Icon for Memorable Member rankMemorable Member
2 years ago

cheid_4838,

 

Without looking at the query, it sounds like you could create this query as a stored procedure or a view in SQL server, then reference it in Power Query.


----------------------------------
If this post helps, please consider accepting it as the solution to help other members find it quickly. Also, don't forget to hit that thumbs up and subscribe! (Oh, uh, wrong platform?)

 

P.S. Need a more in-depth consultation for your Power BI data modeling or DAX issues? Feel free to hire me on Upwork or DM me directly on here! I would love to clear up your Power BI headaches.