Forum Discussion

cestrace's avatar
cestrace
Regular Visitor
4 years ago
Solved

Report does not contain data

This happen when I uploaded and transformed the data in the Desktop version.  I apply my changes and then when I open report it's blank.  I've tried this three times with the same results.   How do I fix this? 

 

 

 

Please help! 

Need Help
  • cestrace's avatar
    cestrace
    4 years ago

    I think I found it, some how a lot of extra rows were created in the table.  when I sort by deccending data it all shows up. 

10 Replies

    • cestrace's avatar
      cestrace
      Regular Visitor
      4 years ago

      Yes, when I use the sort arrow the data is there as well. 

      • cestrace's avatar
        cestrace
        Regular Visitor
        4 years ago

        I think I found it, some how a lot of extra rows were created in the table.  when I sort by deccending data it all shows up. 

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    cestrace I'm asking what happens if you see it in the data table view after the query is applied. Click on the arrow next to any of the columns and see you see the value. 

    • cestrace's avatar
      cestrace
      Regular Visitor
      4 years ago

      Yes, if I use the drop down and pick a value it populates. 

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    cestrace do you see data in PQ? What happens if you click on the arrow on any of the columns? Does it show any values?

    • cestrace's avatar
      cestrace
      Regular Visitor
      4 years ago

      Yes, in transform, PQ , I see the data. 

      • cestrace's avatar
        cestrace
        Regular Visitor
        4 years ago

        Here is a sample, it's all there, it even will show up in visuals. 

  • parry2k's avatar
    parry2k
    Super User
    4 years ago

    cestrace so it means data is there, there are just some rows with empty values. You have to check the data at the source. Not sure what the actual issue is? You don't need to verify your data at the source.

     

    ✨ Follow us on LinkedIn

     

    Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡