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