We have data volume of >10M records in Azure Synapse, what is the best performant approach to push such a huge volume of data from Azure to Power BI. Post initial load we need to perform incremental data refresh from Azure to Power BI.
1) What is the connection mode we need to use?
2) Star schema in Power BI is performant while handling such huge volume of data?
Please show some light over to this.