web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps How do I connect a Pow...

Power Apps

Suggested Answer

How do I connect a Power BI Dataset to Power Apps using ExecuteDataSetQuery function?

(1) Share

Report

Report

Posted on by badgerfifteen

25

I've discovered something when connecting a Power BI dataset to Power Apps and it is the ExecuteDataSetQuery function. I'm a little confused on how to use it and pull data from a table I have in a Power BI report. I get what I have to do for the first two but I'm not sure what to do for the last parts where it asks for a query and a pbi_source field. I'm not really interested in using Power Automate for this if the functionality is already there in Power Apps. Any ideas?

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

venturemavenwill 1,193 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
pbi_source is optional and don't need to be entered.

Here is an example PowerFx formula. Essentially you need to write PowerQuery, which will then be performed on your dataset

ClearCollect(colProjectsRaw, PowerBI.ExecuteDatasetQuery( "aaaaaaaa-bbbb-cccc-dddd-1234567890ab", /*Workspace GUID*/ "bbbbbbbb-cccc-dddd-eeee-1234567890ab", /*Dataset GUID*/ "EVALUATE SELECTCOLUMNS(VALUES('Projects'), 'Projects'[ID], 'Projects'[Description], 'Projects'[Project_Manager]) ORDER BY 'Projects'[ID] DESC" ).firstTableRows );

Credit: Stackoverflow https://stackoverflow.com/questions/73472958/issues-with-powerbi-connector-in-powerapps

Hope this gives you an idea on how to structure your own query.

Was this reply helpful? Yes No

Join the conversation