Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn 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!