Forum Discussion
Some data from SharePoint List column showing as null
Hello - stuck here on an issue importing a SharePoint list into Power BI. The problem column is a single line of text column as below, with no blank entries, all entries below the maximum number of c...
Hi ManEff ,
I would suggest changing the format of the StrategicObjective in Sharepoint to "Multiple Lines of Text". There could be a character in the field that is difficult to identify but is causing an issue with the "Single Line of Text" limitations, such as a line break.
Changing the format of the field shouldn't affect the size of the dataset too much, if at all, but it might solve this issue.