Forum Discussion
Helper IPower bi desktop load
Hello,
Please see the screenshot. Does your power bi desktop crashes if you are loading something similar? If not, how long does it take for you to load? What are your laptop/desktop specifications? Are there any settings I can modify?
Thank you,
Hi Atl ,
I noticed that there are tables with over 100 million records. Given the volume of data, loading it all into the model would be a significant undertaking. Even if it could be fully loaded, it would likely require a substantial amount of time. Even if the loading process completes successfully, you may experience issues with not being able to publish pbix to the service.
Solved: Power BI Size Limitation / Maximum - Microsoft Fabric Community
The exact time required for processing depends on a number of factors, including the performance of the data source, the complexity of the dictionary, the processing power of the device's CPU, the size of the RAM, and the read/write performance of the storage.
If the data is stored in a database that supports query folding, you can leverage Power BI's incremental refresh feature to load only new or changed data.
Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
If the data source is powerful enough, you can also consider using DirectQuery to connect to the data source, which will only import a small amount of data in this mode.
DirectQuery in Power BI - Power BI | Microsoft Learn
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
User-defined aggregations - Power BI | Microsoft LearnBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
1 Reply
Hi Atl ,
I noticed that there are tables with over 100 million records. Given the volume of data, loading it all into the model would be a significant undertaking. Even if it could be fully loaded, it would likely require a substantial amount of time. Even if the loading process completes successfully, you may experience issues with not being able to publish pbix to the service.
Solved: Power BI Size Limitation / Maximum - Microsoft Fabric Community
The exact time required for processing depends on a number of factors, including the performance of the data source, the complexity of the dictionary, the processing power of the device's CPU, the size of the RAM, and the read/write performance of the storage.
If the data is stored in a database that supports query folding, you can leverage Power BI's incremental refresh feature to load only new or changed data.
Incremental refresh for semantic models and real-time data in Power BI - Power BI | Microsoft Learn
If the data source is powerful enough, you can also consider using DirectQuery to connect to the data source, which will only import a small amount of data in this mode.
DirectQuery in Power BI - Power BI | Microsoft Learn
Use composite models in Power BI Desktop - Power BI | Microsoft Learn
User-defined aggregations - Power BI | Microsoft LearnBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group