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.
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't use the gateway as it requires the database name to work. Are there any workarounds how to make it work?
Solved! Go to Solution.
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.
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.
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.