This is best Fabric, Power BI, SQL and AI community event. How do we know? The last event sold out! Save €200 with code FABCMTY200.
Register nowThe Fabric community is upgrading! Read all of the details including the timeline and what you can expect. Learn more
Hello,
I'm thinking of using powershell to create the users activity reports via REST API. Does that mean I have to be the admin in power shell?
I'm admin in PBI, but not in powershell.
Thanks.
Solved! Go to Solution.
Hi @ROG ,
REST APIs with PowerShell provides great flexibility in the automation. You don’t need to bother about app registration and access token generation, considering it is a bit hard and a big process. Power BI provides PowerShell cmdlets to directly call Power BI REST APIs. You have options to select activities by activity type or user ID. You must specify a start date and end date. Check out Get-PowerBIActivityEvent cmdlet for sample code and other information.
Note: You must either be a global admin or a Power BI service admin to access the Power BI activity log.
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @ROG ,
REST APIs with PowerShell provides great flexibility in the automation. You don’t need to bother about app registration and access token generation, considering it is a bit hard and a big process. Power BI provides PowerShell cmdlets to directly call Power BI REST APIs. You have options to select activities by activity type or user ID. You must specify a start date and end date. Check out Get-PowerBIActivityEvent cmdlet for sample code and other information.
Note: You must either be a global admin or a Power BI service admin to access the Power BI activity log.
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
| User | Count |
|---|---|
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |