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

Jhonrey4's avatar
Jhonrey4
New Member
11 months ago

Hi Vivien,

 

My data source is SQL Server.

 

Below is the image of RAM and disk space of the Report Server and the count from Event table is 0.

 

For the IsDataModelRefreshService in rsreportserver.config, it is set to true.

 

<IsSchedulingService>True</IsSchedulingService>
<IsNotificationService>True</IsNotificationService>
<IsEventService>True</IsEventService>
<PollingInterval>10</PollingInterval>
<IsDataModelRefreshService>True</IsDataModelRefreshService>
<MaxCatalogConnectionPoolSizePerProcess>0</MaxCatalogConnectionPoolSizePerProcess>
<WindowsServiceUseFileShareStorage>False</WindowsServiceUseFileShareStorage>
<MemorySafetyMargin>80</MemorySafetyMargin>