Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
We have developed a solution where we download admin/usage data on a daily basis, import this into SQL Server. We have also developed a report based on this data.
Recently, I have been trying to add user information to work spaces, reports, datasets et cetera. The 1st 2 went well (just now anyway). Each power shell script, loads say the reports, loops through these and calls the admin API method to retrieve the users for each report.
It was only when I tried to do the datasets, that we started hitting the 200/hour limit.
Now when extracting workspaces, you can add the parameters "expand =users" to give us the users information. However, this parameter does not work for reports, datasets et cetera.
Is there any other way to retrieve report users, app users et cetera?
Thanks
To my surprise, the limit of 200 per hour for GetAppUsersAsAdmin, is not blocking my API calls. I ran the call for 380 apps 5 times in a row and it returned all users without an error. Strange but nice.
I have a similar problem.
I don´t know if this will create more problems than it solves but I just added a
"Start-Sleep -seconds 36" to the end of my foreach powershell loop.
This way I´ll slow down the script and hopefully make sure that I don´t go over the limit. The run will take a long time for sure, but if that is not a problem then this might work.
EDIT: I just realized that I could go a lot faster that 36 seconds, I´think I´ll do 20 seconds just to be on the safe side.
Hello
We discovered, on the Internet, a solution which uses the scanner API (https://github.com/RuiRomano/pbimonitor).
The report uses json files as the data source. I am trying to change that, so that we persist the data in a SQL database.
Thanks
Hi @Dragon496 ,
Please check whether the following REST APIs are what you want.
1. Get app users
Admin - Apps GetAppUsersAsAdmin
2. Get report users
Admin - Reports GetReportUsersAsAdmin
Best Regards
No, this does not help me. These methods have a limit of 200 calls per hour, which was the issue detailed in my original message
Hi @Dragon496 ,
Based on my research, I didn't find any other APIs or other better ways to export user information without any limitations.
Best Regards