cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
binhthaiv Frequent Visitor
Frequent Visitor

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

Accepted Solutions
Super User
Super User

Re: How to download entire data from database

Hi @binhthaiv,

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?

3 REPLIES 3
Super User
Super User

Re: How to download entire data from database

Hi @binhthaiv,

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?

binhthaiv Frequent Visitor
Frequent Visitor

Re: How to download entire data from database

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

Super User
Super User

Re: How to download entire data from database

Hi @binhthaiv,

glad to hear that Smiley Happy

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 285 members 3,061 guests
Please welcome our newest community members: