cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bmoon
Frequent Visitor

Data Stuck Loading

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.

bmoon_0-1659369465717.png

 

3 REPLIES 3
ray_ux
Solution Sage
Solution Sage

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

bmoon
Frequent Visitor

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

 

Is there a way to get around this?

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.

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.