@Erik Leaver I made an update to this template:

https://community.blackbaud.com/forums/viewtopic/586/70826

Power BI use of Query API via Power Automate

such that the power automate does not need any updating and can run any adhoc query json definition (where power bi defines the JSON to run and pass it to the flow to run it).

I think would be a good idea to share on this session and remove some barrier on the Power BI folks so they don't have to deal with editing the power automate flow part and still be able to get more data for their power bi.

I haven't update the template post yet, but will do so before the user group meet up