Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
94 | |
77 | |
63 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |