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?
Good Day Cherezaan
We unfortunately don't have an example with the XML embedded because the XML is posted as part of the data of packet.
As for the dynamic XML date. That would have to be done be code on the client side as the API itself looks for just that specific field.