Forum Discussion
Importing Excel spreadsheet from SharePoint Site - Some cells are replaced with blanks
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...
Hi,
I have double checked the column and the cells are definitely formatted as text.
This particular column can have the values Yes, No, N/A or - (when the column value has not been set).
Yes and No are showing fine, but both N/A and - are converted to blank.
Hope this clarifies.
Super UserAre these cells produced through VLOOKUP?
What is the problem with the null/blank representation?
Hi,
No, the values are typed in manually.
"What is the problem with the null/blank representation?" - I don't know what you mean by this?
- lbendlin
I 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.