Forum Discussion
Different data between Power BI Desktop and Power BI Service after the upload
Anonymous
ok so you think that the different data comes from the different time I actualize in PowerBI Service and PowerBI Desktop, right?
The data I get from the server will get updated only one time a day in the night. So when I actualize the data with the scheduled refresh in the early afternoon and a manual refresh in Desktop a few minutes later, I should get the same data I think.
As I mentioned that the available hours were calculated by measures and excel sheets, so they don´t come from the SQL server. That´s what I´m worried about why this is different.
What I found out is that there are only a few technicians in a few months were the data is different between PowerBI Service and Desktop.
Furthermore I found out that the scheduled refresh works fine, so the status is completed. Whe I want to update the data in Service with Refresh now, the refresh failed.
Refresh history
Helper II am experiencing the exact same problem.
After I publish my pbix to PBI Service, the data matches what is in PBI Desktop. Shortly after, a scheduled refresh runs and the data displayed in Service is different.
The source data is not changing between the time I publish the pbix and the time when the schedule refresh runs.
Hi nwrong,
and what are you doing to get the correct data now? Do you make a manual refresh in Dektop once a day?
I don´t know what to do and the refresh every day is really annoying. Is the false data you get from a created measure or the data from an Excel file / SQL server?
- nwrong
i'm unable to get the pbi service to display the correct data.
I guess i could disable the scheduled refresh and manual refresh and republish from PBI desktop each day....
Maybe one solution is to write a ticket to Microsoft to solve this problem...I don´t know what to do and don´t want to refresh it every day by my own.
Anonymous I'm experiencing the exact the same problem. Did you figure out what was causing the difference?
Thanks,
Tim
Hi TT,
no I don´t know why we have that problem when we have the sheduled refresh...
It works when you do it manually, but not with the scheduled refresh?
Br,
Christopher
Hi Anonymous,
Thanks for your quick response.
The refresh in PBI service, both manually and scheduled, gives different results compared to a refresh in PBI desktop. Though, no errors are shown when running the data refresh. Like you, data source is only updated once a night.
Today I ran a manual refresh in service and there were only small differences, half an hour later I refresh again manually and huge differences appear. I'm clueless...
Br,
Tim
- Hi,
I'm having exactly the same problem with Power BI Service. When I refresh my data in Power BI Desktop I see two tiles with correct values, let's suppose 20% and 50%. When I upload this report to Service this data is still the same, but the problem appears when I activate a manual or scheduled updation in Service: then, these two tiles go to zero! In comparison, I refresh my data in Desktop and these two tiles show figures different to zero, which is the correct result.
What's happenning? This is a very annoying issue. Should I open a ticket yo Microsoft?
