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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
john4287
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. 

1 REPLY 1
d_gosbell
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

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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