Forum Discussion
How do I Loop in M to Query Last 40 Days a Day at a Time Using Web URL API
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/
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/