Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
are you trying to import/direct query? It normally happens because the data size exceed power bi data limit.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
60 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |