Advanced solution ideas please??

[RDansereau]

Hi @members,

I am looking for options on how I can possibly do the below (image), which is to have multiple slicers for users to select in the Power BI app, which will then filter the dataset that multiple reports would then run against. The user can then go to each Power BI report in the same app & download the slides with the appropriate charts/data.

The reason for wanting this is:

1. The max size of downloadable tabs from a Power BI report is 50 and our report has passed that amount, so I needed to split it into two separate reports. Instead of user needing to select same filters 2 times they can do it once.
2. If we filter by account/date prior to the report running it will run much faster as some screens timeout if run from certain countries if it is a large time-period range.

Can someone point me in a direction on what I can research to accomplish this?

Thank you so much in advance.

[lbendlin · Accepted solution]

URL filters work with regular reports as well.

[RDansereau]

Hi, If you view the image in the original question where i drew what I am looking for. I would like a screen or way for the end user to be able to select a from bunch of filters/slicers and those slicers will filter the dataset. Then the 2 current Power BI reports would then run off of the filtered dataset.

[lbendlin]

Your job is it to put fewer clicks between users and insights, not more.

[RDansereau]

Yes, agreed. That is what I am looking for solutions for and also speed since we have timeout issues. So 1 set of filters that will then filter the dataset. The reports will then authomatically be filtered since the dataset they run against has already been filtered.

[lbendlin]

Outside of Dynamic M Query parameters you don't have an option to "pre-filter"  a semantic model.  You would need to maintain separate semantic models.

[RDansereau · Accepted solution]

OK, That's unfortunate! Thank you so much for your time! I will mark the url option as a solution since that may be what I end up using.

Best Regards!!

[lbendlin]

Filter a report using query string parameters in the URL - Power BI | Microsoft Learn

[RDansereau]

Hi,

The url parameters might be viable if I can get them to pass to the app & then to each report. I am currently trying to get that to work.

Is there any way for the user to select from slicers that would then filter the dataset first before the reports run against it so we can avoid both the timeouts and having to select for both reports?  

[lbendlin]

Not clear to me what you are asking. Please elaborate.

[RDansereau]

Hi,

Thank you for your response. From what I understand these url parameters can only work with Paginated reports. I have 2 large non paginated reports with hours of work invested in them so i am not sure this option would work unfortunatly. Is there any way to modify the Dataset first before the reports run against it?

[lbendlin · Accepted solution]

URL filters work with regular reports as well.