Power Platform Community Forum Thread Details

I’m currently building a power Bi dashboard where I will showcase the auditor groups in the dashboard.
I have to match azure logs and another cloud platform saviynt logs but i have a similar column account I’d. When I try to search the account I’d from azure in saviynt I get the same duplicate entitlements with same accounts. Every data is same. I’m confused about the matching the logs and show it in dashboard. Can you give a solution for it?

IMG_5916.jpeg

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Building flows

@CU21011631-1 Try
1. Load the Azure and Saviynt logs into Power BI as separate queries (using Power Query or importing via a data source).
Make sure both datasets are loaded in Power Query Editor. You can name them like AzureLogs and SaviyntLogs , also Look at sample data in each and confirm that AccountID exists in both and is in the same format.
2. From both datasources cleanup the data, like remove unwanted metadata, Convert AccountID to lowercase/uppercase consistently, Remove unwanted columns
SaviyntCleaned = Table.Distinct(SaviyntLogs, {"AccountID", "Entitlement"})
3. Join Datasets on AccountID
MergedLogs = Table.NestedJoin(AzureLogs, {"AccountID"}, SaviyntCleaned, {"AccountID"}, "SaviyntData", JoinKind.LeftOuter)
4. Normalize and Shape for Dashboard-
Once merged: Flatten nested data, Create calculated columns for dashboard visuals and You may want to create a distinct list of entitlements per user.
Entitlements = CONCATENATEX(VALUES(SaviyntCleaned[Entitlement]), SaviyntCleaned[Entitlement], ", ")
5. Build Dashboard Visuals:
Use a table or matrix:
Rows: AccountID
Values: Entitlements (or list from merged table)