Paul on 20 Jul 2016 22:02:01
Scenario: We have a website with Power BI embedded analytics and details provided by SSRS reports. On the top you could see the parameters for the reports (multiple value, single value, all). It would be great if we could pass (securely) parameters to power bi embedded so that the datasource only shows certain data. Imagine that I would have to share this dataset for several customers and I want to filter data by customer instead of creating one datasource for each of them.
Thanks!
- Comments (23)
RE: Allow to pass parameters to an iframe for Power BI Embedded
As a developer embedding Power BI is a frustrating product to use because it lacks these basic features. If you are trying to support realtime data you can't load all the data to the OLAP cube and then write a bunch of complex MQuery. You really just need to pass a parameter from the web app and inject it into the query of the report.
RE: Allow to pass parameters to an iframe for Power BI Embedded
I have an active use case for this functionality right now, which may be the decision maker about whether we purchase an embedded SKU.
RE: Allow to pass parameters to an iframe for Power BI Embedded
I was just looking for this, it would make multi tenancy support so easy, just the same report for every customer and you would just pass the datasource parameter through the embedding API...Sadly, it doesn't seem a supported usecase.
RE: Allow to pass parameters to an iframe for Power BI Embedded
Here (https://ideas.powerbi.com/ideas/idea/?ideaid=c4cf628e-c617-4e86-8655-56e201b4a693) people are also asking about adding parameters, but then specifically to use them with stored procedures. Maybe merge these two, to get more votes?I am flabbergasted that having the ability to set parameter values via the URL or API hasn't been implemented yet. From the application the calls to the API should be as simple as possible. I want to have the complexity of the filtering be done inside the report. The expert building the reports should take care of this, not the application developer.
RE: Allow to pass parameters to an iframe for Power BI Embedded
Bumping this end of 2022.
RE: Allow to pass parameters to an iframe for Power BI Embedded
Bumping this end of 2022.
RE: Allow to pass parameters to an iframe for Power BI Embedded
Still waiting on this, it would be good if we could pass a parameter. So we can change the database for the dataset - so we can have one report/dataset for all the databases with the same schema. We have a multi-tenant app so each customer has his own database. With current PowerBi embedded support, it is a pain in the ass since when adding a new customer we also need to create a new dataset /report so we can not automate this.
RE: Allow to pass parameters to an iframe for Power BI Embedded
It's 2021 and still no luck with implementing this?
RE: Allow to pass parameters to an iframe for Power BI Embedded
So that means I cannot pass some date values from outside the report into the embedded report that filters it out??
RE: Allow to pass parameters to an iframe for Power BI Embedded
https://powerbi.microsoft.com/en-us/blog/intro-pbi-js-api/
Hi i am using above to add filter . i have direct query.
but it not working.
my question does these filter support direct query embedded Power BI