Forum Discussion

Frequent Visitor

1 year ago

Solved

report server schedule ok but refresh data in power BI Error

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

lbendlin
Super User
1 year ago
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.
ODK_jmor
Frequent Visitor
1 year ago
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.
Anonymous
Not applicable
1 year ago
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.