Export Power BI to MS Word / PDF | Paginated reports with Power Automate and Power BI

[Antmkjr]

 I was trying to replicate the below tutorial : https://www.youtube.com/watch?v=lqlYl3pVL1g

However , I am stuck in the below step: "Append to array variable", Time in the video : 7.05

I am unable to get the mapping as mentioned? (the circled part in the screenshot attached) Can someone help me get the json code?

Also which license is required for  implementing this flow? As mentioned in the video is it Office 365 E3 license?

I already have the same license,  but when I am clicking " Populate a Microsoft Word Template",

I am getting the below:

[v-shex-msft]

HI @Antmkjr,

Did lbendlin 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept the helpful one to help others who faced similar requirements to find it more quickly.

If these also not help, please share more detailed information to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,
Xiaoxin Sheng

[lbendlin]

That makes little sense as you have no access to my Power Automate environment.

Don't specify the "Apply to each"  step - it will be done for you as soon as you consume the Power BI content.

[lbendlin · Accepted solution]

works for me.

[Antmkjr]

Could you attach the pbix as well

[lbendlin]

You can drag and drop your flow steps into different positions - whatever makes sense for your flow.

[Antmkjr]

I think you are not getting my question, would you be so kind to create that task in a pbix and send me screenshot, may be then you will face the same thing?

[lbendlin]

Yes, like that, but with a colon after the key name, not a comma.  Commas separate pairs of key:value.

[Antmkjr]

Even after putting colon, I am doing as below:

As shown in 3 , a new step is being created, not sure why?

[lbendlin]

In your flow you have the attributes from the previous steps available. You are supposed to create the JSON format with your key names and with the attributes. Like you show in the first picture.

{ "key name":<attribute>,

"key name":<attribute>

}

You may have to add double quotes around the attributes.

[Antmkjr]

My question is how to write the value part, does it need to be selected from the circled as shown in picture?

If yes, when I am doing so, a new step is being created like below, and not working like expected

[lbendlin]

Yes, your array is malformed.  it is expecting a list of "key":"value"  pairs separated by comma.

Export to PDF and PPT is covered by the free flow action. It's only the word template connector that is Premium.

[Antmkjr]

I understand , i dont know what should be written after comma..would you be so kind to explain further?