Forum Discussion

MikeSJ's avatar
MikeSJ
Regular Visitor
6 years ago

Power BI Report Server hanging

HI,   I am periodically finding that the reports on our Power BI report Server become unavailable and when I try and access them I just get a loading message on the web page.   Investigating furt...
msmdsvr
Power BI Report Server
RSPortal
KBO's avatar
KBO
Memorable Member
6 years ago

Hi MikeSJ ,

how big is the SQL DB sized on which your Report Server DB is stores? Is the Report Server Service and the DB on the same machine? If not may be check the infrastructure.

 

Best,

Kathrin

 

 

 

 

If this post has helped you, please give it a thumbs up!
Did I answer your question? Mark my post as a solution!

MikeSJ's avatar
MikeSJ
Regular Visitor
6 years ago

Hi,

 

DB and Power BI are on the same server. All databases are small

  • KBO's avatar
    KBO
    Memorable Member
    6 years ago

    Hi MikeSJ ,

    sounds good - do have running jobs on the Report Server? (Scheduele Refreshes)

    If yes and you refresh them every 5 or 10 Minutes it also could be that the performace of the rest is effected.

    And how many capacity do have on your DB?

     

    BEst,

    Kathrin

     

     

     

     

    If this post has helped you, please give it a thumbs up!
    Did I answer your question? Mark my post as a solution!

    • MikeSJ's avatar
      MikeSJ
      Regular Visitor
      6 years ago

      Hi Kathrin,

      No refreshes that frequent and plenty of capacity in the databases.

       

      Looks like I will have to wait till another month rolls around to investigate further.

      Cheers,

      Mike