Error Expanding Column to New Row

[ElvirBotic]

I have a SharePoint source in Power BI. I am using version 2.0 for the SharePoint online source. I pick my two SharePoint lists and I have to "expand to new rows" then I select if I want the title in some cases and in others the value. 

In this case when I hit expand to new rows I get an error. When I hit close and apply I get another error (last pic) I do not know how to fix this when I need the columns in my report. 

[v-zhangti]

Hi, @ElvirBotic 

This happens if you have mixed data types in your column to expand. Perhaps you could change the format of this column to Text consistently.

Then you filter which row is error.

This is the relevant document, hope to help you:

https://community.powerbi.com/t5/Desktop/Expression-Error-We-cannot-convert-a-value-of-type-Record-t... 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[ElvirBotic]

Unfortunately this did not work for me. I have tried multiple ways and each way including this one and the link provided did not work for me. 

[freginier]

Try to keep error before expand to new rows. Do you have errors ? 

[ElvirBotic]

Only the last screen shot I sent in the original post. SOmething about converting value "" to type table

[freginier]

But can you before the "expand to new rows" step add another step to keep errors and then see which row generate this issue... 

[ElvirBotic]

I think it is the entire column...