Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
v-nokumar
Employee
Employee

How to export power BI report to ppt with applied filters using .net blazor

Hi Power BI service Team,

I am exporting power BI report to pptx using power BI API. But, now I have to export with applied filters and to do this I need to know what is filtered and so I can pass the filter parmeters to export. 
I can see, in microsoft itself given one parameter to send reportlevel filter like below in link-

https://learn.microsoft.com/en-us/power-bi/developer/embedded/export-to

 

But to pass value in it, from where I can get need to know.

So, Could you please help me if there any API or any other solution?

1 ACCEPTED SOLUTION
v-nokumar
Employee
Employee

I got the solution for this

I have used JavaScript API to capture bookmark and get filters and based on that I am able to export with applied filters into PPTX.

Thanks

 

View solution in original post

3 REPLIES 3
v-nokumar
Employee
Employee

I got the solution for this

I have used JavaScript API to capture bookmark and get filters and based on that I am able to export with applied filters into PPTX.

Thanks

 

mohitkumawat
Super User
Super User

Hi @v-nokumar ,

The only way is to pass the Filter condition in the URL shown below. 

mohitkumawat_0-1715152992667.png

Example:-

?filter=Store/Territory eq 'NC'

?filter=Store/Territory in ('NC', 'TN')

?filter=Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct'

 

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#considerations-and-...

Hi @mohitkumawat ,

I have checked I want to know from where I can get these values which is given in example:-

?filter=Store/Territory eq 'NC'

?filter=Store/Territory in ('NC', 'TN')

?filter=Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct'

I need these value as runtime because user can filter anything in report and there need to know about values
So, Is there any other thing where I can get filtered values?

Thanks

 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors