Forum Discussion

sdlsaginaw's avatar
sdlsaginaw
Frequent Visitor
9 years ago
Solved

On-premises gateway ability to limit data source connections/disable parallel loading?

I'm having a problem in that the on-premises gateway opens more ODBC connections than we have licenses for and will not refresh. 

 

I have disabled parallel loading for the pbix and it works in desktop but the setting is ignored when refreshing via the gateway.

 

Is there a way to limit the ODBC connections the on-premises gateway attempts, or to disable parallel loading as in desktop?

Need Help
  • sdlsaginaw's avatar
    sdlsaginaw
    9 years ago

    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.

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi sdlsaginaw，

    I am not quite clear about your requirement, please help to describe more details and post relevant screenshots. However, if you have added multiple ODBC data sources in a single dataset, to refresh  the dataset in Power BI Service, you would need to add all the data sources under on-premises gateway.

    And we are not able to refresh specific data source in a single dataset, an idea about this issue has been submitted in the following link, please vote it to help Power BI team prioritize this feature.

    https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9858360-refresh-specific-data-source


    Thanks,
    Lydia Zhang

    • sdlsaginaw's avatar
      sdlsaginaw
      Frequent Visitor
      9 years ago

      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). 

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        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