Execute PowerBI Script against two DB at Once

[krypto77]

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 execute and pull data from both DB at once or is there a difference approach I should take? Anyting I've attempted so far hasn't worked. 

[krypto77]

Merge

[lbendlin]

While you can technically do that in Power Query it is not a recommended approach. It will be better if you load both data sources as is into Power BI and join them via the data model there.

[krypto77]

Interesting, never thought of doing that. I will see how that can be done. 

[lbendlin]

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.

[krypto77]

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

[lbendlin]

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

[krypto77]

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]

Merge or append?