Forum Discussion

adave's avatar
adave
Frequent Visitor
8 years ago

Use Multiple data sources on same server

Hello, I am somewhat new to PowerBI. I am trying to use multiple data sources located on the same server. There are two separate databases with different credentials. I am using import mode to conne...
Data Source
sql server
adave's avatar
adave
Frequent Visitor
8 years ago

I wanted to mention, I am trying to use two SQL Server connections with different userid's

  • smodglin's avatar
    smodglin
    Frequent Visitor
    6 years ago

    adave Did you ever resolve this? I am running into this issue, too. 

    • adave's avatar
      adave
      Frequent Visitor
      6 years ago

      I ended up creating a view in the database which pulls the data from both sources ( you'll need to a userid that would have ability to query both sources) and using that view in Power BI.