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

v-kpoloju-msft's avatar
v-kpoloju-msft
Community Support
11 months ago

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-server-service?view=sql-server-ver17 
https://learn.microsoft.com/en-us/sql/reporting-services/report-server/report-server-database-ssrs-native-mode?view=sql-server-ver17 

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's avatar
v-kpoloju-msft
Community Support
11 months ago

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.

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Community Support
    11 months ago

    Hi Jhonrey4,

    Hope you had a chance to try out the solution shared earlier. Let us know if anything needs further clarification or if there's an update from your side always here to help.

    Thank you.

    • v-kpoloju-msft's avatar
      v-kpoloju-msft
      Community Support
      11 months ago

      Hi Jhonrey4,

      Just wanted to follow up one last time. If the shared guidance worked for you, that’s wonderful hopefully it also helps others looking for similar answers. If there’s anything else you'd like to explore or clarify, don’t hesitate to reach out.

      Thank you.