We'd like to do a visualisation on the number of calls made etc using PowerBI. Currently, to connect to the API we use the web connector with PowerBI. Do you have an example of the url with the xml embedded within to share?
That being said, is there a way to make the end date in the xml dynamic ie, for it to continuously change as the dates change? That way we won't need to alter the connection url in order to change the end date?