Forum Discussion
How do I Loop in M to Query Last 40 Days a Day at a Time Using Web URL API
Hi all, So as fairly new to using M and Power Query, I was trying to adapt things from this post: https://community.powerbi.com/t5/Desktop/Iterating-over-start-and-end-dates-for-multiple-API-calls/...
Hi Anonymous ,
the simplest loop in Power Query is to add a column to a table: The command for the column will be applied for each row.
So you can create a table with the last 40 days in one column and then you add a custom column that makes the web call. There you reference the day-column to make a reference to each day.
But if you want to refresh that in the Power BI Service, you have to move parts of your URL to query parameters unfortunately:http://blog.datainspirations.com/2018/02/17/dynamic-web-contents-and-power-bi-refresh-errors/
