Forum Discussion
Different data when actualizing with Desktop or with gateway in Service
Community SupportHi Anonymous,
Please make sure you get results at the same time both from Power BI service and Power BI desktop after refresh.
You can download a copy from Power BI service, open the report in Power BI desktop, click the Refresh Now for the dataset in Power BI service and Refresh in Power BI desktop at the same time, then compare the results.
Also please try to update the on-premise data gateway to the latest version, you can confirm this from the gateway owner. Run the latest Power BI desktop version as well.
Best Regards,
Qiuyun Yu
Hi v-qiuyu-msft,
I downloaded the pbix file from BI Service and clicked on Refresh. It was the same problem. Then I clicked on the different months and I saw that the data was false only in the month of July or before.
The utilization and the percentage of booked and available hours are coming from a created measure.
The booked hours are coming from our server, the available hours are created in Power BI with a calculated column, because of the different holidays in each region of Germany, Belgium and the Netherlands, what our system can´t handle very well.
So the data from this column is different in Desktop and in Service, but the data does not come from the SQL server.
Hours on 10th of July in BI DesktopMeasure for the available hoursHours on 10th of July in BI Service
- v-qiuyu-msft
Hi Anonymous,
That's too strange. Till now, we can't provide much more effort on forum side. I would suggest you create a support ticket to get dedicated support.
Best Regards,
Qiuyun Yu