Forum Discussion
In DirectQuery mode, dates are not synchronized between the fact table and calendar.
I needed to create a calendar table to review the days for which I have no data and link it to the fact table. However, even though I've updated the dashboard, I don't see the latest date(s) in my calendar table. The calendar table is created using the MIN and MAX values from the fact table. I've included an image with all the information.
4 Replies
telesforo1969 have you looked at this limitation: DirectQuery in Power BI: When to Use, Limitations, Alternatives - Power BI | Microsoft Learn
- One million row intermediate result limit. Any query (or intermediate operation) that returns more than 1,000,000 rows fails. Premium capacities can raise this limit—see Max Intermediate Row Set Count.
Yes, I've read your message. I should also mention that I'm updating the dashboard manually, and the calendar table isn't getting the latest date from my fact table. I have to create a new calendar table for it to update the date, which I don't think should be the case. It used to work fine, but this problem started after I downloaded the latest version of Power BI. I'd like to know if this is a development issue or if the MAX function simply isn't working in DirectQuery
Thank you for reaching out to the Microsoft Fabric Forum Community.
parry2k Thanks for the inputsThe MAX function still works in DirectQuery, but Power Query-generated tables (like your calendar using MIN/MAX) only refresh when the query itself is re-evaluated, not when visuals are manually refreshed in the report. This means the Calendar table won’t pick up new dates unless the underlying query is refreshed and reloaded. If it previously refreshed automatically but no longer does after the latest update, it may be related to recent changes in how DirectQuery handles query folding or metadata updates.
As a workaround, consider defining a fixed or parameter-based date range, or load the Calendar table in Import mode so it updates reliably. If you continue seeing inconsistent behavior try to raise a microsoft support ticket.Create a Fabric and Power BI Support Ticket - Power BI | Microsoft Learn.
Thanks.
