Issue in Power Bi Data Load

RehanAmjad_ · ‎07-12-2024

I am facing the memory allocation issue in Power as i am using the Premium per user in Power bi and i am importing around 26 million rows and files goes to below 500 mb even and still i gives me error.
If anyone can help me out in this issue please help.

Anonymous · ‎07-14-2024

Hi @RehanAmjad_ ,

Normally, it deserves to succeed. You can provide detailed error messages. It would be better to troubleshoot the problem.

Best regards,
Community Support Team_ Scott Chang

AmiraBedh · ‎07-12-2024

Even if your dataset is under 500 MB, handling 26 million rows can be quite intensive. So first question to ask, do you really need all that data ? Why don't you aggregate it ?

So, you can also reduce the number of columns, filtering out unnecessary rows, and using data aggregations or summaries where possible. Verify also the data types as inappropriate data types can consume more memory.

2 things in my mind : split your data into smaller chunks or use incremental refresh.

Proud to be a Power BI Super User !

Microsoft Community : https://docs.microsoft.com/en-us/users/AmiraBedhiafi
Linkedin : https://www.linkedin.com/in/amira-bedhiafi/
StackOverflow : https://stackoverflow.com/users/9517769/amira-bedhiafi
C-Sharp Corner : https://www.c-sharpcorner.com/members/amira-bedhiafi
Power BI Community :https://community.powerbi.com/t5/user/viewprofilepage/user-id/332696