Forum Discussion
Piloos
Advocate I
1 year agoGateway datasource limit breaking ISV use case
We are an ISV using Power BI Embedded to embed reports in our web application. The data sources are MySQL databases. We have a setup where every customer (58k+) has its own database, its own wor...
lbendlin
Super User
1 year agoAre they seriously suggesting you use a personal gateway?!?
The "1000 items" limit keeps popping up in all kinds of places. Sounds like they forgot to enforce it for the number of connections per gateway.
Be aware that if your databases are all on the same instance, and your account has access to all databases then you can use a single connection, and then override that in the custom query by connecting to a different database.