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

Power BI Service Connect Pool Cache in Sybase DB

Hi,

I am using Sybase DB as source for Power BI reports.I used to schedule the Power BI report from the clould Power BI services.The report has executed and completed successfully on the scheduled time.I having problem like, whenever i do any action in Power BI services report available in cloud then the oneor many connection rows added in Sybase DB the ReqType of these miscellaneous row is "Connect Pool Cache".I hope it may be usefull to cache but the connections rows get occupied in Sybase DB because of this reason the sybase db connections get exceeded with the limit which make stops works other applications connected with sybase db.

 

My doubt is, how to avoid this connect pool cache get generated by Power BI services report.After the report refresh also these type of connection rows not disappearing.Connect_Pool_Cache not only generating in Sybase DB This not only because of power bi report refresh, its get generate even i if do any actions in Power Services Cloud portal from Sybase DB level i can delete this rows but it is not a final solutions.Please suggest

3 REPLIES 3
Highlighted
Community Support
Community Support

Re: Power BI Service Connect Pool Cache in Sybase DB

@vravi3 ,

 

Do you mean after refresh the report, the cache will generate servaral rows in Sybase DB? Do you have some SQL statement when connect to Sybase DB?

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Frequent Visitor

Re: Power BI Service Connect Pool Cache in Sybase DB

Hi,

Do you mean after refresh the report, the cache will generate servaral rows in Sybase DB?

Yes, not only in report refresh stage, even if i open a report then also its generating rows with ReqType Connect_Pool_Cache in Sybase DB.But some rows are getting diappear once the report refresh has completed and closed the report.But few rows still available in db with ReqType Connect_Pool_Cache 

Do you have some SQL statement when connect to Sybase DB?

No, i am using to import tables available in Sybase DB into Power BI Desktop reports

Highlighted
Frequent Visitor

Re: Power BI Service Connect Pool Cache in Sybase DB

Hi All Members,

I didnt get any resolution to my issue.Is there any update from anyone? Thanks in Advance for your responses..


@vravi3 wrote:

Hi,

Do you mean after refresh the report, the cache will generate servaral rows in Sybase DB?

Yes, not only in report refresh stage, even if i open a report then also its generating rows with ReqType Connect_Pool_Cache in Sybase DB.But some rows are getting diappear once the report refresh has completed and closed the report.But few rows still available in db with ReqType Connect_Pool_Cache 

Do you have some SQL statement when connect to Sybase DB?

No, i am using to import tables available in Sybase DB into Power BI Desktop reports


 

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

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.

Top Solution Authors
Top Kudoed Authors