Power Query Data Unable to Load into PowerBI Model

Hi han-solo ,

There're several ways to do this:

1. You can manually partition your data into smaller chunks and load them incrementally. This involves:

• Creating multiple queries: Each query should load a subset of your data.
• Appending the data: After loading each subset, append it to your existing data model.

2.Dataflows in Power BI can help you manage large datasets by breaking them into more manageable pieces:

• Create a dataflow: Load your data into a dataflow in smaller chunks.
• Link the dataflow: Use the dataflow as a source in your Power BI model.

Incremental refresh in Dataflow Gen2 - Microsoft Fabric | Microsoft Learn

3.Tabular Editor is a powerful tool for managing and optimizing your Power BI data models. It allows you to work with your models more efficiently, especially when dealing with large datasets. You can create partitions in your data model to handle different date ranges. This way, you can load and refresh data incrementally.

Best Regards,

Stephen Tao

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