cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Direct Query Connection - Increase in number of connections in database

Hello Everyone, 

 

I am using direct query to connect to SQL database. Off late, i have observed that with direct query mode,  each visual of report is consuming individual database connection and ending up creating mutiple connections to load a single report. However, this is not applicable to Slicer visual but for rest of the visuals i see this is happening.  Can any one help me in optimising the number of connections getting created in database using direct query. 

 

Please see that to support the architechture,  i need to go for direct query mode.

 

Thanks,

Kiranmai

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.