Forum Discussion
Error Fetching Data for this Visual
- 1 year ago
This seems to be a issue with the march release of power BI. Try revertong to Feb release
I second this! This topic should not be marked as "solved" as it is not fixed in current releases.
I'm using Win 11 on MacBook Pro (48GB RAM, 20 allocated to Parallels) and all workbooks use a calendar table.
It's fine with January 2025 version.
Problem occurs with more recent PBI version.
When published to server, all works well, but it makes creating something in desktop impossible.
Page with custom date range slicer: works sometimesPage with Date - between - slicer: all charts break.
If you paste your measure in chat GPT it will fix it. I found that I was no longer able to generate table filters within a summarize. Since then, I've started generating the table filter outside of the summarize and applying the table variable as a table fitler. This also effects excel dax calculated tables.
eg.
Bad
Summarize(
Sales
, Sales[Customer]
, Filter(Calendar, Calendar[Date]>dynamic date field)
, [Sales]
)
Good
VAR CalFilter = Filter(Calendar, Calendar[Date]>dynamic date field)
Return
Summarize(
Sales
, Sales[Customer]
, CalFilter
, [Sales]
)