Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello! I'm having an unusual problem that I can't find an answer to. When I use the powerbi desktop version, the data is displayed correctly when saving the powerbi online, from the beginning the data is displayed correctly until the data is refreshed online or with scheduled refresh from the databases themselves, after which the sales data amounts to double. The database contains sales data for each transaction. Has anyone encountered a similar problem?
First picture for the same report online after online refresh:
Second picture is from desktop version:
Solved! Go to Solution.
Disabled incremental refresh and it started to work correctly. Thanks
Ok well that's a step forward. I'm fairly sure it will be related to the setup of incremental refresh. Guessing it's seeing the old data as new and adding it in.
That won't show in power bi desktop because incremental refresh only kicks in after it's in the service.
Confirm it by disabling to start with and then can if you can share your model we can think about making it work correctly.
Disabled incremental refresh and it started to work correctly. Thanks
That is indeed very strange.
Few initial thoughts:
Is the report running in premium capacity or PPU? Just wondering if we can point DAX Studio at it's xlma end point to see what the raw data is showing.
Ok well that's a step forward. I'm fairly sure it will be related to the setup of incremental refresh. Guessing it's seeing the old data as new and adding it in.
That won't show in power bi desktop because incremental refresh only kicks in after it's in the service.
Confirm it by disabling to start with and then can if you can share your model we can think about making it work correctly.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.