Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How to download entire data from database

I tried to load all data from a database. Every time it just shows a hundred rows, if I roll down then it will show more, but this will take time to load all data. Do you know any way I can get a whole database or specific time frame of the database?

 

Thanks a lot!

Ben

1 ACCEPTED SOLUTION
Nolock
Resident Rockstar
Resident Rockstar

Hi @Anonymous,

does it happen in the Power Query Editor? If it is so, then it is a standard behaviour. The Power Query Editor shows only a preview which contains up to 1 000 rows. Wenn you click on Close & Apply in the top left corner, all rows will be loaded from your data source.

Btw., you can also ask for all rows in your preview for column profiling, but in most cases it doesn't make sense.

 

Or does it happen in the Power BI Desktop UI?

View solution in original post

3 REPLIES 3
Nolock
Resident Rockstar
Resident Rockstar

Hi @Anonymous,

does it happen in the Power Query Editor? If it is so, then it is a standard behaviour. The Power Query Editor shows only a preview which contains up to 1 000 rows. Wenn you click on Close & Apply in the top left corner, all rows will be loaded from your data source.

Btw., you can also ask for all rows in your preview for column profiling, but in most cases it doesn't make sense.

 

Or does it happen in the Power BI Desktop UI?

Anonymous
Not applicable

Yes, it happens on the Power BI UI. I have tried your guide and it can be show all now.

Thank you so much!

Ben

Hi @Anonymous,

glad to hear that 🙂

If I have answered your question, please accept it as a solution. Thank you.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors