Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Allow to pass parameters to an iframe for Power BI Embedded

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!
Status: Under Review
Comments
gowthamveera
Advocate II
any update on this ?
gilbertocrespo
Advocate I
There are something new about this great idea? I'm using the C# version (https://github.com/Microsoft/PowerBI-Developer-Samples/tree/master/App Owns Data). Does anyone knows if there are some alternative to pass this parameter?
gilbertocrespo
Advocate I
The FILTER solution may break the secutiry of my application, because i'm using the version "App owns data" and I'm using only one powerBi premium user for all of my clients. If they change the URL from browser, they would see confidencial information of other client.
som_nitjsr1
New Member
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
powerbiuser18
New Member
So that means I cannot pass some date values from outside the report into the embedded report that filters it out??
marcin_giers
New Member
It's 2021 and still no luck with implementing this?
itrosic
New Member

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.

fbcideas_migusr
New Member

Bumping this end of 2022.


fbcideas_migusr
New Member

Bumping this end of 2022.


34208
New Member

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.