Events
Get certified in Microsoft Fabric—for free!
Nov 19, 11 PM - Dec 10, 11 PM
For a limited time, the Microsoft Fabric Community team is offering free DP-600 exam vouchers.
Prepare nowThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
If you are a Power BI administrator, you might want to track who is connecting to your organization's Power BI data from Excel to ensure there's no unauthorized access to the data. The Power BI activity logs allows you to monitor the usage of Power BI semantic models and improve your organization's data governance or meet regulatory compliance requirements (where applicable).
To identify users connecting to Power BI semantic models from Excel desktop or Excel for the web, do the following steps.
Open PowerShell.
Run the Get-PowerBIActivityEvent cmdlet to download event data for the AnalyzedByExternalApplication activity. The AnalyzedByExternalApplication activity identifies users who interact with semantic models published to the Power BI service from an external application. Here's a sample cmdlet for a day's activity data:
Get-PowerBIActivityEvent - StartDateTime '2022-03-15T00:00:00' -EndDateTime '2022-03-15T23:59:59' -ActivityType 'AnalyzedByExternalApplication'
Events
Get certified in Microsoft Fabric—for free!
Nov 19, 11 PM - Dec 10, 11 PM
For a limited time, the Microsoft Fabric Community team is offering free DP-600 exam vouchers.
Prepare nowTraining
Module
Transcend data analysis together with Power BI and Excel - Training
This module introduces potential ways that people can use Excel and Power BI together. Power BI is a great tool for telling a story through visuals; occasionally, it's beneficial to use Excel for analysis. Excel can make a connection to a Power BI dataset, enabling you to analyze the data by using PivotTables.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.