Forum Discussion
JS10
2 years agoRegular Visitor
load excel data set
Looking for recommended settings in Power BI to load large excel data sets. I have attempted to change within Power BI File<Options<Data Load<Parallel loading of tables. Next going to try to...
audreygerred
2 years agoSuper User
Hi! Just a heads up. Excel binary files will not refresh in Power BI service (however, it might with a gateway). Ideally, if you or someone could load the Excel files to a data warehouse, that would be your best bet.