Forum Discussion

Helper I

4 years ago

Need suggestion on PowerBI-MQuery Looping for calling the API

Hi All, I am working on one requirement like :Get the total virtual mechines data by calling one API in loop passing subscriptionid to the api. can you some one please suggest/provide any sampe lik...

Need Help

Anonymous

Not applicable

4 years ago

I was anticipating that you will get a "table" as response. No probs, after the stage you have shown in the screenshot, add one more column using Table.AddColumns and use the function Record.ToTable() after "each" to covert the "Records" to "Tables". Refer to the following link

https://docs.microsoft.com/en-us/powerquery-m/record-totable

This will convert the records to a table in your new column, which you will be able to expand.

After converting, you could remove the "API Response" column that you got as "records". You no longer need it. I hope it will solve the problem.

Also, take a look at Table.FromRecords. I am not sure which one to use - Table.FromRecords() or Records.ToTable().

Hi ImkeF , Could you please help?