powerbipowerquerypowerapps

Can a Power BI dataset query be used as a data source in a Power App?


The scenario:

Question:


Solution

  • One method is doing so via Power Automate.
    In Power Automate, within the Power BI connector, you'll find the "Run a query against a dataset" action. Take note: this can only return one table at a time with max of 1,000 rows.
    So PowerApps > Power Automate ( > Power BI dataset ) > PowerApps

    I've just discovered that yes, you can do this directly in PowerApps. Go to Data > Add data > Connectors and Select Power BI. Once done, you can then use PowerBI.ExecuteDatasetQuery(<groupId>, <datasetId>, <dax query>).
    See this other answer for more: Issues with PowerBI connector in PowerApps