Report changes once Published to Web

[EGM_Alycia]

Hello, 

When I created a visual in Power BI desktop, the values and data show correctly. However once I publish to the web service, the Values on the report change signifcantly. 
Desktop - Average days to invoice is reporting as 2.15 days 

Service - Average days to invoice is reporting as 101.67 days

All other reports and data seem to remain the same except this specific report. The Refresh is set daily and I have reset the desktop versions to compare. 

Service View

Desktop View

[v-karpurapud]

Hi @EGM_Alycia 

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.

Thank you.

[v-karpurapud]

Hi @EGM_Alycia 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-karpurapud]

Hi @EGM_Alycia 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you

[v-karpurapud · Accepted solution]

Hi @EGM_Alycia 

Thank you for reaching out to the Microsoft Community Forum.

It appears that the issue is related to the dataset refresh, where Power BI Desktop displays the correct average, but Power BI Service reports a significantly different value.

Sometimes, Power BI Service does not fully refresh the dataset due to caching. Even if a manual refresh was performed, cached data may not reflect changes immediately. Please delete the dataset and re-publish the report from Power BI Desktop. Then, manually trigger a refresh after publishing and check if it is working correctly. If it is not, could you please share any error messages you have received in the refresh history? So that, it will be useful to assist you better.

If my response has resolved your query, please mark it as the Accepted Solution to assist others. Additionally, a 'Kudos' would be appreciated if you found my response helpful.

Thank You.

[EGM_Alycia]

Hi Deku, 

I have daily refresh set for 3:00 MST however I did manually refresh both before taking the screen shots. 
The filters have not changed from what was set on the Desktop. There are no additional filters added to the report after publishing. 

[Deku]

• Do you have incremental refresh?
• Have you confirmed there are no filters causing the issue?