Incorrect/outdated data shown by report

Hi Anonymous ,

You're on the right track. Thanks for sharing the details of your issue. It looks like there's a mismatch between the data shown in Power BI and what's actually in SQL Server, especially with the Status and start_time fields.

 Here’s a step-by-step approach to help troubleshoot and fix this.

• Even though we mentioned DirectQuery earlier, it's crucial to double-check it.
• Make sure both Power BI Service and SQL Server are set to UTC, and verify there are no time zone discrepancies.
• Head to Power BI and confirm that the refresh schedule is running smoothly without any delays.
• If you're using DirectQuery, confirm it's retrieving real-time data from SQL Server. If real-time updates aren't essential, consider switching to Import Mode for more consistency.
• In SQL Server, run the SELECT * FROM qq query directly to verify that the view returns the latest data.
• To remove outdated data, clear Power BI’s cache. If the issue persists, use the XMLA Endpoint to refresh it programmatically.
• Use SQL Profiler to capture and review T-SQL queries. Check if Power BI is sending the correct queries and whether the Status field updates as expected.
• Make sure there are no ongoing issues or outages affecting data refresh by checking Power BI Service Health.
• Ensure there are no RLS rules or permission issues restricting data visibility. Make sure the Power BI connection has the necessary access to SQL Server.
• In Power BI Desktop, enable Query Diagnostics to analyze how queries are executed and identify any potential inconsistencies.
• If the issue persists and real-time data isn't critical, switch to Import Mode for better data consistency and performance.

Thank you for your response lbendlin .

If my response solved your query, please mark it as the Accepted solution to help others find it easily.

And if my answer was helpful, I'd really appreciate a 'Kudos'.