Please, help. When we try to do an incremental load from an external origin it shows an error: Upsert is not a supported table action for Lakehouse Table.
Is it possible to create a materialized view in a Fabric warehouse? If not, what alternatives are available besides creating aggregated physical tables?
They have already announced the materialized views but according to official documentation there are quite a few limitations at the moment. https://learn.microsoft.com/en-us/fabric/data-engineering/materialized-lake-views/overview-materialized-lake-view
@Vikas Khairnar Here you have the information: https://learn.microsoft.com/en-us/fabric/data-engineering/materialized-lake-views/refresh-materialized-lake-view
Hello community, Incremental dataflow refresh in Lakehouse is not yet available. According to Microsoft's official roadmap, it was planned for Q1 2025. When will it be available? Thanks in advance.
@Will Needham There is an official Microsoft workaround: https://learn.microsoft.com/en-us/fabric/data-factory/tutorial-setup-incremental-refresh-with-dataflows-gen2