Forum Discussion

MichaelHutchens's avatar
MichaelHutchens
Icon for Helper V rankHelper V
3 years ago

Error when loading data: "We cannot convert a value of type Record to type Table"

Hi everyone, I'm getting the following error with my query:   Here's my code: let Source = Table.Combine( { SharePoint.Tables("https://aklcouncil.sharepoint.com/sites/chan...
Need Help
v-yanjiang-msft's avatar
v-yanjiang-msft
Icon for Community Support rankCommunity Support
3 years ago

Hi MichaelHutchens ,

Please check in Power Query, in which step the error begins. Because I have no access to the data source, I can't apply the steps in my side.

 

Best Regards,
Community Support Team _ kalyj

MichaelHutchens's avatar
MichaelHutchens
Icon for Helper V rankHelper V
3 years ago

Hi v-yanjiang-msft , I've isolated the problem a bit more:



Does that help? 🙂

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Icon for Community Support rankCommunity Support
    3 years ago

    Hi MichaelHutchens ï¼Œ

    Please check what's the diffrence of the error cell and other cells before the error occurs.

    Best Regards,
    Community Support Team _ kalyj

Related content