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 more than one server is being referenced in the logic? Thanks for your help.
--VENTURE TRANSPORT SERVER
SELECT
ltrim(rtrim(r.CUSTNMBR)) as CUSTNMBR
, c.[Customer Name]
, co.cmp_othertype2 as CSR
, ISNULL(lf.[name], 'UNKNOWN') as [CSR Name]
, c.[Average Days To Pay - Year]
, lf2.edicode as Terms
, ltrim(rtrim(r.DOCNUMBR)) as DocNum
, ISNULL(ih.ivh_xferdate,POSTDATE) as PostDate
, r.RMDTYPAL AS [Doc Type]
, DATEDIFF(DAY, ih.ivh_xferdate, GETDATE()) as Age
, (DATEDIFF(DAY, ih.ivh_xferdate, GETDATE())) - lf2.edicode as AgeOverTerms
, case when r.rmdtypal = 7 then r.curtrxam * -1 else r.curtrxam end as TotalDue
, case when ((DATEDIFF(DAY, ih.ivh_xferdate, GETDATE())) - lf2.edicode) > 0
then case when r.rmdtypal = 7 then r.curtrxam * -1 else r.curtrxam end
else 0 end as TotalPastTerms
, case when ((DATEDIFF(DAY, ih.ivh_xferdate, GETDATE())) - lf2.edicode) > 0
then 1 else 0 end as TermCount
, 'VL' as Company
--, (select top 1 ce.contact_name from TMWSuite_Transcorr.dbo.companyemail ce where ce.cmp_id = r.CUSTNMBR and ce.type = 'AP' and ce.ce_phone1 is not null) as ContactName
, contact_info.[Contact Name] AS [ContactName]
--, isnull((select top 1 ce.ce_phone1 from TMWSuite_Transcorr.dbo.companyemail ce where ce.cmp_id = r.CUSTNMBR and ce.type = 'AP' and ce.ce_phone1 is not null),co.cmp_primaryphone) as ContactPhone
, ISNULL(contact_info.[Contact Phone], co.cmp_primaryphone) AS [ContactPhone]
--, (select top 1 ce.ce_phone1_ext from TMWSuite_Transcorr.dbo.companyemail ce where ce.cmp_id = r.CUSTNMBR and ce.type = 'AP' and ce.ce_phone1 is not null) as ContactExt
, contact_info.[Contact Ext] AS [ContactExt]
--, (select top 1 ce.email_address from TMWSuite_Transcorr.dbo.companyemail ce where ce.cmp_id = r.CUSTNMBR and ce.type = 'AP' and ce.ce_phone1 is not null) as ContactEmail
, contact_info.[Contact Email] AS [ContactEmail]
--, (select top 1 n.not_text_large from TMWSuite_Transcorr.dbo.notes n where n.nre_tablekey = r.DOCNUMBR and n.not_type = 'COLL' and n.ntb_table = 'invoiceheader' order by n.last_updatedatetime desc) as InvoiceNote
, notes_info.[Note Text] AS [InvoiceNote]
, case when r.rmdtypal = 7 then r.ORTRXAMT * -1 else r.ORTRXAMT end as Original
, ih.ivh_ref_number as RefNum
, ih.ord_hdrnumber as OrderNum
, cn2.noteindx as NoteID
, cn2.Date1
, cn2.Action_Promised
, cn2.Action_Assigned_To
, cnn.txtfield as Note
, cn2.CNTCPRSN as Contact
--, (select top 1 cn3.Note_Display_String from [VLCCI-GPSQL16].VNLO.dbo.cn00100 cn3 left join[VLCCI-GPSQL16].VNLO.dbo.cn00100 cn4 on cn4.noteindx = cn3.noteindx where cn4.noteindx is null and cn3.CUSTNMBR = c.[Customer Number] order by cn3.Date1 desc) as BillToNote
, billto_notes.[Note Display String] AS [BillToNote]
, co.cmp_creditlimit as CreditLimit
, ltrim(rtrim(mgr.CRDTMGR)) as CRDTMGR
, case when co.cmp_revtype1 in ('JOYE','JYTS','TRCR','VNLO') then 'Transport'
when co.cmp_revtype1 in ('TGS','VGS') then 'Solutions'
when co.cmp_revtype1 in ('VRWD','VWD') then 'Warehouse'
else 'UNK' end as RevType1
--, (SELECT MAX(ref_number) FROM ReferenceNumber r WHERE r.ord_hdrnumber = ih.ord_hdrnumber AND r.ref_table = 'orderheader' and ref_sequence = 1) as Ref1
, first_ref.[Ref Number] AS [Ref1]
--, (SELECT MAX(ref_number) FROM ReferenceNumber r WHERE r.ord_hdrnumber = ih.ord_hdrnumber AND r.ref_table = 'orderheader' and ref_sequence = 2) as Ref2
, second_ref.[Ref Number] AS [Ref2]
--, (SELECT MAX(ref_number) FROM ReferenceNumber r WHERE r.ord_hdrnumber = ih.ord_hdrnumber AND r.ref_table = 'orderheader' and ref_sequence = 3) as Ref3
, third_ref.[Ref Number] AS [Ref3]
--, (SELECT MAX(ref_number) FROM ReferenceNumber r WHERE r.ord_hdrnumber = ih.ord_hdrnumber AND r.ref_table = 'orderheader' and ref_sequence = 4) as Ref4
, fourth_ref.[Ref Number] AS [Ref4]
--, (SELECT MAX(ref_number) FROM ReferenceNumber r WHERE r.ord_hdrnumber = ih.ord_hdrnumber AND r.ref_table = 'orderheader' and ref_sequence = 5) as Ref5
, fifth_ref.[Ref Number] AS [Ref5]
, lf3.name as Division
, order_note.[Note Text] AS [OrderNote]
INTO #TEMP
