Solved: Create scheme by limiting rows imported

Matjo · ‎11-20-2017

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 · ‎11-20-2017

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.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

ImkeF · ‎11-20-2017

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.

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

Create scheme by limiting rows imported