How to Pass values to the Power BI Filter via API (while Generating PPTX from Power BI Report)

[spc-powerb]

Hi Team,

I am able to generate PPTX and PDF from the API but I am not able to pass the filter to the report while generating PPTX. I tried and showing all the steps below

                                                         I have Generated PPTX from the given link

https://community.powerbi.com/t5/Community-Blog/How-to-use-Power-BI-Rest-API-to-export-the-Power-BI-...

# Passing Filters while generating PPTX

Step 1 - Get the exportId

https://api.powerbi.com/v1.0/myorg/groups/56811d8e-a609-435e-853e-c813fb83b7rQ8/reports/f0b99643-194...

Step 2 - Get the Current Status If the session is successful

https://api.powerbi.com/v1.0/myorg/groups/56811d8e-a609-435e-853e-c813fb83b7b8/reports/f0b99643-194d...

Step 3 - Download PPTX

https://api.powerbi.com/v1.0/myorg/groups/56811d8e-a609-435e-853e-c813fb83b7b8/reports/f0b99643-194d...

Filter also added in power BI Report and screenshot Attched

With Regards

Bipin Kumar

[v-chenwuz-msft]

Hi @spc-powerb ,

You want to add filter on the page then export the report in format of pptx.

Maybe you can try add json in the body of this POST request. You can refer this article about REST API.

Reports - Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[spc-powerb]

Hi Team,

              I have added json in body of this post request which has given below but filter is not working

{
format: "PPTX",
filter:"FarmData/RegisteredUserId eq 122"
}

Filter also added in power BI Report and screenshot Attched

With Regards

Bipin Kumar

[NaveenMohan]

Hi Bipin Kumar,

Does the issue got resolved?. If yes can you share the solution please!.

Regards,

Naveen Mohan