A new Microsoft Power BI connection adds the Power BI query data source. Pick a Power BI workspace and a semantic model, write a DAX query, and use the rows it returns in your pages like any other data.
Your Power BI administrator needs to allow the Execute Queries API for your organisation.