Data Stuck Loading

[bmoon]

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.

[ray_ux]

are you trying to import/direct query? It normally happens because the data size exceed power bi data limit.

[bmoon]

Import mode - the data type doesn't support direct query.

Is there a way to get around this?

[ray_ux]

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.