Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hello everyone,
I am working on a modeling tool that also has web endpoints to extract modeled data. This data then is imported in PowerBI to create custom analytics.
There also is an embedding of said tool to embed in SharePoint (among other things).
It would be nice to be able to click on an element in the embedded model and PowerBI sets its filters accordingly (for example the report includes a map, and if I click on a given nation, the report only shows sales in that nation).
My question now is, is there any way to communicate with an embedded PowerBI in any way? Maybe push some id to it or anything.
Thank you in advance
What you're talking about sounds like crossfiltering (clicking something in a map filtering something else), which the SharePoint embed supports as long as it's on a single report page. You get the full report functionality in the embeds. I have NOT had luck putting URL parameters in the hyperlink and using those in the web part, though. You can definitely put URL parameters in to filter in the web (e.g. ?&country=sweden), but IIRC I think those give an invalid hyperlink error in the SharePoint web part.