Forum Discussion

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?

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.

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.