Forum Discussion

Matjo's avatar
Matjo
Icon for Advocate I rankAdvocate 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.

     

ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity 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.