Forum Discussion
Helper IAuto attendant and Call queue historical reports - Version 3.2
Hi SeanMoody
Regarding the RLS mapping table:
This is a table that needs to be connected to your data models.
The model itself should be structured accordingly — for example, there should be an Employees table that is linked to the Sales table through some key.
I'm attaching a link to a tutorial video about RLS.
I believe it will help clarify things for youhttps://www.youtube.com/watch?v=jphj40tBPD8&t=3s
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hi SeanMoody,
Thank you for your follow-up.
Please find below the links to the documents that will assist in resolving the issue:
Use the Microsoft Graph API to work with Microsoft Teams - Microsoft Graph v1.0 | Microsoft Learn
Get started with the Microsoft Graph PowerShell SDK | Microsoft Learn
Microsoft Graph permissions reference - Microsoft Graph | Microsoft LearnIf you find our response helpful, kindly consider marking it as the accepted solution. This will benefit other members of the community who may have similar queries.
Should you have any further questions, please feel free to reach out to the Microsoft Fabric community.
Thank you.
Community SupportHi SeanMoody,
Thank you for your follow-up.
-
To link the Mapping Table to multiple Report Tables, please create a user-to-queue mapping table (UserEmail → QueueID). Subsequently, establish relationships between this mapping table and all relevant tables in your model that contain QueueID or similar fields. This will ensure that filters from Row-Level Security (RLS) are applied automatically across all visuals.
-
To keep the Mapping Table updated with any changes in Teams queue assignments, you may either maintain it manually if changes are infrequent, or automate the process by using Microsoft Graph API to extract the current queue-user assignments.
If you find our response helpful, we kindly request you to mark it as the accepted solution. This will greatly assist other members of the community who may be facing similar queries.
Should you have any further questions, please feel free to reach out to the Microsoft Fabric community.
Thank you.
SeanMoodyDo you have any documentation or video example of how you would use Microsoft Graph API to extract the current queue-user assignments to a Power BI Table?