cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Microsoft SQL: Resource ID : 1. The request limit for the database is 30 and has been reached.

We have an Azure SQL Database which is only used for reporting information. Power BI is connected to this database and when doing a refresh I get this error: "Microsoft SQL: Resource ID : 1. The request limit for the database is 30 and has been reached."

 

I know what the error means and why it happens but is possible to refresh the datasets in another way to avoid this issue? It's a little bit of overkill to upgrade the database only for refreshing the dataset a few times a day.

 

We do import of data to PBI. Direct query is not working for us due to limitations in features.

Helpful resources

Announcements
Ignite

Microsoft Ignite

This will be a conference that you do not want to miss!

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Don't miss the Power BI Dev Camp this week!

August Community Highlights

Check out a full recap of the month!

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors
Top Kudoed Authors