Make database as optional in gateway

[AntanasK]

Hi, 

why in pbix, database is optional and in data gateway is field status as "must". In my situation there are more than 60 database in server and i don't want to create in gateway 60 data sources.... is there a way to solve this? 

Thank you

[v-qiuyu-msft]

Hi @AntanasK,

One workaround should be use on-premise data gateway personal mode. But in this way, we need to enter credential for each dataset. 

For your requirement, you can vote on this same idea: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/20436511-database-as-optional-in-...

Best Regards,
Qiuyun Yu