topic report server schedule ok but refresh data in power BI Error in Report Server

report server schedule ok but refresh data in power BI Error

ODK_jmor — Wed, 08 Jan 2025 13:03:06 GMT

I have a report on report server witch update with at schedule refresh.

At 05:00 on 26-01-2024

8. jan. 2025 08.06.53

Completed Data Refresh

But there something wrong with data.

I open the report in Power BI and refresh data.

is there any log on the report server, which tells

Re: report server schedule ok but refresh data in power BI Error

lbendlin — Wed, 08 Jan 2025 16:27:24 GMT

Click the "View errors" link. After a while this will take you back to Power Query and it will highlight the columns that caused the errors.

Re: report server schedule ok but refresh data in power BI Error

ODK_jmor — Thu, 09 Jan 2025 07:38:25 GMT

thank you for the answer.

I would like to find a log on then report server, that tells me, there is an error in the report.
so I can proactive see there is an error.
we cant se the error in executionlog3 on report server. Therefore we dont know there is an error in this report.

Re: report server schedule ok but refresh data in power BI Error

Anonymous — Fri, 10 Jan 2025 09:35:59 GMT

Hi, ODK_jmor

You might be able to check the reporting server service trace logs, which contain detailed information about the operations performed by the reporting server web service, web portal, and background processing. It includes error messages and general diagnostic information.

You can check the following links:

Report server service trace log - SQL Server Reporting Services (SSRS) | Microsoft Learn

Reporting Services log files and sources - SQL Server Reporting Services (SSRS) | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.