Data not showing

[Anonymous]

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.

[amitchandak]

@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

[Tahreem24]

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

[parry2k]

@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.⚡

[Anonymous]

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

[Anonymous]

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]

Hi @Anonymous ,

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

Thanks,

Pragati

[Anonymous]

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]

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]

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.

[Anonymous]

You need to show us what's going on with query editor. 

How about sending us a screenshot of that or showing us the advanced editor? 

[Anonymous]

[parry2k]

@Anonymous you need to read this post to get your answer quickly.

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Good luck and I hope someone can help you.

[Anonymous]

What else should I put for better understanding on this question?

[parry2k]

@Anonymous so hard to debug with the image, it is like shooting in the dark but one thing:

- in side by side screenshots, you have a tab in excel which you are not even using in power bi, you are feeling on the sheets in 2nd step with years? Don't know if that is the reason but from screenshot I think you are not comparing same things

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.⚡

[Anonymous]

It is same file and the one you see is calculated column that I do not think it will cause problem. I'll edit my question with detailed picture. 

[parry2k]

@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]

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.