Forum Discussion

ChrisPBIUser's avatar
ChrisPBIUser
Helper III
4 years ago
Solved

API Error in Power Query

Morning,   I have several lean reports connecting to one dataset in services and the last successful refresh was 9pm last night (30th Mar 22).  However, the first refresh this morning at 6am (31st ...
Need Help
  • ChrisPBIUser's avatar
    ChrisPBIUser
    4 years ago

    Since posting the next scheduled refreshes have been OK with the api data source not being changed.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi ChrisPBIUser ,

 

Such error is coming from Power Query when you are loading data, and somewhere either in your M code or source data, you are getting a Record type of data and are then trying to handle it like a List data, thus the error.

Please go to Power Query window, and navigate to the error steps,

 

About Convert  Record type/ List Type, please kindly refer to:

Record.FromList - PowerQuery M | Microsoft Docs

Record.ToList - PowerQuery M | Microsoft Docs

 

A similar thread:

https://stackoverflow.com/questions/63614882/power-query-expression-error-a-value-of-type-record-cannot-converted-into-typ

 

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

  • ChrisPBIUser's avatar
    ChrisPBIUser
    Helper III
    4 years ago

    Cheers for your reply.  It transpired that the source system was down which was causing the load error but I'll take on board your advise should it happen again.