Forum Discussion
incremental refresh first time load issue
the incremental refresh is taking long time to load the data at first time? how to resolve thiis issue? power bi license is premium capacity P1
powerbiexpert22 You could limit the amount of data coming in first by, say, loading the last 3 years of data. Then you would remove that filter in your Power Query and configure incremental refresh.
Hi, powerbiexpert22
Thanks for Greg_Deckler reply. Here is an addition to his reply. The RangeStart and RangeEnd parameters are set in the incremental refresh, and when you configure the incremental refresh for the first time, you can choose a shorter date range, which can reduce the time of the first refresh published to the Service, and then refresh other data in the spare time.
Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft Learn
Power BI Incremental Refresh: What Is It and How to Use it – Master Data Skills + AI (enterprisedna.co)Best Regards,
Yang
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
3 Replies
powerbiexpert22 You could limit the amount of data coming in first by, say, loading the last 3 years of data. Then you would remove that filter in your Power Query and configure incremental refresh.
Hi Greg_Deckler , how i would load remining data ? example , the objective is to load 5 years of data in power bi so first I would load let say 3 years of data in power bi then how I would load remaining 2 years of data , can you share some more details on this?
Hi, powerbiexpert22
Thanks for Greg_Deckler reply. Here is an addition to his reply. The RangeStart and RangeEnd parameters are set in the incremental refresh, and when you configure the incremental refresh for the first time, you can choose a shorter date range, which can reduce the time of the first refresh published to the Service, and then refresh other data in the spare time.
Configure incremental refresh and real-time data for Power BI semantic models - Power BI | Microsoft Learn
Power BI Incremental Refresh: What Is It and How to Use it – Master Data Skills + AI (enterprisedna.co)Best Regards,
Yang
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
