Forum Discussion
API Pagination Assistance
Hi ,
Some columns contain Lists, but transformations assume they are Text.
So try using Text.Combine to convert lists to text before applying transformations.
Paginated results include incompatible types (e.g., Lists) during combination.
So Convert all results to tables using Table.FromList before combining them with Table.Combine.
Apply Table.FromList wherever the API response is generating a List instead of a Table.
Apply Text.Combine after loading the data from the API and before performing transformations that expect Text values
Furtehr go through applied steps to get understanding where these arer happening
Hi Anonymous ,
Thank you for reaching out to the Microsoft Fabric Community Forum about the issue you are encountering.
The error occurs when trying to treat a list as a single text value. Power Query cannot automatically convert a list into a text string.
1.If the data is returned as a list, you might need to expand it into individual records first. Use Table.ExpandListColumn
2.If trying to convert a list to text, you might need to first extract a specific value from the list before converting it.If want to combine the entire list into a text string, use Text.Combine().
If still facing difficulty in resolving the issue, please feel free to reachout.
If this post helps, please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.
Regards,
Pallavi.