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

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.

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. 

    • Pragati11's avatar
      Pragati11
      Super User
      6 years ago

      HI Anonymous ,

       

      So you are saying there are values in excel but not in Power BI ?

      It's hard to say anything as you can't share data.

       

      Did you try clciking on the highlighted arrows below to check, if there are relevant values in those columns?

       

      Thanks,

      Pragati

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        if you see the first rows of each image the BUY ID are same but excel has all data filled in but power bi does not.