Forum Discussion

jdpoulin's avatar
jdpoulin
New Member
3 years ago

2 different database sources

I have a report that uses 2 different databases as sources in the dataset. They play nice when working in desktop. When I upload to the power BI service to publish, they do not and I cant them to work together. I can publish the report using each database source on its own but not together-any thoughts?

Need Help

4 Replies

  • aj1973's avatar
    aj1973
    Community Champion
    3 years ago

    jdpoulin 

    It sounds like you need a Power BI Gateway installed. What type of sources is your dataset connected to?

    • jdpoulin's avatar
      jdpoulin
      New Member
      3 years ago

      One is a direct query to a cloud database using snowflake and the other connects via import to an SQL database server 

      • aj1973's avatar
        aj1973
        Community Champion
        3 years ago

        Do you have a Gateway installed on-prem for the SQL Sever source?