Data revenue double when publish to PBI app service

[khanh_nguyen123]

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.

[v-janeyg-msft]

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

[rajendran]

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.

Thanks

Raj

[khanh_nguyen123]

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.

Regards,