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...
Super UserMost likely the Excel column is formatted as number.
What is the problem with the null/blank representation?
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.
- lbendlin
Are 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" ?