Forum Discussion
Solved
Gateway doesn't work without a database name
Hi! My datasource is an on-prem SQL Server. In the PBI Desktop it's possible to leave the database name blank and to pull all the databases from the server. But when I go to the PBI Service I can...
Hi,
There is no way. Every database you use, have to be added to the gateway in the service. Thats just how it works. Add or remove a gateway data source - Power BI | Microsoft Docs This link can walk you through how.
Thanks.
Hi,
The only reason that it doesn't require it in PBI Desktop is because it allows you to select it after you connect to the server. Our primary Data Source is also SQL Server and I have found now other way than to give the gateway the database as well.
Hi! And could you share this way? )
Hi,
There is no way. Every database you use, have to be added to the gateway in the service. Thats just how it works. Add or remove a gateway data source - Power BI | Microsoft Docs This link can walk you through how.
Thanks.
