Hello everyone, I am creating a dataset that reads from a table within a Fabric warehouse, in a specific schema. This warehouse has other schemas with their own tables and views. I have created a ‘Microsoft Fabric Warehouse’ linked service that works correctly. I use this linked service in the dataset, but when I look at the available tables, some of them do not appear. Instead of selecting it, I have tried the option of entering the name manually, but, as with the drop-down list, some tables work correctly, while others are said to not exist. Do you know what could be causing the adf dataset to be able to see some tables and not others, given that they are all in the same Fabric warehouse? Thanks in advance!

Hi AnHell, Are you connecting to the warehouse using a SQL endpoint, or directly through OneLake with a Warehouse connection type? The SQL Endpoints can take some time to sync. If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Problem detecting tables and views in Fabric warehouse

Forum Discussion

Related content

Fabric warehouse connections problem

Warehouse : Long-Running Query Detected – Impacting Fabric Capacity

Detected Type Mismatches

Warehouse Scaling

Logic problem?