Forum Discussion

Daniel_LP's avatar
Daniel_LP
Frequent Visitor
7 years ago
Solved

PostgreSQL ODBC connection limit

Hi Everyone   Our organisation has changed to a case management system that finally allows us to connect via ODBC to their PostgreSQL Database.   The NpgSQL driver, unfortunately kept complaining...
Need Help
  • v-piga-msft's avatar
    v-piga-msft
    7 years ago

    Hi Daniel_LP ,

    More details will be more helpful.

    Do you have any error mesage in Power BI Desktop? If you have, please share the screenshot of the error message.

    In addition, you could use SQL Server Profiler to trace if every table uses one connection.

    Finally, I'm afraid that PowerBI cannot close connections before opening a new one.

    You may could try to enable this option under Data Load.

    Best Regards,

    Cherry

     

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Daniel_LP ,

More details will be more helpful.

Do you have any error mesage in Power BI Desktop? If you have, please share the screenshot of the error message.

In addition, you could use SQL Server Profiler to trace if every table uses one connection.

Finally, I'm afraid that PowerBI cannot close connections before opening a new one.

You may could try to enable this option under Data Load.

Best Regards,

Cherry

 

Daniel_LP's avatar
Daniel_LP
Frequent Visitor
7 years ago

Hi Cherry!

 

Thank you very much!

Turning off "Parallel loading of tables" has fixed the issue for me!

 

Thanks

Daniel