Power Bi ExecuteDatasetQuery not working

(0) Share

Report

Posted on by SabineR

Hello,

In a PowerApps application, I'm trying to connect to a power bi dataset.

The function PowerBI.ExecuteDatasetQuery returns the correct number of rows, but rows are all empty.

How can we use this function?

What to put into the serializerSettings parameter?

Is it only working with Power Automate?

Many thanks in advance,

Sabine

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

jefmeyer 166 on at

Like (0)

Report
Copy link

Link copied!

I'm having the same results. Any luck getting this working?

Was this reply helpful? Yes No
jefmeyer 166 on at

Like (3)

Report
Copy link

Link copied!

I opened a ticket and received the following response:

The Product Group team has completed their investigation and determined that the issue you have reported is by design. The metadata for ExecuteDatasetQuery specifies that it will return an object, however it does not specify any columns or properties. As PowerApps is strongly typed, it does not parse any internal properties.

The team is actively working to add support for this functionality in the near future, however a specific timeline for its implementation is not available at this time.

Was this reply helpful? Yes No
MahenderReddy 2 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Is there any update from MS regarding this issue?

Was this reply helpful? Yes No
SergiP 118 on at

Like (1)

Report
Copy link

Link copied!
hi,
I found the solution in this topic: Issues with PowerBI Execute Dataset Query - Power Platform Community (microsoft.com)
Basically I put the result of the PowerBI.ExecuteDatasetQuery in a collection and then use the data in the collection.
It is not obvious to work with this collection because there's no way to see what's inside, but if you know the name of the tables and columns from the Dataset that you're recovering with your query then you can get the info...
Example: this code sends the query in varQuery to a Dataset and puts text returned from the first line on the Column1 from Dataset_Table2 into var_Result
Set(var_Result, Text(First(PowerBI.ExecuteDatasetQuery(WorkSpaceID, DataSetID, varQuery).firstTableRows
).Value.'DATASET_TABLE2[COLUMN1]')

Was this reply helpful? Yes No