Combine two databases

[Anonymous]

Hello,

Our ERP provider set up a custom model for us in PowerBI and I want to add more data to it. They broke it up into two databses, SQLDatabase1 and SQLDatabase2, coming from the same server. How do I combine the data into one model?

Thank you

[V-lianl-msft · Accepted solution]

Current power bi not support connect to multiple sql databases with directquery mode.

For detail information you can refer to below link:

Use DirectQuery in Power BI Desktop

You can try to use import mode and get the tables using dynamic parameters. Hope this link can help you:

https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-parameters-in-power-b...