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,
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?
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.