Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hey guys, I am currently connecting to a load of csv files (about 4 gb) and refresh is taking like 20 min. I’m trying to figure out why it’s taking so long but at which point would using a database be best?
Solved! Go to Solution.
@scree09
I'd expect it to be a lot faster if you import the CSV to SQL first. Text file connectors essentially don't have query folding
@scree09
I'd expect it to be a lot faster if you import the CSV to SQL first. Text file connectors essentially don't have query folding
thanks!
User | Count |
---|---|
98 | |
90 | |
82 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
67 |