SQL End point/Power Bi report with shortcut tables

[Mathan1787]

Hi,

I have a Bronze lakehouse from which i have created multiple shortcut tables in Silver layer as I am not really doing much transformation.

when i click on autocreate report on Silver dataset. I cant see the shortcut tables and i can only see the tables created directly in Silver Lakehouse.

[DennesTorres]

Hi,

I just tried and worked perfectly. I selected a dataset built over a lake which only has shortcuts:

The result:

I suggest verifying on the lakehouse configuration if all the tables (including shortcuts) are exposed in the default dataset using the button "Manage default dataset". I already faced situations before where a table had an unsupported data type and this was blocking the tables to be included in the dataset.

Kind Regards,

Dennes

[Mathan1787]

Actually it was glitch it seems. sql endpoints starts to show shortcut tables from bronze.