Expected duration: 1 day or less I'm using Power Automated to run a query against a Power BI data set, as the end goal is to extract the data automatically into XML format. At the moment, the query hits a limit of 500 rows regardless of how many columns of data we query (30). The solution is to set up pagination logic with a loop in Power Automate, but I am happy to consider alternative options.
Ideally, this should be exported to an XML format and pushed into a folder. This can be done in many ways, so we are interested in the most reliable method. We have previously pushed this to SQL each time and ran the query against the table, so we are happy to do this or any other method as long as the XML format is the result.
This task will be completed over Zoom/Teams with a screen-sharing with myself so I can understand how it's completed, and we can test it works together. You'll need to communicate well verbally and in writing, as we will communicate online.
You can only apply if you have previously completed a similar exercise and can show that you can complete the task when you apply. I'm always looking for developers to work with on an ongoing basis.