Forum Discussion

ElvirBotic's avatar
ElvirBotic
Icon for Helper III rankHelper III
4 years ago

Error Expanding Column to New Row

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...
Need Help
v-zhangti's avatar
v-zhangti
Icon for Community Support rankCommunity Support
4 years ago

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-to/m-p/1149570#M521825 

 

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's avatar
    ElvirBotic
    Icon for Helper III rankHelper III
    4 years ago

    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.