Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

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 who...
Need Help
  • Nolock's avatar
    Nolock
    7 years ago

    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?

Nolock's avatar
Nolock
Resident Rockstar
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    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

    • Nolock's avatar
      Nolock
      Resident Rockstar
      7 years ago

      Hi Anonymous,

      glad to hear that :)

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