Forum Discussion

kasife's avatar
kasife
Helper V
3 years ago

Call APi

Hello guys, I'm trying to call an API, and I'm using the page parameter to make the call. It turns out that this API seems to me to have no pages. How could I adjust the call of this function to be ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi kasife ,

You can refer the following links to connect API in Power BI Desktop using Web connector:

Power BI Using List.Generate to Reduce API Calls with Pagination - Strategy, solutions & Power BI for Data-Driven organizations (excelando.co.il)

How to Use List Generate to Make API calls in Power Query - YouTube

Solved: Using list.generate() to query an endpoint multipl... - Microsoft Fabric Community

And this error may occur when you are trying to access a list element by using a field name instead of an index.  The following links are the ones which have the similar problem as yours, hope they can help you solve your problem.

Solved: Re: Help with List.Generate() in making API calls - Microsoft Fabric Community

Solved: Expression.Error: We cannot apply field access to ... - Microsoft Fabric Community

Best Regards