Airtable to PowerQuery

[Julien13]

Hello, 

I have a Power BI report connected to Airtable that fails to refresh. On app.powerbi, when I try to actualize the report, I have this error message : 


Can you help me please ? 
Thank you ! 

[freginier]

Hi Julien,

This error is related to how Airtable returns certain field types (like linked record fields or lookup fields) that Power Query cannot directly convert to a text value. The error [ValidateMarkupTags][ccon]Expression.Error: We cannot convert the value [ccon]"[Record..." typically occurs when a field contains a record or list instead of a simple value.

Here are a few steps to fix this:

1. Expand the problematic column: In Power Query, find the column causing the issue (it likely shows [Record] or [List] as its value). Click the expand icon in the column header to expand records, or use Table.TransformColumns to convert list/record values to text.
2. Convert List fields to text: For Airtable linked fields that return a list, use this M formula:
   Table.TransformColumns(Source, {{"YourColumn", each Text.Combine(List.Transform(_, Text.From), ", "), type text}})
3. Use Table.TransformColumnTypes: After expanding, ensure all columns are properly typed before loading.
4. Check your Airtable connector version: If you are using a custom Airtable connector or the Web connector, make sure it is up to date. Some older implementations do not handle multi-select or linked record fields correctly.

If you can share which column is causing the issue, that would help narrow down the exact fix.

Hope this resolves your refresh error!