Forum Discussion
PowerBi Connection with Datawarehouse or any data source with 10/100 million data
How do I connect PowerBi with any Data Warehouse or any datasource that has 100 millions of data? What's the right steps and settings to keep for optimal performance? Please help
Thanks Amit.
But when it comes to import with so many records how do I set it for schedule refresh because it would take a lot of time for refreshing the datasets when we publish it to Service. What do you suggest. There could be multiple tables and records in them so when it comes to refreshing them automatically wont it fail?
Hi， Anonymous
For the refresh of large datasets, Incremental refresh and real-time data will help you to some extent.
Incremental refresh extends scheduled refresh operations by providing automated partition creation and management for dataset tables that frequently load new and updated data.
Best Regards,
Community Support Team _ Eason