Published Reports show wrong value after refresh of dataset on server
Something strange is happening and I cant figure out the issue.
I have a dataset with a datasources odatafeed. When i refresh this dataset in powerbi desktop, save it and publish, all goes well and reports published working fine.
However, when this dataset gets refreshed on the service (on a scheduled time), all data in the visuals used in the published reports is gone after the refresh is complete. So the visuals are still there, but without data, or data is missing.
The only way to get data back is to publish again from within power bi desktop
So i wanted to do a test: I deleted all tables in my dataset, except one (loaded from topdesk odatadeed), and deleted all columns of this table except one. This table/column only contains ids. There are over 60k records in there.
Now even when I publish this and refresh on the service after, the report shows wrong numbers;
Top is the count in powerbi desktop and below is count after a refresh on the service
1. Every time you refresh a dataset in the power bi service, it is replaced with what is in the data source, if the data source may not have data, the old data will be cleared when you refresh and the result will be empty.
Or the low number of rows seen in the power bi service may be due to the low number of rows in the data source at the time of refresh
When you configure a time for scheduled refresh, there can be a delay of up to one hour before it begins. Make sure the Enterprise Gateway is running and you edit correct credentials. Then you can check if the refresh occurred times within a period in Refresh History.
3. Whether the functions of Now() and Today() exist in your dax formula, the Today() function on the Power bi service returns today’s value according to the UTC() time zone, while the Today() function on the Power bi desktop shows the computer’s system time, so in Power bi service, your time zone and standard time are different, resulting in data not appearing.