This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
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.
Merge
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.
Interesting, never thought of doing that. I will see how that can be done.
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.
I tired but no luck. Does it matter that the DBs are two different data source?
you mean you want to combine the results from these two sources? Merge or append?
Correct, the scripts point to two DBs and I want the results to pull from both since each scripts pulls data from various tables.
Merge or append?
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 30 | |
| 24 | |
| 23 | |
| 17 | |
| 15 |
| User | Count |
|---|---|
| 61 | |
| 36 | |
| 29 | |
| 22 | |
| 21 |