Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Power Query importing 0 instead of numbers from csv file

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

Need Help
  • sanalytics's avatar
    sanalytics
    5 years ago

    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

     

  • Jimmy801's avatar
    Jimmy801
    5 years ago

    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

4 Replies

  • sanalytics's avatar
    sanalytics
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
      Anonymous
      Not applicable
      5 years ago

      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's avatar
        Jimmy801
        Icon for Community Champion rankCommunity Champion
        5 years ago

        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