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 ...
Need Help
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?

  • danextian's avatar
    danextian
    Super User
    2 years ago

    Hi PowerBIHelp1234 ,

     

    This is worth investigating. Can you please share a sample data?

    • PowerBIHelp1234's avatar
      PowerBIHelp1234
      Regular Visitor
      2 years ago

      Its generally pretty simple below, not sure how to upload an excel but this should give the idea

       

       

      • danextian's avatar
        danextian
        Super User
        2 years ago

        Hi PowerBIHelp1234 ,

         

        You screenshot doesn't show how your data is described. There is no "=4237" or something like that. You can post a link Google, OneDrive or Dropbox. You can post your M code as well.