Forum Discussion
Solved
Coping data from [Warehouse_Live].[sys].[tables]
Hi Brains Trust, I'm trying to get a list of all the warehouse tables and put them in a table that I can do some reporting on, but I keep running into the error The query references an object ...
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
------------------------------------------------------------
spaceman127
Super User
Super User