Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
SO WHAT:
Does Power Query have a way to append data called through a web API rather than replacing it with every call?
Background:
I'm using a web API to get data from a 3rd party server on a scheduled frequency. The API configuration, unfortunately, only allows me to call 30 days of historical data on a rolling basis. This is problematic because I often need more than 30 days of historical data for specific analyses. I'm hoping Power Queary has a way of getting the data from the web API and adding to the existing data rather than replacing it with each call.
I would greatly appreciate it if someone could give me some guidance on this, please?
Thanks!
Hi @Anonymous ,
You can use the Web.Contents function to call the API, please refer to this documnet for the detailed steps:
Call a Web Service for each Row in Power Query | Power Query How-To | Nellis Consulting, LLC
Hope it helps!
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.