Forum Discussion

Jhonrey4's avatar
Jhonrey4
New Member
11 months ago
Solved

Power BI Report Server Schedule Refresh Error

In the report server database est connection is successful but whenever doing schedule refresh its not connecting. throwing error like "an error occurred within the report server database. this may b...
PowerBI Report Server
  • vivien57's avatar
    vivien57
    11 months ago

    Hello Jhonrey4 ,

    After your IP address, you can put ":" and the port number in the server information.

    Please feel free to give me a kudo

    Have a nice day,

    Vivien

vivien57's avatar
vivien57
Super User
11 months ago

Hello Jhonrey4 ,

What exactly is the data source for your report? (Analysis Services?)

If so, have you tried redeploying your tabular model?

Do you have enough RAM and disk space on the server? (When the data model refreshes, it needs twice its size to refresh.)

Run a query to check row count:  (to see if this table is not too large)

 

SELECT COUNT(*) FROM ReportServer.dbo.Event

 

Check rsreportserver.config Settings
Look for IsDataModelRefreshService setting to ensure the server is configured to handle scheduled refresh.

Please feel free to give me a kudo and/or accept my answer as the solution if it suits you.

Have a nice day,

Vivien