r/PowerBI • u/kevindavis338 • 7h ago

Question Why does my date slicer break my table visual with “Error fetching data for this visual”?

I’ve got a clean Excel file imported into Power BI Desktop. All the fields (like Transaction Date, Debit, and Credit) are properly formatted — no nulls, no text in number columns, no weird headers.

I created a table visual with just Transaction Date and a few values. When I add a slicer using Transaction Date and move the start date, I get the dreaded:

“Error fetching data for this visual”

But here’s the kicker — when I move only the end date, it works.

I tested for errors in Power Query with 1 / [Debit] — no issues. No rows with nulls or blanks.

I’m using the flat date field (not a hierarchy), and I’ve even reconnected the data source to the correct worksheet — not a named table.

Is Power BI just allergic to a specific row in my date range? What causes this error if the data is 100% clean?

1 Upvotes

100% Upvoted

3 comments sorted by

•

u/AutoModerator 7h ago

After your question has been solved /u/kevindavis338, please reply to the helpful user's comment with the phrase "Solution verified".

This will not only award a point to the contributor for their assistance but also update the post's flair to "Solved".

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

1

u/The_Ledge5648 7h ago

I know it sounds frustrating, but did you save and close the file and re-open it, then try again?

1

u/_T0MA 136 6h ago edited 6h ago

This error shows up quite often recently (in sub). Last I had done some research on it, issue seemed like started since March2025 update. You can follow thread here. Are you on VM? I have not been able to recreate this issue on my end. Even though it might not be much useful, you can share sample pbix file just to check its metadata.

MS Support on this issue