Published Report does not match report on desktop

[Nicho248]

Hello - 

Using the desktop application. I have a report that pulls data and displays it correctly. However after publishing to cloud, the report is not displaying the data correctly. How do I fix this? Refreshing/republishing does not fix this issue.

Here is a screenshot of desktop and cloud.

Working

Not working

Thank you.

Nick

[V-pazhen-msft]

@Nicho248 

You may check refresh history (Setting-Dataset-refresh history), see if the dataset is refreshed successfully.

BTW, you need to refresh both dataset and report, because report do not automatically refresh with dataset under Import and DirectQuery connection, you also need to refresh report to reflect the changes to dataset. 

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Nicho248]

@V-pazhen-msft 

I checked the history, and the history is clean is 'completed' refreshes. All data upon refresh displays the data in an inaccurate manner, e.g. not working correctly.

I have about 20 other dataset/reports and this is the only one which has had an issue like this.

N

[poojarani]

I am also facing a similar issue, my power bi desktop is reflecting the correct data but after publishing it, it's not reflecting in the same way, My data is in table format.
Please help me ASAP .

In the below ss PBI Desktop is reflecting correct data in Internal Quality - Actual% but after publishing it, it is reflecting the wrong "0.00%".  

Internal Quality Target is showing correctly in Desktop app     After publishing it, internal quality is showing "0" here

[V-pazhen-msft]

@Nicho248 

Please first check 'show as table' of the chart in service and desktop, see whether the difference is the data point or just the display issue. If the the data point are different the problem is mostly likely a refresh issue. Otherwise, it could be a bug.

Paul Zheng _ Community Support Team

[Nicho248]

@V-pazhen-msft

Below the charts, I have a matrix which also displays the data. The matrix and all four charts are missing the data on cloud only. I would agree, seems like a refresh issue.

What would be the next steps?

N

[TomMartens]

Hey @Nicho248 ,

have you tried different browsers?

I face a similar issue some time ago, but then it has been special as I created a R script visual but different versions of the R packages were used, newer on my Desktop and older by the service.

So what visual are you using.

Regards,

Tom

[Vijay2458]

Hi Team , I'm also facing same issue , kindly help me out for this 

[Nicho248]

Hello @TomMartens 

Yes, I have just loaded it up in IE. It displays identically to my 'not working' screenshot, which for reference was through chrome. As a side note, it also displays incorrectly when linked through a teams channel.

edit: missed your other question. The graph is a stacked area chart. I have 4 on my page and also a matrix, I believe all of them are not displaying correctly. In other words, suspecting the data isn't pulling correctly, but I'm just a novice with BI.

N

[Nicho248]

Hello @parry2k ,

Apologize if I was too brief with my initial posting. On the desktop, the report/data looks great and displays correctly. This is the 'working' screenshot. After publishing to cloud the report looks different where the data is not displaying correctly. This is the 'not working' screenshot. So refreshing the desktop does nothing to address the cloud results. Refreshing the cloud data thus far does nothing as well.

Thank you

Nick

[dkpmfa]

I had a similar issue with on-prem. Turns out it was a row level security issue.  When I view it in Desktop I can see everything unless I specifically choose to view as a given person (even as myself).  But when viewed on the web, RLS is always applied.  Don't know if this might help you, but that's what it was in my case.

[parry2k]

@Nicho248 can you do a refresh in the Power BI desktop and see if it give the same output as in the cloud.