Change Data Capture(CDC) in Power Query

[Sean0426]

Hi all,

I'd like to know can Power Query do CDC(change data capture) when doing data refresh jobs? And if so, how to do that?

I'm using Power Query in Excer to extract my Facebook's fans page's data; however, everytime whey I have to refresh data, power query will call  Graph API and extract all the data again.

Is there any skill to just extract the updated data from a data source?

Thanks,

Sean

[v-sihou-msft · Accepted solution]

@Sean0426

No, it's not possible. CDC is database engine feature which applies on table level. The internal working is based on Agent job. But Power Query is based on Data Mash-up Engine which can only load and transform data. For more details, please see: What Is Power Query? Introduction to Data Mash-up Engine of Power BI

Regards,

[Sean0426]

 @v-sihou-msft

Fatastic information, very useful, thank you so much.

In other word, if I want to do CDC, I've to load data and build cubes in SSAS, then set CDC in SSAS.

Am I right?