cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HermannRafn Frequent Visitor
Frequent Visitor

Microsoft Teams ID in Power Bi

Hi All, we have a project which consists of number of Teams and one Power Bi report serving all teams. The PowerBi report is embedded into each Teams tab and need to filter to that specific Team. Since some users will be members of more than one team we cannot use the User Id/Role to filter by. I know I can filter the report on Teams Id if using web/url approach (url filter) but need to have this solved when the Power Bi model is embedded in Teams. Any ideas??

1 ACCEPTED SOLUTION

Accepted Solutions
HermannRafn Frequent Visitor
Frequent Visitor

Re: Microsoft Teams ID in Power Bi

@v-yuezhe-msft

ok, clear. Thanks for your reply.

 

For the record - I did find a workaround that works for me. By "embedding" the PBI-report into Teams as a Website and use url-filtering. That way I can prefilter on groups (one report for number of teams) plus when adding "chromeless=1" it opens up as it would when embedded as PBI -that did it for me.

 

Regards,

H

13 REPLIES 13
Moderator v-yuezhe-msft
Moderator

Re: Microsoft Teams ID in Power Bi

@HermannRafn,

Query string filtering in URL does not work with Publish to web or Power BI Embedded. In your scenario, the method I can think of is to create different reports for each team, and you can add a report level filter in each report for each team, then embed these reports in different team tab.



Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HermannRafn Frequent Visitor
Frequent Visitor

Re: Microsoft Teams ID in Power Bi

Hi Lydia and thanks for your reply. Your suggestion means I would need to maintain 20-30 identical models. I was hoping for a solution/work around where I could use the Teams/Workspace Id to filter by.

Moderator v-yuezhe-msft
Moderator

Re: Microsoft Teams ID in Power Bi

@HermannRafn,

If you need to embed the report intp Application, you would need to create different Power BI reports.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HermannRafn Frequent Visitor
Frequent Visitor

Re: Microsoft Teams ID in Power Bi

@v-yuezhe-msft

 

So are you basically telling me it's not possible to pass filters into embedded reports? ..not even between two native Microsoft applications?

 

So far these are my findings:

:: If I embed the report as a website into Teams - I can use url-filtering to get the result I'm after (pre-filtered) - but this is not really embedding Smiley Happy

:: If I try to do this via SharePoint (embed the report into SP-page and from there into Teams) - paste the url (including filtering) for the report into SP -> it ignores the url-filters and displays the report unfiltered?

 

 

Regards,

Hermann

Moderator v-yuezhe-msft
Moderator

Re: Microsoft Teams ID in Power Bi

@HermannRafn,

Query string filtering in URL does not work with Publish to web or Power BI Embedded. See https://docs.microsoft.com/en-us/power-bi/service-url-filters.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HermannRafn Frequent Visitor
Frequent Visitor

Re: Microsoft Teams ID in Power Bi

@v-yuezhe-msft

I know this .. but my question remains the same, when embedding PowerBi into teams or SP - is there no way to pass filters/pre-filter?

 

Regards,

Hermann

Moderator v-yuezhe-msft
Moderator

Re: Microsoft Teams ID in Power Bi

@HermannRafn,

The method is to use report level filter. It is not possible to add filter in the embed link.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
HermannRafn Frequent Visitor
Frequent Visitor

Re: Microsoft Teams ID in Power Bi

@v-yuezhe-msft

ok, clear. Thanks for your reply.

 

For the record - I did find a workaround that works for me. By "embedding" the PBI-report into Teams as a Website and use url-filtering. That way I can prefilter on groups (one report for number of teams) plus when adding "chromeless=1" it opens up as it would when embedded as PBI -that did it for me.

 

Regards,

H

mgartner Frequent Visitor
Frequent Visitor

Re: Microsoft Teams ID in Power Bi

Hi there!

 

I am experiencing the same issue as you were, and I was curious to know how you embedded and used url-filtering to get the report you wanted. Any help or links to resources would be greatly appreciated!