Forum Discussion
powerbin00b
8 years agoNew Member
How to Import Excel Errors as cell value and not as error? (=+keyword instead of #NAME?)
Hi all, I have a weekly search keyword report that I want to upload to PowerBI via excel. For some reason some keywords have a + in front of the word. For example, +keyword. Excel then automat...
powerbin00b
8 years agoNew Member
Hi all,
I have a weekly search keyword report that I want to upload to PowerBI via excel. For some reason some keywords have a + in front of the word. For example, +keyword. Excel then automatically converts this cell to be =+keyword
Excel then goes a step further to show the cell as a name error (#NAME?). When I import this file, Power BI classifies these values as 'Errors'. Is there a way I can have Power BI import the cell as =+keyword and then I can clean the data within my Power BI query rather than having to clean the excel file prior to upload each week?
Thanks!