cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Power BI Embedding- retain slicer/filter configuration

I have an app which embeds the report by using the concept of user owns data. I want to retain the slicers/filters configuration retained by user without saving the report in my app. Is this possible? The slicer/filter configuration is retained in the service but its not reflected in the embedded report without saving.

image.png

1 REPLY 1
Highlighted
Microsoft
Microsoft

Re: Power BI Embedding- retain slicer/filter configuration

If you do not save the desired filter in the report itself, you need to store it somewhere such as a SQL database or in some other media. If the user sets fitlering in the report itself, you client-side code can get he current filter settings by calling report.getFilters. You can take that filter info and save it to a database. Then when that use logs on in a future session, you could retrive that per-user filter state and reapply it o the report.

 

Is this the type of functionality you are looking for?

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Community Summit Australia – Join Online!

Community Summit Australia – Join Online!

Be a part of the leading Microsoft Business Applications digital event, curated for the APAC community.