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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
gauravg3
Helper I
Helper I

Apply filter to report and publish to Sharepoint

Hi All,

Need an assistance here.

I have a report that has got multiple filters (Date, Department, Sales, etc.)

Now I want to filter the report for few critical Departments for each month, and need these filtered reports to be uploaded to the Sharepoint Site (not manually).

Can someone please provide guidance on how this can be achieved. I've checked few previous forums here, but couldn't get much out of it.

Thanks

3 REPLIES 3
v-chenwuz-msft
Community Support
Community Support

Hi @gauravg3 ,

 

It seems that you can  Embed a report web part in SharePoint Online .But you cannot apply a filter unless it is applied in the original report.

 

The RLS is created in desktop, which is what you create when you build the model. How to create rls you can refer to this article.

Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

By the way, RLS works well in embed report on sharepoint website.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

davehus
Memorable Member
Memorable Member

Hi @gauravg3 , I'm assuming you are uploading a powerbi desktop file? If so, this might be difficult to achieve. You might be able to do something with Power Automate Desktop. Aside from that you would need to upload the file to PBI service and set filters through paramaters and Row Level Security.

Yes, I'm uploading the file to Power BI Service...Can you pls share any example of how its done using parameters and RLS. Thanks

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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