Filter SharePoint PowerBI Report based on Current Logged In User Azure AD Group

%3CLINGO-SUB%20id%3D%22lingo-sub-1584798%22%20slang%3D%22en-US%22%3EFilter%20SharePoint%20PowerBI%20Report%20based%20on%20Current%20Logged%20In%20User%20Azure%20AD%20Group%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1584798%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20mates%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anybody%20give%20me%20hand%20with%20this%20%3F%20I%20want%20to%20filter%20a%20PowerBI%20report(Embedded%20in%20SharePoint%20Site)%20based%20on%20the%20logged%20in%20user's%20Azure%20AD%20Group.%20So%20when%20a%20user%20logged%20into%20the%20SharePoint%20site%20and%20lands%20on%20the%20PowerBI%20report%20page%2C%20That%20report%20should%20be%20filtered%20based%20on%20the%20Azure%20AD%20groups%20to%20which%20this%20current%20user%20belongs%20to.%20Any%20help%2Fguide%20would%20be%20really%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1584798%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Visitor

Hi mates :)

 

Can anybody give me hand with this ? I want to filter a PowerBI report(Embedded in SharePoint Site) based on the logged in user's Azure AD Group. So when a user logged into the SharePoint site and lands on the PowerBI report page, That report should be filtered based on the Azure AD groups to which this current user belongs to. Any help/guide would be really appreciated.

 

Thanks

1 Reply

@aluzaja178 

Hi , were you able to resolve this issue? i have same kind of issue, got a power BI report which reads data from Excel files stored on Share point folders, these folders are secured and using Azure AD users.

when users log into power Bi service, they still can see all data, I expected they only see data from files where they have access and not all data from other folders where they don't have access to.

in the connection to files from power BI I used Organizational Account, Privacy level, uses Organizational.