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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
cpooja
New Member

How to distribute 200 customers to 200 different customers using power bi report

Hi All,

 

I am using one view from Azure Synapse data source which is showing 200 different customers from Customer column.

I have created one power bi report with all the customers till current data and apply RLS for each SDMs to view their specific customer data and publish the report in power bi service.

When the SDM will review their specific customer report and the data is fine then they want to click on one button which will redirect or refresh the report/dataset for that specific customer with current month -1 data which can be reviewed by end users.

How can we implement the above task from one power bi report using power automate/power apps to pass filters(customer,current month -1) to filter the data in another power bi report.

1 ACCEPTED SOLUTION
v-rzhou-msft
Community Support
Community Support

Hi @cpooja ,

 

According to your statement, I think you can successfully configure RLS for your SDM to let them review specific customer data. Now you want your customer only to see the data with current month -1 data. 

I think this could also be achieved by RLS. You may update a new role for customer in your model.

My Sample:

vrzhoumsft_0-1721369892703.png

User table looks like as below.

vrzhoumsft_1-1721369927750.png

Role Customer is as below.

vrzhoumsft_2-1721369975703.png

[Customer Email] = USERPRINCIPALNAME()

[Date] in CALENDAR(EOMONTH(TODAY(),-2)+1, EOMONTH(TODAY(),-1))

Add customers in role in Power BI Service and then you can achieve your goal.

The result in my test is as below. 

User is SDM S1 :

vrzhoumsft_3-1721370100770.png

User is Customer C1:

vrzhoumsft_4-1721370243992.png

He can only see the data in last month.

 

Best Regards,
Rico Zhou

 

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

 

View solution in original post

3 REPLIES 3
v-rzhou-msft
Community Support
Community Support

Hi @cpooja ,

 

According to your statement, I think you can successfully configure RLS for your SDM to let them review specific customer data. Now you want your customer only to see the data with current month -1 data. 

I think this could also be achieved by RLS. You may update a new role for customer in your model.

My Sample:

vrzhoumsft_0-1721369892703.png

User table looks like as below.

vrzhoumsft_1-1721369927750.png

Role Customer is as below.

vrzhoumsft_2-1721369975703.png

[Customer Email] = USERPRINCIPALNAME()

[Date] in CALENDAR(EOMONTH(TODAY(),-2)+1, EOMONTH(TODAY(),-1))

Add customers in role in Power BI Service and then you can achieve your goal.

The result in my test is as below. 

User is SDM S1 :

vrzhoumsft_3-1721370100770.png

User is Customer C1:

vrzhoumsft_4-1721370243992.png

He can only see the data in last month.

 

Best Regards,
Rico Zhou

 

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

 

Thank you for the solution.

The date filters are showing only last one month and last 2 months data nut the customer wants to see the data till previous one month data (For example if we are in july month then the customer wants to see the data till june month)

Please help me with this.

 

Thank you for the above solution @v-rzhou-msft.

Actually the requirement is when the SDM people will review their specific report (For Example Customer A data) from All Customer Report using RLS then they will use one button to publish the report with correct data and they will pass the filters like current month -1 and current month -2 to a different report
(Please note that here the report will be different for customer A)
so that the Customer A (end user) will check the Customer A report in another workspace.

So here the challenge is RLS and date filters should be passed when the SDM (Customer A data report reviewed) will click the publish button to Customer A report.

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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

Top Solution Authors