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 Igorpole,
For SQL Server, you need provide the Server and Database.
And then you can add datasource in manage gateway.
Please refer:
https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources
Best Regards,
Link
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.