• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Data is not loading as shown in the Power Query Editor

I want my data as shown in the Power Query Editor to load exactly as shown. After I select Close & Load, the data dumps into Excel in a different way, as if maybe it is sorted or something. Why isn't my data loading into Excel exactly the way it is shown in the Power Query Editor?


Power Query Editor.png



Close & Load.png
 
It is default behavior. The preview window only shows the first 1000 rows (give or take, it depends on a few things). When having evaluated all data the data loaded can come out in a different way.
Adding an index column might help, but it's also expensive.
 
That is really surprising. Why would they design Power Query this way? Why not render the data the way it is in the source files? This really complicates things.

How do you add an index column? What do you mean when you say it's expensive?
 
Expensive = more query time.

On the why? Power Query will try to optimize it's performance.

Add index is via add column, then index column.
 
Back
Top