Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

New Member

Help with API Security PBIRS

Is there a way to disable users from connecting to the SOAP or REST api on PBIRS May2022? I have several users that loop through reports running them and flooding the DB servers with queries causing resource issues. 

Super User
Super User

There is no separate API security. If you can run a report from the web portal you can run it using the API. In fact the whole web portal is built on top of the APIs so if you blocked access to them the web portal would not work. 


So you will probably need to start a discussion with these users. If they have a genuine business need then there might be a better way of extracting the data they are after. Or you may be able to organize a better time for them to run their reports.


Worst case, ,if they refuse to listen you could just revoke their access entirely... but in my experience I've never had to go that far. It's usually possible to find some middle ground. Usually the users are just trying to get their job done and did not realise the impact they were having. Maybe getting the users to talk to the DBAs would help - I've had DBAs who were happy to schedule extracts for users outside of busy times. Then everyone was happy.

Helpful resources


Fabric certifications survey

Certification feedback opportunity for the community.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors