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 is removed and when we run a fairly simple report it generated 20 concurrent database connections (not all active, most inactive). When I traced the connections and found it executed 4 distinct queries (1 ran 1 time, 2 ran 2 times, and 1 ran 3 times) and also generated 13 sessions that did nothing.   when I executed the report multiple times and I saw connections grow up to 38…  this is just for a single user/report.

 

Are you aware of any settings inside the app that will tell it to reuse connections or anything like that?  We have concerns about opening up so many connections for just a single report. 

7 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    We are also getting the same issue when it comes to Oracle. Very frustrating as our EDW is built on Oracle and we cant use that data in Power BI

  • Anonymous's avatar
    Anonymous
    Not applicable

    How many queries used in this report ? If you have multiple query / table from a DB, Power BI will initiate seperate connection/ session for each query. Also, if you had duplicataed any query, its going to create seperate connection for that as well.

     

    Thanks

    Raj

    • sathyanarayanan's avatar
      sathyanarayanan
      Frequent Visitor

       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
        Advocate I

        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.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi

    Any solution to resolve this issue since ?