A solution for query string parameters in public reports

[IsmaelMM]

I created this simple visual that allows passing filters through the URL in Publish to web reports.

For example:

https://app.powerbi.com/view?r=XXXX&column1 Is 5&column2 In ('A', 'B')

Applies the following filter to the data model:

columna1 = 5 and columna2 IN ('A', 'B')

It has some limitations, like all objects have to be loaded first showing all data, but that is due to limitations of how the pbi service works. Or that it only allows one filter/condition per column, which I plan to improve in future versions, but I think it could be useful for many users.

Here is the GitHub repository with more details in case you want to use it.

https://github.com/orihuela-iom/powerbi-public-query-parameters

[philipe125]

I loved your solution, although it's important to consider that if you change the default page in the URL, this plugin won't work. 

Example:

It works: 

view?r=xxx&column1 Is 1

It doesn't work:

view?r=xxx&pageName=yyy&column1 Is 1

[v-prasare · Accepted solution]

@IsmaelMM , Being able to apply filters through the URL can be useful for users who want to share customized views without modifying reports manually. 

I’d encourage you to submit your detailed feedback and ideas via Microsoft's official feedback channels, such as the Microsoft Fabric Ideas. Feedback submitted here is often reviewed by the product teams and can lead ...

Thanks,

Prashanth Are

MS Fabric community support

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query