Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Data revenue double when publish to PBI app service

Hi @all

Before I managed to publish reports to service and set scheduled refresh normally.

Now when I refreshed data in PBI Desktop the revenue value is correct, but when I published it to PBI app service, it turnt out to be double the value. (I suppose this occurred after I tried to test adding Last refresh date with function MAX(NOW())+(7/24).


PBI desktop:



PBI App service:


I already removed measure with function MAX(NOW())+(7/24), cleared cache in Data load options in PBI Desktop;

deleted the dataset, deleted the current datasource, and re-published a new dashboard with new name, but it is still getting error with value double.


Need help if anyone experience this.

Thanks in advance.

Community Support
Community Support

Hi, @khanh_nguyen123 


Can you check if other reports have the same error?

Is this result a measure or column? How is it calculated? And what is the data source? I need to more details to judge.


Best Regards,
Community Support Team _ Janey

Community Champion
Community Champion

Hi @khanh_nguyen123 

 * By any chance, does your report uses Bookmarks which has different snapshot and showing this data?

 * When you see the report in service, what happends if you click "reset to default" option?

 * Can you refresh the dataset in Power BI service once and refrehs the report too to see how the value changes?


Just trying to narrate the issues here.




Hi @rajendran 

Thanks for your reply.


*I just use Bookmark for Page nagivation, so I may not think it is much relevant to this.

*When I come to service "Reset to default" button, it is greyed out so I didnt click.



*When test again, I click refresh dataset in PBI service, the data is still double.

When I refresh PBI desktop, the value is correct.


Thanks in advance if you can help me find other reasons.



Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors