Forum Discussion
Helper IVDebugging Power BI Web API Refresh Issues
Hi qmestu Thank you for reaching out to the Fabric Community.
AshokKunwar , danextian , GeraldGEmerick , Thank you for your prompt responses.
I wanted to follow up and confirm whether you’ve had the opportunity to review the information shared by AshokKunwar , danextian , GeraldGEmerick If you have any questions or need further clarification, please don’t hesitate to reach out.
We truly appreciate your engagement and thank you for being an active part of the community.
Best Regards,
Lakshmi.
Super UserHi qmestu
Without using the diagnostic tool, the latency is likely due to the volume of data. The API may be throttling requests to protect overall performance. Querying large datasets directly through the web connector is generally not recommended.
A better approach is to use dataflows to separate historical and current data, then recombine them in Power Query. Only the current data needs frequent refreshes. If connecting to the historical dataflow is still slow, consider further splitting it into smaller time-based partitions. This reduces repeated API calls and prevents Power Query from retrieving the full dataset on every refresh.
Some organizations that retrieve data from APIs store it in a database and periodically update it with newly created or modified records.
Helper IVHow does one go about using dataflows?