Currently, we are using Azure Databricks (Blobs) as a source for Power BI reports. The data is very large, and Azure Databricks works well with it. However, as the data size increases, the load time is becoming longer.
Can you please suggest best Azure data source that handles large data and supports incremental refresh?
@christina.weber I would recommend Azure Data Lake Storage Gen2 and Azure data sources like Azure SQL Database and Azure Synapse Analytics (formerly Azure SQL Data Warehouse) also support incremental refresh and can handle large data volumes. The choice of the best data source depends on your specific requirements and the nature of your data and workload.
Thanks!