Forum Discussion
Coping data from [Warehouse_Live].[sys].[tables]
Hi Byzza this is a know issue (System Views in Microsoft Fabric – Query references an object that is not supported in distributed processing mode | Under the kover of business intelligence)
In the meantime you could use a pipeline to extract any sys data you need, load into tables in the warehouse and do what you need to do.
------------------------------------------------------------
If this reply has helped, please consider giving kudos
and marking the reply as the answer to help other
------------------------------------------------------------
Hi Byzza this is a know issue (System Views in Microsoft Fabric – Query references an object that is not supported in distributed processing mode | Under the kover of business intelligence)
In the meantime you could use a pipeline to extract any sys data you need, load into tables in the warehouse and do what you need to do.
------------------------------------------------------------
If this reply has helped, please consider giving kudos
and marking the reply as the answer to help other
------------------------------------------------------------
OMG, thank you. you have saved me so much time trying various work arounds in notebooks.
This work fine for what I need.
