API Pagination Assistance

[bmoon]

Help! I've been working on getting paginated API results, but Power Query is returning an error that says: "Expression.Error: We cannot convert a value of type List to type Text." Can you help me figure out where I'm going wrong?

Here is my code:

[Akash_Varuna · Accepted solution]

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.

[v-pagayam-msft]

Hi @bmoon ,

As we have not received a response from you yet, I would like to confirm whether you have successfully resolved the issue or if you require further assistance.

If the issue has been resolved, please mark the helpful reply as a "Accept as solution" to indicate that the question has been answered and to assist others in the community.
Thank you for your cooperation. Have a great day.

[v-pagayam-msft]

Hi @bmoon ,
We haven't heard back from you regarding our last response and wanted to check if your issue has been resolved. If our response addressed your query, please mark it as Accept as Solution and click Yes if you found it helpful.If you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-pagayam-msft]

Hi @bmoon ,
I wanted to follow up on our previous suggestions regarding Power Query converting a value of type List to type Text error . We would like to hear back from you to ensure we can assist you further.
If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if still require assistance.

Thank you for being a part of Microsoft Fabric Community Forum!

Regards,
Pallavi.

[v-pagayam-msft]

Hi @bmoon ,

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.

[Akash_Varuna · Accepted solution]

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.

[bmoon]

Where should I add the Table.FromList to the script? I fiddled around with adding it in a few places and I wasn't successful getting it to work.

[Akash_Varuna · Accepted solution]

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