https://community.fabric.microsoft.com/t5/Developer/Combine-two-databases/m-p/1877754#M29743 <P class="lia-align-left">Hello,</P><P class="lia-align-left">&nbsp;</P><P class="lia-align-left">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?</P><P class="lia-align-left">&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mrjason_0-1622638326578.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/526111i9E12E00ED712B377/image-size/medium?v=v2&amp;px=400" role="button" title="mrjason_0-1622638326578.png" alt="mrjason_0-1622638326578.png" /></span></P><P>Thank you</P> Wed, 02 Jun 2021 12:55:18 GMT Anonymous 2021-06-02T12:55:18Z https://community.fabric.microsoft.com/t5/Developer/Combine-two-databases/m-p/1877754#M29743 <P class="lia-align-left">Hello,</P><P class="lia-align-left">&nbsp;</P><P class="lia-align-left">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?</P><P class="lia-align-left">&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="mrjason_0-1622638326578.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/526111i9E12E00ED712B377/image-size/medium?v=v2&amp;px=400" role="button" title="mrjason_0-1622638326578.png" alt="mrjason_0-1622638326578.png" /></span></P><P>Thank you</P> Wed, 02 Jun 2021 12:55:18 GMT https://community.fabric.microsoft.com/t5/Developer/Combine-two-databases/m-p/1877754#M29743 Anonymous 2021-06-02T12:55:18Z https://community.fabric.microsoft.com/t5/Developer/Combine-two-databases/m-p/1881436#M29776 <P><SPAN>Current power bi not support connect to multiple sql databases with directquery mode.</SPAN></P> <P>For detail information you can refer to below link:</P> <P><A href="https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/" target="_self" rel="nofollow noopener noreferrer">Use DirectQuery in Power BI Desktop</A></P> <P>You can try to use import mode and get the tables using dynamic parameters. Hope this link can help you:</P> <P><A href="https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-parameters-in-power-bi-desktop-part-4/" target="_self">https://www.red-gate.com/simple-talk/sql/bi/power-bi-introduction-working-with-parameters-in-power-bi-desktop-part-4/</A>&nbsp;</P> Fri, 04 Jun 2021 06:23:31 GMT https://community.fabric.microsoft.com/t5/Developer/Combine-two-databases/m-p/1881436#M29776 V-lianl-msft 2021-06-04T06:23:31Z