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

Question

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 Answer

@pwatkinson , find an empty string column and replace it with null, and then try 
https://docs.microsoft.com/en-us/powerquery-m/text-replace

Forum Discussion

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

1 Reply

Related content

Snowflake connector: "We cannot convert the value null to type Text"

Copy Job deceivingly says "Overwrite" when some tables are "Append"

power bi paginated report builder "report properties" "expression"

Convert a String Expression into a Boolean Expression and "solve" it

Fast Load "export" to Excel

Forum Discussion

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

Snowflake connector: "We cannot convert the value null to type Text"

Copy Job deceivingly says "Overwrite" when some tables are "Append"

power bi paginated report builder "report properties" "expression"

Convert a String Expression into a Boolean Expression and &quot;solve&quot; it

Fast Load "export" to Excel

Convert a String Expression into a Boolean Expression and "solve" it