Power query in excel, unable to get data from shared folder due to file size >= 100MB

Random and other categories
1

Power query in excel, unable to get data from shared folder due to file size >= 100MB

2

Hi @Juveria

Could you provide more details? How is it related to UiPath? :slight_smile:

Post moved to #random until it’s more clear

3

I’m using bot to open excel file with power query data model due to excel row limitations…and once the bot open the excel file, auto refresh is executing and the pivot table can be read by the bot…the problem is the power query excel file stored in shared folder, it takes long time to load data from server, and sometimes it fail to load…this actually is not something from UiPath.Is there any work around or any suggestions?

4

copy your data to a local disk and relink and work from that file

5

One of the best options I try first is to change the .xls file into a .xlsb

This will take your 100mb file to probably around 50mbs at most and possibly 20mb’s. This also turns the date in the background to binary so that power query can read it much easier.

I hope this helps!