Forum Discussion

Ayushman1997's avatar
Ayushman1997
Frequent Visitor
1 year ago
Solved

Power bi dekstop

#QuestionForGroup Hi All. I have a dataset of 2.9M rows which upon unpivoting and merging with 1 table becomes some 246M rows. After that I have to remove duplicates from the table(based on Col1, C...
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    1 year ago

    Hi Ayushman1997,

     

    Thank you for sharing your update. We understand that you are encountering a memory issue due to the large number of records in Power BI. Since you have already escalated this to the relevant teams, we appreciate your patience as they investigate further.

    In the meantime, you might consider optimizing your dataset by:

    • Using aggregations to reduce data volume.
    • Implementing incremental refresh to load only necessary data.
    • Filtering out unnecessary columns and rows before loading into Power BI.

    Also, please go through the below solved solution for better understanding:
    Solved: Memory run out issues in power bi desktop - Microsoft Fabric Community

     

    If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.

     

    Best Regards