Forum Discussion
Power Query Data Unable to Load into PowerBI Model
HI han-solo , you can implement incremental data loading. More information about this on https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview
Or you can use parameters or filters in Power Query to load one year's data at a time and then append each chunk manually or via Power Query append operations.
Thank you very much for your quick reply - highly appreciated!
incremental refresh currently is no option since the query is not SQL based and PowerBI cannot natively access the RangeStart and RangeEnd parameters.
Therefore, the only option I'd currently see would be your alternative you mentioned. But as far as I understand, I would then end up with the same problem again if I appended chunk per chunk manually, published the dashboard and wanted to refresh it then again, no?
Thank you sir!