Forum Discussion
Query dependencies - avoid full refresh
No. Power Query has to process the entire dataset when it loads it into the model. The only way around this is using Incremental Refresh, and that is only availble in data sources that support it. Flatfiles, text, excel, SharePoint Lists definitely do not. Relational databases may. SQL Server does for example, as does PostGRE SQL, but MySQL does not. It depends on your dataset.
That said, Incremental Refresh is a service side thing. It won't help you when you are developing in Power BI Desktop. What you could do is temporarly create a filter on the big data table to limit to a few thousand records, then remove the filter when you are ready to look at the entire dataset and publish.
Microsoft EmployeeMaybe... depends on what your data source kind is. E.g. is it SQL, Azure Tables, or GBQ? Something else?
- edhans
Community Champion
No. Power Query has to process the entire dataset when it loads it into the model. The only way around this is using Incremental Refresh, and that is only availble in data sources that support it. Flatfiles, text, excel, SharePoint Lists definitely do not. Relational databases may. SQL Server does for example, as does PostGRE SQL, but MySQL does not. It depends on your dataset.
That said, Incremental Refresh is a service side thing. It won't help you when you are developing in Power BI Desktop. What you could do is temporarly create a filter on the big data table to limit to a few thousand records, then remove the filter when you are ready to look at the entire dataset and publish.