Forum Discussion

ExceLover's avatar
ExceLover
Frequent Visitor
2 years ago

SharePoint imported data containing blank cells not treated as blank

Hi,   I have a dataset that is a List in SharePoint, and it has has several columns. Some columns have several rows that do not contain data. This dataset was imported into Power BI from SharePoint...
Need Help
vicky_'s avatar
vicky_
Icon for Super User rankSuper User
2 years ago

It might be the type of the column - for example, if the type is a string, then blank values are treated as an empty string (""), rather than a null value. So instead of checking for ISBLANK(), you would need to check for [Field] = "".
I think this article might help: https://www.sqlbi.com/articles/blank-handling-in-dax/