Forum Discussion
Create Sharepoint folders based upon power bi table
I think you could probably do this with the "query a Power BI dataset" action in a scheduled Power Automate flow. What I would do is create a hidden tab in your report that shows the rows you consider "new" - so a relative created date filter or similar, then get the query from that from the query optimizer (it has an option to "copy DAX") and use that in your Power Automate flow.
Then, use the Parse JSON action on the response from the querystep and use a for-each loop on the table rows. Inside the loop, you can use the action to create a SharePoint folder with any of the parsed data from the table (e.g Account Name and/or ID).
Make sure the refresh schedule on the semantic model and the Power Automate flow schedule are relatively close together - if you want to you could put an action to refresh the model as the first step in the flow, too.