HI,
while connecting to power bi dataset we get two type of connection one is live and other is direct query .
Direct query is used when you want to add new table of file with your existing table which came from dataset .
if you do not need to add anything new then you should use live it will be faster .
