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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors