Power BI Report Server Schedule Refresh Error

[Jhonrey4]

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 be due to a connection failure, timeout or low disk condition within the database. "

I also looked in the logs RSPowerBI_*.log in it shows below:

2025-09-11 15:55:08.0141|ERROR|23|Couldn't find database: 3c675ff9-b931-4a61-acdb-e8924582136f_992049747 in AS server | RequestID = dbd26ec4-a393-e28d-aec7-bd03b4899692 ClientSessionID = bd46be3c-5300-83d6-2ee4-382860fcf8b3 Microsoft.PowerBI.ReportServer.AsServer.DatabaseNotFoundException: Couldn't find database: 3c675ff9-b931-4a61-acdb-e8924582136f_992049747 in AS server
2025-09-11 15:55:08.0561|ERROR|41|Unhandled error in the Web API|GET https://prd-dwh-db.bocad.ad/powerbi/api/explore/reports/3c675ff9-b931-4a61-acdb-e8924582136f/modelsA... - Response Unknown| RequestID = dbd26ec4-a393-e28d-aec7-bd03b4899692 ClientSessionID = bd46be3c-5300-83d6-2ee4-382860fcf8b3 Microsoft.PowerBI.ReportServer.AsServer.DatabaseNotFoundException: Couldn't find database: 3c675ff9-b931-4a61-acdb-e8924582136f_992049747 in AS server
at Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.GetDatabaseOrThrow(String databaseName)
at Microsoft.PowerBI.ReportServer.AsServer.TOMWrapper.GetPowerBIDataSourceVersion(String databaseName)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.GetDataSourcesCollection(String databaseName, TOMWrapper asWrapper)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.GetDataSourcesInternal(String databaseName, TOMWrapper asWrapper)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.SetModelParametersInternal(TOMWrapper asWrapper, String databaseName, IEnumerable`1 parameters)
at Microsoft.PowerBI.ReportServer.AsServer.AnalysisServicesServer.<LoadDatabaseForExecutionAsync>d__17.MoveNext()

[v-kpoloju-msft]

Hi @Jhonrey4,

Thank you for reaching out to the Microsoft Fabric Community Forum and sharing the detailed error and logs that helps a lot. From the error:

Couldn't find database: <GUID> in AS server

this means that during scheduled refresh, Power BI Report Server’s internal Analysis Services engine is unable to locate the temporary model database it expects.

This usually happens if:
• The temporary model database got corrupted or removed,
• There isn’t enough memory/disk space for PBIRS to create it,
• Or the Report Server/Analysis Services are in an unhealthy state.

Here are some steps you can try: Restart both the Power BI Report Server service and the Analysis Services (PBIRS) service, then retry the refresh. Check that the ReportServer and ReportServerTempDB databases are online and healthy (DBCC CHECKDB can confirm). Verify you have enough disk space and memory for refresh operations.

Use SQL Server Management Studio to connect to your PBIRS Analysis Services instance check if the GUID database exists. If it’s missing or stuck, clean up any orphaned entries. If the issue persists, try re-uploading the report so a fresh temporary model is created. Finally, confirm the PBIRS service account has the right permissions on the ReportServer DB and AS instance.

Refer these links for better understanding:
https://learn.microsoft.com/en-us/sql/reporting-services/report-server/start-and-stop-the-report-ser... 
https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-database-ssrs-n... 

Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

Thank you for using the Microsoft Fabric Community Forum.

[v-kpoloju-msft]

Hi @Jhonrey4,

Just checking in to see if the issue has been resolved on your end. If the earlier suggestions helped, that’s great to hear! And if you’re still facing challenges, feel free to share more details happy to assist further.

Thank you.

[Jhonrey4]

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>

[vivien57]

Have you ever been able to refresh it, or did it work and now it doesn't?

Otherwise, you can try the following:
- Specify the port in your connection
- Enter the IP address rather than the server name
- Check the connector you are using (can you share with us how you configured the DataSource in your PBIX file)

Please feel free to give me a kudo

Have a nice day,

Vivien

[Jhonrey4]

Hi Vivien,

Please see below my connection. Can I ask how to specify the port in the connection?

[vivien57]

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]

I am not been able to refresh it since this is the first Power BI to be deployed in the Report Server. and I am not really familiar in On-Prem report server. Based on my initial research can you confirm if the server need SQL Server Analysis Services (Power BI mode) in the services because I cannot see it and I think this is not installed in our server.

[vivien57]

No, if your data source is a relational SQL Server database, you do not need to install Analysis Services.

The error message mentions Analysis Services (or AS) because the underlying engine that stores the data model on Power BI Report Server is similar (but it is embedded in the .PBIX file), so there is no need to install it on the server side.

Have you tried my previous recommendations? Can you send a screenshot of the data source configuration in Power BI Desktop?

Are you sure you have the version of Power BI Desktop for Report Server? (And not the one for Power BI Service)

https://www.microsoft.com/en-us/download/details.aspx?id=106034

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

[vivien57]

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