database as optional in gateway
In Power BI service, in data gateway i want to add a new data source, so i choose "sql server" and because there are many databases i dont want to choose only one database. Why this field is not optional?
We are active user of power bi with large environment, this really difficult to create gateway for each database. I will highly recommend if we can just specify server and database should be optional. We are not able to move forward fast as tracking so many database option under gateway is difficult to manage.