Push (publish) each table (or tables) to a driver so a driver knows whom to pick up for the day.

[youngivyacademy]

I used Power Query to create a master table then I used Power Pivot to generate different "Pickup" tables according to different schools. These tables are monthly based.

My goal is to push (publish) each table (or tables) to a driver, so a driver knows which school(s), what time, and whom to pick up for the day:

1. Use Power BI to push (publish) different tables to different drivers.
2. The value (1) means this child needs to be picked up, while a blank means no pickup for that day.
3. Push (publish) those names with value (=1) for the day only, so the driver can see whom to pick up only for that particular day (not a whole month).
4. Each driver can see which students to pick up for the day (though they may refresh to see the updates)

I am new to Power BI though I Know how to use Power Query and Power Pivot to some extent. I hope someone can guide me to achieve this goal via Zoom. I am more than happy to pay (if this is appropriate). Any other better solutions/help are more than welcome too. You may reach me at jycccwjc@gmail.com.

Sample file: https://www.dropbox.com/s/n0ftgioh9huc85i/Tuition_August_20220819_Testing.xlsx?dl=0

Thanks!

Jim

Thanks!

[v-jianboli-msft · Accepted solution]

Hi @youngivyacademy ,

According to my knowledge, you can achieve your goal by using RLS and Email Subscriptions.

Subscribe to reports and dashboards that matter most to you, and Power BI will email a snapshot to your inbox. You tell Power BI how often you want to receive the emails: daily, weekly, or when the data refresh. You can even set a specific time for Power BI to send the emails or have it run now. Set up to 24 subscriptions per report or dashboard, and provide unique recipients, times, and frequencies for each subscription.

Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles. In the Power BI service, members of a workspace have access to datasets in the workspace. RLS doesn't restrict this data access.

For more details, please refer to:

Email subscriptions for reports and dashboards in the Power BI service - Power BI | Microsoft Docs

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

Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Docs

Best Regards,

Jianbo Li

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