Is it possible to pre-filter Power BI Add-In live data in Power Point using URL Query String?

[blaj]

Hello!

I am trying to create a dozen pre-filtered Power Point slides for different customers using just one Power BI Report through Power BI add-in embed with live data.

The challenge I am facing is that I want to accomplish this without row-level security, just prefiltered data. The result is that each client can go into their Power Point and see the live power bi data for their business, but without using dynamic RLS. 

I cannot use Power Automate becuase I need to use a different Power Point design for each customer. So the Power Point will reside on SharePoint, and will be accessed by the customer every month with the Power BI report visual add-in which automatically updates the data.

I tried embedding in Power Point using the URL query string filter, and it did not flter it. The code does work in the web browser, so it's not the code.

Thanks!

[blaj]

@lbendlin is there any way in power automate to export power point slides and insert them into an existing power point file with an existing design?

[blaj]

Thank you.

[Anonymous]

Thanks for the reply from lbendlin.

Hi @blaj, 

Have you solved your problem? If so, can you mark the helpful answer as solution to help other members find it faster? Thank you very much for your kind cooperation!

Best Regards,
Zhu

[lbendlin]

Not aware of any free options.  Paid options are available, for example Populating PowerPoint presentation using Power Automate — Plumsail Documents Documentation

(no endorsement)

[lbendlin]

You can chose to embed with filters. 

Warning: Without RLS or other restrictions your customers can choose to change those filters and see each other's data.

[blaj]

@lbendlin exactly what I'm trying to avoid. 

[lbendlin]

Separate Reports is your only option in that case.