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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
mmbabu86
Regular Visitor

Office 365 Content Pack

Hi,

 

I have a requiremnet office 365 content pack adoption with power BI reports to create for 2 different email domain users under same tenancy.

 

ex : user1@sgpool.com  ,user2@stc.com.

 

here , 2 different users can see  power bi reports only those domain users data. I have downloaded office 365 content pack into power bi desktop with Office365 Adoption_PublicPreview05222017.pbit template.  

 

Now, I have seen few tables here. I can create Role based filters in power bi desktop. but Tenancylevelproduct usage , tenncy level product activity ect tables are not using either department or company or user. so I am not able to fileter data for 2 different roles.

 

1. can you please suggest me how to fileter these tanancy level data in the dataset with either department or email or company??

 

2. Only Userstate , useractity table i can fileter usign roles either department or company.  but these tables has data only last previous month. not more that that months data showing in the dataset so , how i can show reprots for different months using user state , useractivity. 

 

As its office 365 content pack, entire database is not available, only datase with few tables only available. with these limited tables and control, how i can create reports to filter 2 different users????

 

 

please help me these 2 issues  as i am really fedup with explore. Thanks in advance. Hope any guys can help me with clear details.Thanks a lott....

1 ACCEPTED SOLUTION
Anonymous
Not applicable

HI @mmbabu86,

 

I think below links will be suitable for your scenario(RLS with external guest) :

How to get Power BI RLS to work with external users

Distribute Power BI content to external guest users with Azure AD B2B

 

Regards,

Xiaoxin Sheng

View solution in original post

1 REPLY 1
Anonymous
Not applicable

HI @mmbabu86,

 

I think below links will be suitable for your scenario(RLS with external guest) :

How to get Power BI RLS to work with external users

Distribute Power BI content to external guest users with Azure AD B2B

 

Regards,

Xiaoxin Sheng

Helpful resources

Announcements
June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.