Forum Discussion

Piloos's avatar
Piloos
Icon for Advocate I rankAdvocate I
1 year ago
Solved

Gateway 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...
Need Help
Piloos's avatar
Piloos
Icon for Advocate I rankAdvocate I
1 year ago

Hi v-hashadapu ,
The support ticket is not closed yet.  It is confirmed that there is a 1000 gateway datasource limit per gateway, so irrespective of the user (or service principal).
The possible options to fix this issue:

  1. A gateway datasource that can be used for multiple MySQL databases with the same credentials.  This is AFAIK not possible today.  The product team said they would check if they could support this.  lbendlin suggests to write our own connector.  I am not so familiar with that and I would probably need to start from the .pq-file of the current MySQL connector.  Not sure where to find this.
  2. The second option is to ditch the gateway.  It is not really a solution, but a workaround.  It would require us to expose our sources on the internet and make "straight" connections to them.  This just eliminates the need of gateway datasources :-).  However, it reduces security.
v-hashadapu's avatar
v-hashadapu
Icon for Community Support rankCommunity Support
1 year ago

Hi Piloos , thank you for reaching out to the Microsoft Fabric Community Forum.

Thanks for the update. We appreciate the details. Hope your issue gets resolved soon. when it does, please share the insights here and mark it or any other helpful answer 'Accept as Solution', which will help others with similar queries.

Thank you.