Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Matjo
Advocate I
Advocate I

Create scheme by limiting rows imported

‎11-20-2017 07:58 AM

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?

Labels:
Message 1 of 2
598 Views
0
1 ACCEPTED SOLUTION
ImkeF
Super User
Super User

‎11-20-2017 08:17 AM

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!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

Message 2 of 2
716 Views
1 REPLY 1
ImkeF
Super User
Super User

‎11-20-2017 08:17 AM

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!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

Message 2 of 2
717 Views

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

View All