Power BI: How to generate a table of daily web traffic reports? Help?
I pull data from a digital site via an API into Power BI for reporting. The API has an analytics endpoint for a web traffic report, but it is ONLY an aggregate report, as in it won't make one call and separate it into individual days. I can call (below) to show the traffic for any particular day. I would like to write a query to use this API call to generate a table where each row is the traffic for a day starting at 2022-05-15 until whatever the current day is. So a row for 05-15, 05-16, 05-18, until the current date.