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!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Hello,
I published an PBI report to PowerBI services and it shows wrong data. PowerBi desktop shows the right data. I have tried the following things, but it doesnt work:
1. Clear caches from PBI Desktop and republishing report to PBI Services.
2. Change Regional Settings in Desktop.
3. Check the Regional Setting in OS Settings and changes all to one country.
Data source is MS access from Local drive. I am using personal Gateway. Dates are comming from the database and mapped with Weeks, because I am slicing with Weeks. i havent used Date() or Today() functions.
Solved! Go to Solution.
Finally the issue is related to Boolean function. PowerBI services consider boolean as 0 and -1, but PowerBI Desktop consider as 1 and 0. This makes the data looks different in PowerBI services.
Finally the issue is related to Boolean function. PowerBI services consider boolean as 0 and -1, but PowerBI Desktop consider as 1 and 0. This makes the data looks different in PowerBI services.
@Deadpool_123 Try resetting the report in the Service to the default. It's a button in the ribbon for the report over on the right.
I did, it doesnt work.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!