save reports filters where the reports are embedded inside a SAAS app using iFrame and url parameter

We are looking to be able to save reports filters where the reports are embedded inside a SAAS app using iFrame and url parameters.

 

2 12 355
12 REPLIES 12

Same here, we didn't find a way. Looks like the support for webhooks would be the way to go but for now it is only available in Looker, not Studio.

I hope I understood this correctly, @LeadCenterAI @remy_david your looking for to show the reports created in LookerStudio in a SAAS platform? are you showing the entire page or specific visualization?
On top of this you need to use the filtering capability which is coming with the lookerstudio to filter the results. Finally you want save the filtered results to same SAAS platform?

Yes, my SaaS app is showing a whole Looker Studio page at a time. My SaaS app needs to update its UI based on the values selected by the users in the embedded Looker Studio filters. In particular, we would like to be able to save the state of the Looker Studio, to be able to display the same state (when resuming the session, bookmarking, sharing the url, etc.). Only webhooks would allow this AFAIK since the parent page does not have access to the iframe url/content. 

@remy_david where you able to explore creating a Custom Filtering Layer? 
It seems if you create your own filtering UI outside the iframe that controls what gets loaded might help to solve this challenge.

My proposal is to build a custom filtering interface in your SaaS app (above the iframe) , then store filter states in your application's database. When filters change, reload the iframe with updated URL parameters, additionally allow users to save named filter configurations
Hope it helps! please let me know!

That's an option we are considering, but:

1/ the injection of filter parameter is not an official/supported feature. There is no documentation about it, although it is quite easy to retro engineer. My concern is since it is not official/documented, Google may change the implementation which would break our app, there may also be subtleties like special characters etc. which may break things.  

2/ reloading the iframe everytime a filter change in the app UI would cause a white screen to appear briefly, leading to a lot of flickering of the UI. The UX would not be good, whereas changing the filters inside the Looker is nicely managed with selective and progressive loading of impacted components etc.  

okay got it. Those are valid concerns.

Hope you have explored Looker Studio Parameters?
I'm not sure this might help with your filtering use case.

Hello;

The reports are embedded in our SAAS app like the example below. Users use
the filter on top to filter those reports. There is no way to save the
filtered report in the embedded report to revisit later. Each time the user
reloads the page, has to filter the report again. They want the ability to
save the filtered view and then select the saved filtered view from a drop
down.
[image: Screenshot 2025-04-07 at 10.26.49 AM.png]

(PII Removed by Staff)



*AI-Powered CRM for Financial Advisors*


*See LeadCenter's Powerful CRM Reporting Featured in (PII Removed by Staff)*
<>
[image: kitces logo]
<>
[image: facebook]

@LeadCenterAI Not able to see the example images/screenshots. Could you please try to insert the images using the camera icon on the comment box?

 

 

Here is an example

Screenshot 2025-04-09 at 4.44.49 PM.png

Here is a detailed view:

 

Here is a more detailed view. Users will filter the report inside the iFrame. They want to be able to save this filtered view to use it later. We can't build the filters in our App. first it is more than 60 reports with extensive filters. So ideally if there is away to pass the filtered view from inside the iFrame to our app to save the filtered view.

Screenshot 2025-04-09 at 4.48.45 PM.png

Thanks @LeadCenterAI for sharing the detailed view. I'm able to see the images now. 
It is impressive that you have created these many reports with extensive filters. Just to be in the same page; Are you creating the reports and filters in LookerStudio and embedding those reports in your app using iframe? 
You are not implemented any interaction with the report from your app?
As I'm referring the top navigation(Appointment Performance Reports>>....), does that also part of your iframe?
Because I just want to know the front-end implementation you have followed.
could you please provide more details?. Hope I can contribute some direction here!

Hello Muahsin;

The only interaction between our system and the report is authorization throw token. We built our own connector to be able to use the Looker Reports in our app using iFrame. The data is transferred to Big Query every fifteen minutes. Then a Looker fetch the data inside the iframe based on a tokenized url produced based in the tenant id in our system. Here is the page that user visit to click on any report to open it and it loads it within the iframe. 

Screenshot 2025-04-11 at 7.41.34 AM.png