Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Data not showing

I just updated my data in the source file then I updated some features in query editor. Then, in the data tab it only shows partial data for some columns how do I fix this? 

the last 4 column does not have blacks in the source data.

 

Need Help

17 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous what is your source? What are the values in source data? What is the column type?

     

    Provide a bit more information.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos 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.⚡

  • Tahreem24's avatar
    Tahreem24
    Super User
    6 years ago

    Try to check the possible values clicking on the little down arrow on every column header. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    It's impossible to say without looking at the file. Are you able to share it with us? 

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      My source is excel data that is exactly same as the one on power bi and each column from case 1 to Loyalty have calculation on it. case 1 and 2 are either 0 or 1 , total is total count in the previous year columns loyalty is percentage calculation. I cannot share it because its company data source.

      • parry2k's avatar
        parry2k
        Super User
        6 years ago

        Anonymous are these calculated columns or coming directly from excel? Not fully clear where you are performing these calculations. If these are calculations in Power BI, can you share what expression are you using? Help us to understand so that we can help you.

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    Anonymous , open in edit query mode/  data transformation. Check there any error on the 4 columns. You should some message there, in case of error