is it possible to create report of 50 lakh rows in powerbi desktop

[ashapr]

i have a question i have to create a dashboard for share market data, which i have to make dynamic report for next 5 years. i am confused. when i am trying to create a report in powerbi desktop, it says "Not enough memory". my first doubt is can i create a dashboard for such a big data in powerbi desktop? second is if not then which option of powerbi i should take - powerbi pro or premium. data of one year contain 5 lakh rows. please guide me as i am new user of powerbi.i need urgent help

[ashapr · Accepted solution]

Hi Amit,

Thank you for your guidance.

Actually i dont have powerbi premium and i have a create a report for share market dataset of last two years(1 jan 2020 to 31 dec 2021). in that there are 500 files and report should be capable of doing analysis for next 5 yrs and its a csv file.

main issue is that when i uploaded last 2 yrs data and tried to write dax function or calculated column, its showing not enough memory.

what should i do in this case.

[amitchandak]

@ashapr , I have worked with pro edition with 1 M rows. (size of 1 GB is limit)

1. Do not include unnecessary column

2. Increase data management cache to 8-10GB (supported by RAM and virtual memory)

3. Keep 20-40 GB of free space on hard disk

check these setting

Ideally, we load limited data and load full data in power bi service using a deployment pipeline. But that is a premium feature. you can take trial of PPU and check

Premium- Deployment Pipeline, Load More Data on Test/Prod : https://youtu.be/l69cnWkoGX0

[ashapr · Accepted solution]

Hi Amit,

Thank you for your guidance.

Actually i dont have powerbi premium and i have a create a report for share market dataset of last two years(1 jan 2020 to 31 dec 2021). in that there are 500 files and report should be capable of doing analysis for next 5 yrs and its a csv file.

main issue is that when i uploaded last 2 yrs data and tried to write dax function or calculated column, its showing not enough memory.

what should i do in this case.

[v-janeyg-msft · Accepted solution]

Hi, @ashapr 

You can increase the number to 16000(According to your computer's running memory).

If it still prompts insufficient memory, then you may need a device with higher running memory and higher configuration.

Second, you can try to use the simplest measure possible. Calculated columns often require much more space than measures, and are related to the complexity of the formula.

Did I answer your question? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,
Community Support Team _ Janey