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

Notifications

Announcements

No record found.

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,255

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
    994 on at
  • Verified answer
    Steven Renders Profile Picture
    5,672 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
    95,750 Super User 2025 Season 2 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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

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

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,092

#2
YUN ZHU Profile Picture

YUN ZHU 663 Super User 2025 Season 2

#3
Sumit Singh Profile Picture

Sumit Singh 515

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans