Why Should I Be Interested in the ExecuteQueries Endpoint of PBI REST API?

Although it also brings limitations, I think that its advantages outweigh them. So what can it be used for, and why should I be interested?

I was honored to be part of a live stream of the amazing Reid Havens. We discussed this end-point, and I showed some possibilities of its use in combination with Power Automate. The entire recording can be viewed here: