Data in PBI desktop different from published

[fvdyoshida]

Hello everyone, 

i got an anoying issue now and I hope someone could give an idea. I have a report using a table that shows several lines and it works fine in PBI desktop, however when I re-publish the report some lines just disapear.  If I delete the report/ dataset before publishing it works, but the problem is that I cannot delete the report every time that I update something because my users will lose the original report URL. 

Any ideas on what I am missing or doing wrong?
thank you in advance

Fabio

[edhans]

Do you have a filter set? Republishing a report will not erase filter selections by default, but deleting and republishing will.

You can press this button in the upper right to reset filters to report defaults. 

[Tutu_in_YYC]

Hey Fabio,
When you say "line", are you referring to rows of data or cosmetic lines? Do you have examples?

[fvdyoshida]

Hi Tutu, 

those are rows that are not being showed on the published version, but I can see them in the Desktop App. 

[Tutu_in_YYC]

Missing data is the challenge here. Have you tried @edhans  recommendation?

[fvdyoshida]

hi Tutu,

yes, I did but without sucess. 
I tried to simulate publishing into a different Premiun area and got same results.
it only worked if I delete completely and publish as new. But as I said, I cannot do that on production once it will change the report URL and my users will get lost

[edhans]

You will need to provide screenshots including what the visual filter shows. 
for example:

This is not a bug. There is just something we are not understanding here in how your dataset is being filtered.

[Tutu_in_YYC]

That is not a normal behaviour. Seems like the dataset is not being overwritten correctly.

Can you try republishing it, refresh the dataset and check again? Also refresh on Power BI desktop again and compare. This can rule out refresh timing issues, ie comparing both report with the most updated data and the same point in time.