Webcall Limitations

[Gabry]

Hello,

I'm building a report ingesting data using web connector, calling some APIs. Are there any limitations on powerquery / powerbi side? Like some row limitation, or amount of data that can be retrieved per call, or any other limitation i should know?

Thanks

[Anonymous · Accepted solution]

Hi @Gabry ,

While Power Query itself doesn't impose a hard limit on the number of rows you can retrieve per API call, practical limitations are often dictated by the API you're connecting to and the performance characteristics of your Power BI environment. For example, if you are ready to publish your report to Power BI Service with Import mode (Using the API to get data can only be Import mode), for data models stored in shared capacities in the Power BI service, there's a 1-GB size limit. If you're working with large datasets, consider using Power BI Premium for larger semantic models.
And many web APIs enforce rate limits, which restrict the number of requests you can make within a certain timeframe. It's important to consult the documentation of the specific API you're using to understand these limits and plan your data retrieval strategy accordingly.
TripPin 2 - REST - Power Query | Microsoft Learn

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[johnbasha33]

@Gabry 
 When you're working with Power BI and APIs to pull data into your reports, there are a few things to keep in mind. First off, don't overload Power BI with too much data all at once, because it has its limits. Also, be gentle with the APIs you're using – bombarding them with requests can slow things down or even make them stop working for a bit. Try to keep your datasets manageable, as really big ones can cause issues. Some APIs might not work perfectly with Power BI, so you might have to get creative. Keep your data transformations simple, because complex stuff can cause problems. And don't forget about privacy – handle sensitive data carefully. Lastly, stay updated on any changes to Power BI and your data sources, as you might need to tweak things as they evolve.


Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!