Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Power BI Paginated Reports Datasource Timeout Error

We have 30 Power BI Paginated reports that retrieve data from an On Premise SQL server database through an on premise data gateway. The reports use SQL stored procedures to access the data they requi...
Paginated Reports
Igna's avatar
Igna
Resolver III
2 years ago

Hello, 

 

You are mentioning that 7 reports are running at the same time. Do they have the same sources (tables) ? If yes, it could cause some lock on the tables concerned. You should try to put different schedules to your subscriptions.

 

Hope it helps.

 

Igna

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Igna,

Thanks for the reply.

The reports do access the same data tables but they are only reading the data (no updates or inserts) so would you still expect contention issues to occur? 

Also if we have a different schedule for each report, they will need to run from 8am to about 10:30 which isn't ideal.  

Thanks

Paul

 

  • Igna's avatar
    Igna
    Resolver III
    2 years ago

    Hi,

     

    Each transaction create a lock on ressources. Even if it is just reading.

    There is no way to create a unique dataset and to create only on report ? Using visibility properties or that kind of stuff ?

     

    Igna

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Igna,

      I have some further info on this issue. Sometimes the issue occurs even when we are running just 1 paginated report in a subscription. 

      I have also noticed that the Request id that we are given in the error email does not appear in any of the On Premise Data Gateway logs. 

      Does this extra information help at all? 

      Thanks in advance.