Forum Discussion

Matjo's avatar
Matjo
Advocate I
8 years ago
Solved

Create scheme by limiting rows imported

Hi, 

I have an unknown database with 60 tables. It it possible to use Power BI to import top 100 rows max per table in order to show the scheme?

Need Help
  • ImkeF's avatar
    ImkeF
    8 years ago

    Yes, Table.FirstN is the function for it.

     

    There is also other usefull functions like: Table.Schema and Table.Profile that return intertesting details about your data.

     

1 Reply

  • ImkeF's avatar
    ImkeF
    Community Champion
    8 years ago

    Yes, Table.FirstN is the function for it.

     

    There is also other usefull functions like: Table.Schema and Table.Profile that return intertesting details about your data.