Forum Discussion
Solved
Query that hit multiple DBs
Hi Everyone, I am new to Power BI and I am handling the administration of the Gateway online. We created data sources by connecting to a DB in our Data Warehouse and we were able to geenrate sim...
Hi bjordan , The datasource detail of the gateway connection should match what you have in Power BI Desktop. Only the username and password can differ. If you are querying two databases in one sql query, you should ensure that the user you use to create the gateway connection has access to both databases.
Hi bjordan , The datasource detail of the gateway connection should match what you have in Power BI Desktop. Only the username and password can differ. If you are querying two databases in one sql query, you should ensure that the user you use to create the gateway connection has access to both databases.