Hi,
I have a Power BI report with 2 GB size and I am using SQL database to create my report. The tables I am using are huge but I am limiting the data and importing only the data that I need. I have got quite a bit of measures, calculated tables etc.
The report is loading quick inspite of huge data.
We have Power BI premium P1 capacity but unable to refresh the dataset in Power BI desktop and Power BI service due to insufficient memory. I have got 16GB RAM system and all the visuals are loading fine. It's giving this error only when refreshing dataset.
What is the maximum size that a P1 sized capacity can refresh? Any idea how to resolve this?
Hi @bml123 ,
This happens sometimes when the server is over occupied.
Choosing a non work hours for couple of loads may be helpful.
Regards,
Pranit
Hope it resolves your issue? Did I answer your question? Mark my post as a solution! Appreciate your Kudos, Press the thumbs up button!! Linkedin Profile |
Helpful resources
Join our Fabric User Panel
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Power BI Monthly Update - June 2025
Check out the June 2025 Power BI update to learn about new features.
Fabric Community Update - June 2025
Find out what's new and trending in the Fabric community.
