Forum Discussion
Change Data Capture(CDC) in Power Query
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
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,
2 Replies
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,
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?
