Forum Discussion

Anonymous

Not applicable

5 years ago

Solved

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

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 solutio...

Need Help

amitchandak
5 years ago
@pwatkinson , find an empty string column and replace it with null, and then try

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

amitchandak

Super User

5 years ago

@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

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

Convert whole number column ("YYYYmmDD") to date column

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

Convert whole number column ("YYYYmmDD") to date column

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