I have been trying to load my data, but it always freezes. I will let it go for hours. There are a lot of transformations happening and these datasets are large. I feel like I'm missing something so if someone could point me in the right direction that would be helpful.
you can't import more than 1gb. With premium,I think you can increase it to 10gb.
But either way it's not the most ideal method. Before you import the data i recommend inserting sql statement to filter the data down e.g, sql code - recent year, limit 1000 rows,etc. This should be done on the server side/power query editor before importing to power bi.