An unexpected error occurred( file ", line, function ")

[Ishhmn]

In Power BI Desktop, when using a slicer with date, I get the follwing error: An unexpected error occurred( file ", line, function ")

In particular, it breaks when I use the "Between" setting in the slicer as it is a Date

My Data is in csv format.

Power BI version: Version: 2.143.1204.0 64-bit (May 2025)

Data TableVisual

[rs3782]

Been having this issue since March 2025.  Still no fix with the June 2025 release.  I wish Microsoft would take this seriously - it's broken my model multiple times and still not solution in sight other than reverting to the Feb 2025 release.  How are we 4 versions ahead of this and still dealing with the same issue!!

[v-priyankata]

Hi @rs3782 
Apologies for the inconvenience caused, Thanks for your patience. This appears to be a known issue, and I hope Microsoft is expected to roll out a fix in one of the next updates.

[v-priyankata]

Hi @Ishhmn 

May I ask if you have resolved this issue? @stefano_deny @tamn @johnbasha33 thanks for your inputs.
@Ishhmn please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-priyankata]

Hi @Ishhmn 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

[tamn · Accepted solution]

There has been serveral bug reports about this - the issue was introduced in the March 2025 update.

It has not been fixed yet, even in the May 2025 release.

The general recommendation is, if possible, downgrade to the Feb 2025 version.

Further reading:
- https://www.reddit.com/r/PowerBI/comments/1jzy67k/power_bi_desktop_error_an_unexpected_error/
- https://www.reddit.com/r/PowerBI/comments/1jpxvxa/february_2025_power_bi_desktop_download_file/?shar...
- https://community.fabric.microsoft.com/t5/Desktop/Error-Fetching-Data-for-this-Visual/td-p/4635446

[johnbasha33]

@Ishhmn 

Check your Date column type in Power Query

• Go to Power Query Editor.

• Select your Date column.

• Make sure its data type is set to Date (not Text or DateTime).

• If it’s Text, change it to Date.

• Then Close & Apply.

---

2. Ensure the date values are valid

• Dates should be in a proper format (e.g., YYYY-MM-DD or recognized locale format).

• Invalid dates or empty strings can cause the slicer error.

• In Power Query, filter out or fix rows with invalid dates.

---

3. Replace or fix null/blank dates

• Replace nulls or blanks in your Date column with a valid date or remove those rows.

• Null/blank dates can break slicer with "Between" mode.

---

4. Use a Calendar/Date table

• Create or import a proper Calendar Table with continuous dates.

• Connect your data’s Date column to this Calendar Table’s Date column.

• Use the Calendar Table’s Date in the slicer instead of the raw CSV date column.

---

5. Test slicer again

• After fixing the data type and invalid values, try the "Between" slicer again.
  
  

  Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!

[Ishhmn]

This has not worked, weirdly, if i change the scale from the left hand side of the slicer, it works, but not from the left (Lower Bound)

[stefano_deny]

Hello,

I'm experiencing the same issue. What's strange is that I tested opening the project on two other Dell laptops and the problem doesn't occur only on this somewhat old Intel desktop that I left at the company for BI project development.

I tried rolling back Power BI to the February version, but my project won't open in that version.

I hope Microsoft can fix this bug soon.