Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

[Expression.Error] We cannot convert a value of type List to type Record.

Hi there I am new to PowerBI and learning as I go. I am using PowerBI to query a REST API, and this is all working correctly. I have created a measure which again works correctly, however I have cre...
Anonymous's avatar
Anonymous
Not applicable
5 years ago

I must admit this is getting abit above me at the mo and I will need to go back and take on board all suggested here, I would like to say thanks to both for the help and guidance provided so what is the best way to the thanks to the both of you - click the kudos button on different posts?

edhans's avatar
edhans
Icon for Community Champion rankCommunity Champion
5 years ago

Absolutely Anonymous- always good to give kudos to posts that are helpful. 👍😁

 

sorry couldn't be more help. It is difficult to troubleshoot shoot errors on a forum and even more so when it is the result of nested tables, lists, and records. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    You are using a list as your parameter for the getpage() function [Column1]. You could probably just do Table.AddColumn(PriorStep, "Page", each [Column1])

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi thanks for the reply, is that in reference to line 6 #"Converted to Table" or line 7 #"Expanded Column1" - please?

     

  • Icey's avatar
    Icey
    Icon for Community Support rankCommunity Support
    5 years ago

    Hi Anonymous ,

     

    Based on the current information, I cannot reproduce your issue. It is suggest to provide more information to help me better understand the issue you are experiencing.

     

     

    Best Regards,

    Icey