Monitor usage of Power BI semantic models in Excel
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).
Identify users connected to semantic models from Excel
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'
Related content
- Create Excel workbooks with refreshable Power BI data
- Design refreshable reports in Excel with Power BI data
- Read about using Excel data types from Power BI in the Excel documentation.
- Questions? Try the Power BI Community