Power Query importing 0 instead of numbers from csv file

[Anonymous]

Hi all , im new to power bi and im facing an issue with power query. 

My question is , is there a problem with my data , or is this a issue with power query? below is some bakground information on the issue with attached photos

This is my csv file , they are number values. ive tried chaning them to text values in excel but power query still imports the values as 0

Csv file

This is the result after loading data in power query , i did no transformation to the csv data in power query, and the data is being imported as 0

data loaded in report

Thanks in advance

[sanalytics · Accepted solution]

@Anonymous ,
Not sure with your exact requirement. Are you trying to convert the column as text which has 0?if so then, you can remove the change type step from Power query.

For better result, Please provide some sample data and your exact requirement.

Regards,

sanalytics

[sanalytics · Accepted solution]

@Anonymous ,
Not sure with your exact requirement. Are you trying to convert the column as text which has 0?if so then, you can remove the change type step from Power query.

For better result, Please provide some sample data and your exact requirement.

Regards,

sanalytics

[Anonymous]

I was trying to figure out why do my imported values from csv file gets transformed into 0s, turns out that when the data gets loaded into the report the 0s are automatically sorted to be the top rows of the individual column.

Also i acidentally pressed accepted as solution.... Is there a way to unaccept this/correct this?

[Jimmy801 · Accepted solution]

Hello @Anonymous 

Could you post the M-code of your query here? Did you check if your data is sorted and therefore maybe your real data is at the end of your data?

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[Anonymous]

yes apologies , i did not check that the data was sorted by 0s first