Is it possible to get the CSV file of the URL link of the email that is sent from the Data Monitor in Power Automate?
I enter the URL link and put in the Headers the Basic authorization, but it does not work. Is something missing in the settings?
I use the same URL link and Headers settings in Power BI to get data from a web data source and it works.
ACCEPTED SOLUTION
Accepted Solutions
THe following url can output or download the results of query builder reports as CSV and other formats.
Use the custom input page to select an output format, wtcore\jsp\report\reportGenForm.jsp, then generate the report and copy the url.
Should be OK to use that in power automate, I have used it in powerquery/automate too with basic auth from power desktop and report server
THe following url can output or download the results of query builder reports as CSV and other formats.
Use the custom input page to select an output format, wtcore\jsp\report\reportGenForm.jsp, then generate the report and copy the url.
Should be OK to use that in power automate, I have used it in powerquery/automate too with basic auth from power desktop and report server
I think this is one part of the answer. The OP states needing to grab the URL from the Data Monitor which leads me to believe that - yes, the intent is to ingest the resulting file from the Data Monitor link into Power Automate. If the Data Monitor has multiple runs then just knowing one URL to give Power Automate (a static input) will not work if you intent to get the latest file output from the Data Monitor. The URL will change over time with each execution of the Data Monitor. I did something similar once
With this subselect to narrow down the criteria to a single Data Monitor (hard coded) and also the latest "saved report holder" in the Data Monitor, i.e. the URL/file from the last execution. This is done with subselect just finding the latest "saved report holder" with the latest modified date.
In my case I was using this to return an XML payload to Power Automate. The way I had it setup was Power Automate would call this report and ingest the result which included the dynamic parts of the URL. Then I would create the full Data Monitor URL in Power Automate by combining with the static parts of the URL - done all using variables. Then I could make another HTTP GET request to the full URL that would provide the full payload of the executed Data Monitor "file".
