Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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 t...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi All Members,

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

Anonymous 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