Forum Discussion
Different data between Power BI Desktop and Power BI Service after the upload
Hello Anonymous,
thanks for your answer, but the filter in Power BI Service are the same. So I clicked on refresh in Power BI Desktop and uploaded it to Service. The data is equal after that, compared to the data from Desktop. Then I figured out, that the data differ when there comes the scheduled refresh after the manual refresh from Power BI Desktop.
That is really strange, because the available hours are calculated and the data gateway to the SQL server is online anyway...
Greetings
Chris
Anonymous,
After you upload the PBIX file the first time, do you click "Refresh Now" in Power BI Service?
Regards,
Lydia
Hello Anonymous,
I don´t know if I did that a few months ago. But when I click on "Refresh now" in Power BI Service after the manual refresh and upload from Power BI Desktop, I get the different values...
Anonymous,
You don't refresh the data in Power BI Service and Power BI Desktop, there is a possibility that you get different values as you may have different data in the data source at different time.
Regards,
LydiaAnonymous
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