Approach for loading the big json files

Hi PBILearner2022 

Handling large JSON files in Power BI can indeed be challenging, Here are some strategies to help improve the loading time and efficiency:

Incremental Refresh:

• If your dataset gets updated with new data periodically, consider using Power BI's incremental refresh feature. This way, you only load new or changed data rather than reloading the entire dataset each time.
  
  
  

Optimize the JSON File Structure:

• Ensure that the JSON file is well-structured and optimized for parsing. A deeply nested or poorly structured JSON file can significantly slow down the import process

Increase Resources:

• Ensure that your machine or the server running Power BI has enough resources (RAM and CPU) to handle large files. Power BI operations are resource-intensive.

Optimize Data Model:

• After loading, optimize your data model. Remove unnecessary columns, use efficient data types, and ensure that relationships are correctly set up. This can help improve overall dashboard performance.

Upgrade Power BI Version:

• Ensure you are using the latest version of Power BI, as Microsoft continuously improves performance and data handling capabilities.

Use a Database:

• In some cases, it may be more efficient to load the JSON data into a database (like SQL Server) and then connect Power BI to the database. Databases are optimized for handling large datasets and complex queries.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.