Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I recently started working with PowerBI for the first time. Most things seemed to go smoothly, then suddenly my report started acting weird overnight. A couple of mornings ago I opened my laptop and saw that it was updating, sure. But when I opened powerBI again to continue on an assignment, all my graphs that uses [D Time].[Calendar Year] as a filter stopped working. Whenever I apply a year filter all the data from a graph/table just dissapears, even if it's supposed to have data in that year.
I tried reinstalling PowerBI, I cleared every cache, deleted all existing files. I tried fully disabling firewall, This didn't fix it. I then ported all my files (ssms database scripts, visual studio project, powerbi report) to my pc, and there it works perfectly. After working on my PC I again tried porting everything back to my laptop to check if it works, but alas, the year filter still messed everything up.
I'm connected to a localhost database with live connection with the latest version of PowerBI
PC:
Laptop:
As you can see it has data without filters:
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.