OLE OR OBDC Error: [Expression Error] We cannot convert the value "" to type table

[Anonymous]

Hi, I am a total newbee when it comes to Power BI, so please be patient. We are working with a SharePoint data set online that has gotte too big for any other BI tool, so Power BI is the only solution that comes to mind. When I try to apply the query changes to column lists in order to show hidden values, I invariably get the following error message. Your help is sincerely appreciated.

[amitchandak · Accepted solution]

@pwatkinson , find an empty string column and replace it with null, and then try

https://docs.microsoft.com/en-us/powerquery-m/text-replace