Forum Discussion

Mathan1787's avatar
Mathan1787
Helper I
3 years ago

SQL End point/Power Bi report with shortcut tables

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.

data engineering

2 Replies

  • DennesTorres's avatar
    DennesTorres
    Power Participant
    3 years ago

    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's avatar
    Mathan1787
    Helper I
    2 years ago

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