web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Small and medium business | Business Central, N...
Answered

Power BI Incremental Refresh

(0) ShareShare
ReportReport
Posted on by 3,297

Hi All

WIth BC SaaS, can Power BI be set up to refresh incrementally based on record medication date/time? How do people manage refreshing large data sets, as it would take a long time to refresh all entries?

Thanks

I have the same question (0)
  • Suggested answer
    pankaj.k Profile Picture
    1,018 on at
  • Suggested answer
    Steven Renders Profile Picture
    5,682 Moderator on at

    Before implementing incremental refresh I suggest to look at which APIs you are using. When using a Query API, you can aggregate data by implementing group-by, to match the granularity of your Power BI report(s). This reduces the size of the dataset. Next you can and should implement filters in Power BI, to not import what you don't need. So, remove all rows you don't need (aggregate, filter) and remove all columns you don't need.

    Most out of the box APIs are page APIs and don't have any aggregation or filtering. Create and use custom Query APIs.

    Then you can implement incremental refresh, for example using Dataflows:

    Using incremental refresh with dataflows - Power Query | Microsoft Learn

    Be aware this requires a Premium PBI license.

    Many times I see Power BI reports importing ledger entries, without aggregating, without filters,... Then the data gets displayed in tables/matrixes, charts all grouped by certain fields. In those cases, you should import the data grouped (aggregated). This can reduce millions of rows to thousands of rows...

  • Suggested answer
    YUN ZHU Profile Picture
    98,416 Super User 2026 Season 1 on at

    Hi, Sorry I'm not an expert in Power BI, I haven't tested it.
    But I hope the following content can help you.

    Incremental refresh and real-time data for datasets

    https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

    Thanks.

    ZHU

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 1,958 Super User 2026 Season 1

#2
YUN ZHU Profile Picture

YUN ZHU 1,101 Super User 2026 Season 1

#3
Dhiren Nagar Profile Picture

Dhiren Nagar 959 Super User 2026 Season 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans