Unanswered

Hi, Howe can i get the Json from Power BI

(0) Share

Report

Posted on by Ameer1

Hi,

How can i enter the value field with Json from the Power Bi Fields. I need to choose two fields from the query, which ae Norms and Code. Can you please help me?

When i tried to choose from the dropdown menu it gives me another loop, so How can i do it?

Thank you

Categories:

Using connectors

I have the same question (0)

All responses (13)

Answers (1)

Sundeep_Malik 6,484 on at

Like (0)

Report
Hey @Ameer1

Not sure this technique would work with Power BI or not, but this is how I usually deal with JSON data in Power Automate. Follow the following steps:

Save that dynamic field Power BI data in a compose action, though variable would also work.
Run the flow once.
After this copy the output you are getting in that compose from the run history.
After this edit the flow, and add new action called parse json.
In parse json, pass the output of above compose, and in the dynamic content paste the data you copied before. And click on done.
After this your dynamic fields Norms and Code would be available. You can use them in however way you like.
You can watch the following videos to get more information:

https://www.youtube.com/watch?v=vhkPrm64hMk

https://www.youtube.com/watch?v=jg--Ivo9oRE

If this solution works for you, you can mark it as the solution. And if you liked the explanation, you can give a thumbs up/kudo. It really helps. Thanks. 🙂

Was this reply helpful? Yes No
Ameer1 20 on at

Like (0)

Report

Hi Sundeep,
Thank you.
But the Json format is not available. may be i can elaborate the details of my query.
Export Power BI to MS Word / PDF | Paginated reports with Power Automate and Power BI - YouTube

I was following this video and at the minute 7:00, The value field is a Json, She copied it from somewhere. I have problem in this step.

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

@Ameer1

I think currently you are sending everything from Power BI to Power Automate.

You will have to first choose the fields you want to send to Power Automate, you will have to tick the values, that you want to send to Power Automate, or if you have to send everything, select everything. Then you can make the json structure that the person has done in the above video. Its pretty easy to make.

So lets say you have 3 fields: name, id and address. Just write it as like this:

{
"Name": SelectDynamicFieldForName,
"Id": SelectDynamicFieldForID,
"Address": SelectDynamicFieldForAddress
}

Watch the following video for more reference, how you can select values from Power BI to pass to Power Automate:

https://www.youtube.com/watch?v=qG01WDm5_Go

Was this reply helpful? Yes No
Ameer1 20 on at

Like (0)

Report

@Sundeep_Malik

I wanted to take two fields from Power BI.
I followed the format you sent (
{
"Name": SelectDynamicFieldForName,
"Id": SelectDynamicFieldForID,
"Address": SelectDynamicFieldForAddress
}
But when i select the every option i click, it automatically add an other loop(apply to each).
I think there is some small error, which i don't get it.

Thank you.

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

@Ameer1

Ok. Got it what she did in the video. Actually she might have directly copied the dynamic field values. But, I won't suggest the technique that she has used in the video.
Instead do this:

Initialize an empty array variable, don't add the Power BI Data dynamic field. Keep the value empty.

Then add an apply to each action, pass the Power BI Data dynamic field in that. Then use append to each variable. And pass each column in that while creating that JSON format.

There is one more technique, if this does not work, I will tell you that.

Was this reply helpful? Yes No
Ameer1 20 on at

Like (0)

Report

@Sundeep_Malik
What's the other method? Didn't get that either. May be i could try the other way or the way she did.
Thank you

Was this reply helpful? Yes No
Verified answer

Sundeep_Malik 6,484 on at

Like (1)

Report

Both Methods:

1) Variable one:

Initialize empty array variable like this:

And after this add apply to each and append to array action and make json data like below:

2) Select action:

Do, something like below. On the right side, add item()['FieldName'] or item().FieldName or item()?FieldName.
Whichever works for you.

If the above two methods dont work, I dont think I can help you any further.

Was this reply helpful? Yes No
Ameer1 20 on at

Like (1)

Report

@Sundeep_Malik

It works Finally! Thank you very much.

Is there any way we can make a loop in power automate. I have many order codes and i want to make a file for every order code. So i would have to assign a loop function to the order code before generating the documents. is it possible?

Thanks

Was this reply helpful? Yes No
Sundeep_Malik 6,484 on at

Like (0)

Report

@Ameer1

Which method worked, variable or select one??

There are two loops in power automate.

Apply to each, which works like a for each loop.

And

Do Until

You can use apply to each for your case.

Was this reply helpful? Yes No

Ameer1

20 on at

Like (0)

Report

The first method (Variable) worked!

For example, for two order code, I have data like this. Apply to each function before the generate document function would work? How would the apply to each function go to the next order code after generating the document?

Thanks

Order code	Model	Code	Rev	Desription	Directive	Norms
158SW	BS LED	1014567	A	MW 4000K	4	CEI EN 605
158SW	BS LED	1014567	A	MW 4000K	2	CEI EN 605, 2009/125/C, CEI EN 605, CEI EN 605, CEI EN 605, 2009/125/C
158SW	BS LED	1014567	A	MW 4000K	36	EN 62471, 874/2012/C, 2014/30/EU, 2014/35/EU, EN 62471, 874/2012/C, 2014/30/EU, 2014/35/EU
40160DL	SanificaAria	1014566	A	U19C90 D3K UV	2	CEI EN 605, 2009/125/C, CEI EN 605, CEI EN 605, CEI EN 605, 2009/125/C
40160DL	SanificaAria	1014566	A	U19C90 D3K UV	36	EN 62471, 874/2012/C, 2014/30/EU, 2014/35/EU, EN 62471, 874/2012/C, 2014/30/EU, 2014/35/EU
40160DL	SanificaAria	1014566	A	U19C90 DLK UV	54	ISO 15714, EN 60335-2