web

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

News and Announcements icon

Power Platform CommunityForums Power Automate From query to datavers

Power Automate

Answered

From query to datavers

(0) Share

Report

Report

Posted on by Bergh

88

Hello. I would like to fetch data from Power Bi with query and add these rows to a Dataverse table. I can´t find the output from the query

Categories:

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report

Hi @Bergh,

Do you have a First table rows property? The data should be returned in that property. You can double check this in your Run a query against a dataset action outputs.

Below is an example which uses that property, in that example the output is sent via an email.

https://hatfullofdata.blog/power-automate-get-data-from-a-power-bi-dataset/

Was this reply helpful? Yes No
Bergh 88 on at

Like (0)

Report

Yes I have First table rows but I do not get any alternative. I want the "Chassinummer", "Demtime" and so on.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,195 Most Valuable Professional on at

Like (0)

Report
Hi @Bergh,

Sometimes the fields don't show up in the dynamic content list. The workaround would be to use an expression instead.

Have a look at your outputs of the Run a query against a dataset to double check which field name you need to use in your expression.

Below is an example with one of the fields in a Compose action.

The below was added via the expression editor/tab

item()['PowerBIDataset[Chassinummer]']

Test run with that expression

Happy to help out 😁

I share more #PowerAutomate and #SharePointOnline content on my Blog, Bluesky profile or Youtube Channel

Was this reply helpful? Yes No
Bergh 88 on at

Like (1)

Report

Thanks!! it works just fine!!

Was this reply helpful? Yes No

Join the conversation