Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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:
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:
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
16 | |
2 | |
1 | |
1 | |
1 |