Increase in Data Source Limit & Automation Support for Report Publishing and Instant Refresh

Hi HarshaK49 -Power BI has a default limit of 1,000 data sources per user, which might be restrictive for large projects. Unfortunately, there is no public setting or direct configuration within the Power BI service that allows users to increase this limit beyond 1,000

Data Gateway Clustering: You can split your data sources across multiple Data Gateways and use Gateway Clusters to manage more data sources.This ensures you can separate different datasets or reports across clusters to avoid hitting the limit for a single user.Consolidation of Data Sources: If some of your data sources are similar or belong to the same systems (like SQL Server databases, APIs, etc.), consider consolidating or combining them in Dataflows or a Data Warehouse. This reduces the number of sources Power BI needs to connect to directly.

To manage this at an enterprise level, it might require consultation with Microsoft support or using a service such as Power BI Premium for better data handling.

Power BI REST API allows programmatic access to the service, including report management. You can:

Publish a report: Use the import API to upload a PBIX file programmatically.

Update a report's data source: Automate setting the data source for reports once published.

Power BI REST APIs for embedded analytics and automation - Power BI REST API | Microsoft Learn

Datasets - Refresh Dataset In Group - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Hope this documentation and information helps.