Forum Discussion
On-premises gateway ability to limit data source connections/disable parallel loading?
I ended up writing a proxy server that accepts all of the gateway ODBC connections then brokers out the real connections to the ODBC server within the allowed license count. Works great.
I am using a single ODBC data source which has multiple tables under it.
The provider of the ODBC implementation charges a hefty license fee for every simultaneous open connection to the ODBC server process.
With parallel loading disabled in desktop I can refresh all of my tables within the confines of our ODBC license count.
Once the file is published the on-premises gateway fails to refresh because it's opening a separate ODBC connection for each table, which quickly exceeds our ODBC server license count.
I need to find a way to disable parallel loading on the gateway like I can on desktop (or set a maximum number which is less than our ODBC license count).
Hi sdlsaginaw,
How do you disable parallel loading in Power BI Desktop and what is the exact error message do you get in Power BI Service?
Thanks,
Lydia Zhang