Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Execute PowerBI Script against two DB at Once

Fairly new users here.   I have a script that pulls data from two DB.     PowerBI is connected to both DB but as seperate Data Source.   How do I make it a single data source so the scripts can e...
Need Help
lbendlin's avatar
lbendlin
Super User
3 years ago

Power Query runs the queries in parallel automatically unless you explicitly tell it not to (and will do so in the service no matter what you say). No need to make it a single script.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

I tired but no luck.  Does it matter that the DBs are two different data source? 

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    you mean you want to combine the results from these two sources?  Merge or append?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Correct, the scripts point to two DBs and I want the results to pull from both since each scripts pulls data from various tables. 

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        Merge or append?