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

[HarshaK49]

Hi,

1. Data Source Limit Increase:
   The maximum number of data sources allowed per user in the Power BI service is currently capped at 1,000. My project involves managing over 1,000 data sources, and I am requesting guidance on how I can increase this limit to accommodate my requirements.  Please recommend solution for managing a large number of data sources.
2. Automating Report Publishing:
   I am looking for a solution to automate the publishing of Power BI reports to the service. Provide guidance or resources on how this process can be automated, possibly through scripting or APIs, to streamline the workflow?
3. Instant Refresh Trigger via Button in React Application:
   I would like to incorporate a feature in my React application that allows for triggering an instant refresh of Power BI reports through a button click. Is there any support or API that enables this functionality? If so, please provide details on how this can be implemented.

[lbendlin]

Instant Refresh Trigger via Button in React Application:

Please realize that while this can be done, it is an asynchronous request.  Just a request. There is no guarantee whatsoever that the refresh will happen, or will complete successfully.

[rajendraongole1]

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.