topic Re: Data refresh error in Report Server

Data refresh error

WithwindOK — Tue, 14 Oct 2025 01:13:54 GMT

In the September 2025 version, during data refresh, multiple reports randomly reported errors similar to the following: SessionID: fb9f202c-e4cf-4504-b604-0f52f95b86ab
[0] 0: Couldn't find database: c010c00b-e2f9-4607-be5e-4f7b90d32f86_934030742 in AS server

Re: Data refresh error

tayloramy — Tue, 14 Oct 2025 04:54:27 GMT

Hi @WithwindOK,

Can you share screenshots of the error?

Is this error happening in desktop, or only once you upload it to report server?

What are your data sources?

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Re: Data refresh error

v-dineshya — Tue, 14 Oct 2025 11:05:54 GMT

Hi @WithwindOK ,

Thank you for reaching out to the Microsoft Community Forum.

HI @tayloramy , Thank you for your prompt response.

Hi @WithwindOK , As mentioned by @tayloramy , Could you please provide more details regarding error? We are happy to assit you.

Regards,

Dinesh

Re: Data refresh error

WithwindOK — Wed, 15 Oct 2025 00:08:56 GMT

This error only occurs when uploading to PBIRS; refreshing in Desktop works fine. The data source is Oracle Database 19c, and a manual refresh can complete successfully.

Re: Data refresh error

tayloramy — Wed, 15 Oct 2025 00:10:13 GMT

Hi @WithwindOK,

Does the server where the report server is installed have the oracle client installed?

Are you able to use TNSPING on the server to successfully connect to the database?

https://docs.oracle.com/en/database/oracle/oracle-database/19/netag/testing-connections.html

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Re: Data refresh error

WithwindOK — Wed, 15 Oct 2025 00:25:12 GMT

The Oracle client is installed correctly. Please note that the refresh fails randomly—not every time—and the reports that fail are also random.

Re: Data refresh error

tayloramy — Wed, 15 Oct 2025 00:37:30 GMT

Hi @WithwindOK,

Right, I forgot that this was an intermittent issue, which are usually the worst kind of issues to troubleshoot.

Ensuring that the client is installed and the server can conect to the Oracle database is about the limit of my Oracle troubleshooting abilities, I work in a SQL Server shop.

Are there any error logs on the Oracle side when a refresh fails? Is there a failed connection attempt or something?

Are there more detailed logs generated on the report server? Those should exist for sure, which might also give us some more details into what is actually happening.

I generally like to blame intermittent network issues like this on DNS issues, so I would also start investigating that, but I have no basis for that claim.

Re: Data refresh error

WithwindOK — Wed, 15 Oct 2025 00:53:20 GMT

Based on the error message, it appears that the model corresponding to the report failed to load during the refresh attempt, and it seems unrelated to DNS.

Re: Data refresh error

tayloramy — Wed, 15 Oct 2025 01:02:29 GMT

Yeah, the error says that the database couldn't be found. I did say the DNS thing was a baseless claim.

Looking closer at the error, it's not returning an Oracle error, so I don't think the problem is an issue with the source database. The dataasbe it can't find is the analysis service database, so the tabular model.

What version of report server and power bi desktop are you using?

When the refresh works, about how long does it generally take?

Let's grasp at whatever straws we can until we find something solid to grab onto.

Re: Data refresh error

v-dineshya — Wed, 15 Oct 2025 04:18:57 GMT

Hi @WithwindOK ,

Thank you for the update. The error message "Couldn't find database: <GUID>_<number> in AS server",
refers that during the data refresh process on Power BI Report Server, the server is unable to locate the Analysis Services database associated with the report model.

Please check below things to fix the issue.

1. Please check the RSPortal.log and RSHostingService.log files for more detailed error traces around the time of failure.

2. Use Performance Monitor or Task Manager to check memory and CPU usage during refresh times.

3. Avoid concurrent refreshes by scheduling reports at different times.

4. Check this issue in the September 2025 release notes or forums. If it's a confirmed bug, consider rolling back to a stable version.

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

Re: Data refresh error

v-dineshya — Mon, 20 Oct 2025 06:02:46 GMT

Hi @WithwindOK ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh

Re: Data refresh error

WithwindOK — Mon, 20 Oct 2025 06:31:49 GMT

Your questions have left me quite confused. I've already uploaded the software version and error screenshots in my previous posts—I'm not sure what else I can do.

Re: Data refresh error

v-dineshya — Mon, 20 Oct 2025 07:24:27 GMT

Hi @WithwindOK ,

Please try the troubleshooting steps, which i was suggested in my previous response. In addition to that, Colud you please try the below steps to fix the issue.

1. Please check the RSPortal, RSService, and AS logs at the time of the failure. check for memory pressure, timeouts, or model loading errors.

2. Check the server hosting PBIRS has sufficient RAM and CPU. Increase the MaxMemoryLimit setting in RSHostingService.config.

3. If multiple reports are refreshing simultaneously, try to refresh one by one report to reduce load.

4. Use the latest PBIRS version. Sometimes bugs in older versions cause intermittent issues.

5. Large models may fail to load under constrained resources. remove unused columns and aggregate the data.

6. Re-upload the affected reports to PBIRS. Validate that the model loads correctly in PBIRS after upload.

I hope this information helps. Please do let us know if you have any further queries.

Regards,

Dinesh

Re: Data refresh error

v-dineshya — Thu, 23 Oct 2025 15:10:26 GMT

Hi @WithwindOK ,

We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. And, if you have any further query do let us know.

Regards,

Dinesh