Forum Discussion

Ramen's avatar
Ramen
Regular Visitor
3 years ago

The Data value changed to 0

The value of my data from Microsoft Excel changed to 0 when i import it to Power BI. I have try to changed the format from Power Query Editor and i also try changed the format from Excel before i import the data to Power BI, but the result in Power BI always became 0. What should i do so that the data doesn't change to 0?

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

1 Reply

  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    3 years ago

    Hi Ramen 

     

    Impossible to help you without seeing your data and the query in PQ.

     

    I can't see how the data just changes to 0, something must be changing it if it isn't already 0.

     

    regards

     

    Phil