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 ...
Need Help
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.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        There is no calculation on power bi. All calculations were made on excel. Basically, you do all works on excel and calculate whatever the value in Excel. Then updated on power bi and it shows like this. never happend before. 

    • Pragati11's avatar
      Pragati11
      Super User
      6 years ago

      Hi Anonymous ,

       

      Can you share the calculations for these columns which are not showing data?

       

      Thanks,

      Pragati

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        There is no calculation made on power bi. All calculations were done in Excel. I do not think it matters and causes error like this. because it worked last time.