cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
khanh_nguyen123
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:

khanh_nguyen123_2-1636728832807.png

 

PBI App service:

khanh_nguyen123_1-1636728802978.png

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.

3 REPLIES 3
v-janeyg-msft
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

rajendran
Super User
Super User

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

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.

khanh_nguyen123_0-1636774609163.png

 

*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,

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it Out!

Join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors