The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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?
Solved! Go to Solution.
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
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
Hi @v-nokumar ,
The only way is to pass the Filter condition in the URL shown below.
Example:-
?filter=Store/Territory eq 'NC'
?filter=Store/Territory in ('NC', 'TN')
?filter=Store/Territory eq 'NC' and Store/Chain eq 'Fashions Direct'
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