Forum Discussion

PowerBIHelp1234's avatar
PowerBIHelp1234
Regular Visitor
2 years ago

Loading Excel With =Value into PowerBI

Hello,

 

I have a script that is saving down a grouping of excels. Unfortunately, the cells have =Value (meaning one cell might have "=324" and another may have "=4237") and because of this when I load into powerbi the values show as 0. Does anyone have some alternatives I could like at without having to open each one up and save them as values?

 

Thanks

Need Help

7 Replies

  • danextian's avatar
    danextian
    Super User
    2 years ago

    Hi PowerBIHelp1234 ,

     

    You need to clean that column before changing the data type. You can right click the column, replace values, to replace: = with: null. This must be done prior to changing the first Changed Data Type (that is usually generated automatically) applied step.

    • PowerBIHelp1234's avatar
      PowerBIHelp1234
      Regular Visitor
      2 years ago

      Thanks for the response, unfortunately that did not work and the values just appear as 0. Any other thoughts?