Forum Discussion

sathyanarayanan's avatar
sathyanarayanan
Frequent Visitor
8 years ago

How many connections does power bi open up for loading data

We have a simple Power BI reports accessing Oracle db for part of the data.  DBA team has  limited users to 8 db sessions and this reports fail because it hits the max of 8 sessions. when the limit i...
Need Help
sathyanarayanan's avatar
sathyanarayanan
Frequent Visitor
8 years ago

 Hi Rajendran,

I have 3 Queries but I see 15 to 16 connections open in the backend when I monitor in Oracle DB.The number of connection differs each time and as we have limit of 8 connection it fails to refresh the model.

 

Thanks,
Sathya

leovillarroel's avatar
leovillarroel
Icon for Advocate I rankAdvocate I
8 years ago

Any news on this one?, I have a PBIX that goes againts teradata and same thing happens, kind a new session for each table created in the edit query dialog.

  • srilathakurra's avatar
    srilathakurra
    New Member
    7 years ago

    We also see lot of connections being created by Power BI when we use Import Data from Teradata. Any updates on the count of sessions being created? Also in some scenarios, the triggered sessions just remain in Responding or Idle state and do not get disconnected post closing the pbix files.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hi,

       

      We also have this problem since a few weeks now. We do a daily refresh of all our cubes, not all at the same time though. It worked fine till 26/7, but then we encountered the same problem I read about here on a number of forums, that connections to an Oracle database generates a lot of open sessions that are not being closed (or not being closed quick enough).

       

      We already do a daily reboot of or gateway server, but that doesn' t help. Once you start 1 refresh of 1 query, 10 sessions are opened. The lates version of PowerBI Gateway was also installed, but that didn't help either.

       

      I've seen a lot of suggestions here from other PowerBI users to try and solve this, but I did not yet see an official answer from Microsoft, or am I mistaken?

      Is there an official solution from Microsoft?