Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Published Report does not match report on desktop

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

 

11 Replies

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    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

    • Anonymous's avatar
      Anonymous
      Not applicable

      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.

  • Hey Anonymous ,

     

    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

    • Anonymous's avatar
      Anonymous
      Not applicable

      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

    • Vijay2458's avatar
      Vijay2458
      Regular Visitor

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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous 

    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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable

      Anonymous

       

      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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Anonymous 

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable

      Anonymous 

       

      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

      • Anonymous's avatar
        Anonymous
        Not applicable

        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