When I do a refresh on Power Query the Sort I had in Excel goes away. If I do the Sort in Power Query it doesn't import that Sort to Excel. I don't think that Power Query imports or loads the information the same way twice.
Is this just the way things are or am I missing something simple?
Thanks,
Lee
Is this just the way things are or am I missing something simple?
Thanks,
Lee