Forum Discussion
Solved
Importing Excel spreadsheet from SharePoint Site - Some cells are replaced with blanks
Hi, The only related post I found was this one: https://community.powerbi.com/t5/Service/Cell-value-quot-TBD-quot-being-imported-a-blank/m-p/219591 I am importing an Excel spreadsheet from a ...
Hi,
Some progress! It appears that if I try to connect to the spreadsheet from the web interface (with Get Data / Files / SharePoint - Team Sites, I guess the problem mentioned above.
I have tried again, from Power BI Desktop this time, using Get Data / Web and enter the direct link to the spreadsheet. The data is now as I expect it to be!
I'm not sure why the behaviour is different, but here we are...
lbendlin
Super User
Super UserI would think that representing "#N/A" as blank/null is appropriate. Unless it literally is a text of "#"+"N"+"/"+"A" ?
Hi,
In this column a blank value and the text value "N/A" are valid, and have a different meaning, hence why I need to show both within PowerBI.