Recently one of my client came up with a requirement of finding out the last login date of a Power BI user and wanted it scheduled as report, The details can be found in Power BI audit log or Azure AD user sign in info. I used the AzureADPreview Module cmdlets in PowerShell to get the required details
Copyright © 2019 Vinoth N Manoharan.The information provided in this post is provided "as is" with no implied warranties or guarantees.
Recently, one of my clients requested a solution to identify the last login date of a Power BI user and have it delivered as a scheduled report. This information can be retrieved either from the Power BI audit logs or Azure AD user sign-in records. To achieve this, I leveraged the AzureADPreview module in PowerShell. Using its cmdlets allowed efficient extraction of user sign-in activity. The final output was structured into a report that could be scheduled and shared as required.
ReplyDeleteTracking user activity in Power BI using AzureADPreview and audit logs is a smart approach for monitoring last login dates and ensuring proper reporting. Automating this with PowerShell makes it easy to generate scheduled reports and keep administrators informed about user access patterns. While running scripts or reviewing audit data on a laptop or in an office setting, having a comfortable champs hoodie can make long sessions of coding or troubleshooting more cozy and focused, especially during late-night work or colder environments when reviewing logs and sign-in activities.
ReplyDeleteI always learn something new here.
ReplyDelete