topic Re: Advanced solution ideas please?? in Developer

Advanced solution ideas please??

RDansereau — Fri, 08 Mar 2024 15:52:19 GMT

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:

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.
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.

Re: Advanced solution ideas please??

lbendlin — Fri, 08 Mar 2024 22:58:21 GMT

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

Re: Advanced solution ideas please??

RDansereau — Mon, 11 Mar 2024 17:09:37 GMT

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?

Re: Advanced solution ideas please??

lbendlin — Mon, 11 Mar 2024 17:28:31 GMT

URL filters work with regular reports as well.

Re: Advanced solution ideas please??

RDansereau — Thu, 14 Mar 2024 12:12:38 GMT

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?

Re: Advanced solution ideas please??

lbendlin — Thu, 14 Mar 2024 12:53:00 GMT

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

Re: Advanced solution ideas please??

RDansereau — Thu, 14 Mar 2024 13:02:15 GMT

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.

Re: Advanced solution ideas please??

lbendlin — Thu, 14 Mar 2024 13:29:20 GMT

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

Re: Advanced solution ideas please??

RDansereau — Thu, 14 Mar 2024 13:35:24 GMT

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.

Re: Advanced solution ideas please??

lbendlin — Thu, 14 Mar 2024 14:06:39 GMT

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.

Re: Advanced solution ideas please??

RDansereau — Thu, 14 Mar 2024 14:09:30 GMT

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!!