Export a report as excel file onto a server location
We have a requirement to use data in Archer to create some reports on Power BI. For this to work we need to provide an updated data sheet to the power BI team on a regular interval in an excel format. The only option I was able to find if to do it via a data feed but that gives the output as XML.
Do we have any other options to get it in excel format?
You can use Data Publication to publish your solutions to an external database, which the Power BI team can utilize to create/develop the reports. Another option would be to push data through Archer APIs.
Check out the following links: