Execute PowerBI Script against two DB at Once

Question

Fairly new users here.&nbsp;I have a script that pulls data from two DB.&nbsp;&nbsp;&nbsp;PowerBI is connected to both DB but as seperate Data Source.&nbsp; &nbsp;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.&nbsp;

lbendlin · Answer

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 · Answer

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

lbendlin · Answer

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

anonymous · Answer

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

lbendlin · Answer

Merge or append?

Forum Discussion

Execute PowerBI Script against two DB at Once

8 Replies

Related content

Parallel Execution

Fabric Python Notebook Execution Logs

Executive Semantic Model

design approach or strategy for executive dashboard

wireframes for executive summary dashboard