CODEWITHSUNDEEP
powerbi
Unknown
Unknown

Reputation: 3

PowerBi: incremental data load by using OData feed

is there any possibility to save previous data before overriding because of refreshing data?

Steps i have done:

Now i have a problem how to save previous data before the refreshing phase. I need to preserve the timestamp of previous data and actually data.

Example giving:

Before refreshing:

Table A:
|Columnname x| DateTime | ....
| value | 23.03.2016 23:00

New Table:
|Columnname x| DateTime | ....
| value | 23.03.2016 23:00

After refreshing:

Table A:
|Columnname x| DateTime | ....
| value | 23.03.2016 23:00
| value 2 | 23.03.2016 23:01

New Table:
|Columnname x| DateTime | ....
| value | 23.03.2016 23:00
| value 2 | 23.03.2016 23:01

kind regards

Upvotes: 0

Views: 1491

Answers (2)

GregGalloway
GregGalloway

Reputation: 11625

Incremental refreshes in the Power BI Service or Power BI Desktop aren't currently supported. But please vote for this feature. (update: see that link for info on a preview feature that does this)

If you need this behavior you need to load these rows to a database then incrementally load the database. The load to Power BI will still be a full load of the table(s).

Upvotes: 4

Murray Foxcroft
Murray Foxcroft

Reputation: 13775

This is now available in PowerBI Premium

From the docs

Incremental refresh enables very large datasets in the Power BI Premium service with the following benefits:

  • Refreshes are faster. Only data that has changed needs to be refreshed. For example, refresh only the last 5 days of a 10-year dataset.

  • Refreshes are more reliable. For example, it is not necessary to maintain long-running connections to volatile source systems.

  • Resource consumption is reduced. Less data to refresh reduces overall consumption of memory and other resources.

Upvotes: 0

Related Questions