I have a table loaded from power query, but it shows some of data different. When I open the table in power query data is correct and is as of expected but in loaded table in worksheet some cells showing weird data. I can see some cells in name column is different and not existing in power query table but is showing in loaded table! Have refreshed, have renamed file, have reloaded. Frustrated! Any help please?????
Power Query only shows you a preview of the data you're importing 999 rows. It does this so it can remain agile while you apply transformations. So, even though you think the data loaded to the worksheet is different, it's more likely that the data with the issues just isn't showing up in the preview.
You can use the filters to force Power Query to show you the data that has the issues so you can fix it. i.e. filter the column containing the issue and search for it. You can then see what the issue is, remove the filter and apply a transformation that will fix the issue when you close & load and the transformations are applied to the entire dataset.
Mynda
I understand and have filtered those columns in power query table and data is different, What I dont understand is if its loaded from power query table what is happening when its loaded that changes some text in worksheet!!!!
Without seeing an example of what you mean by 'different' it's impossible to comment further. Please share an example file that illustrates the issue (preferred), or at the very least, screenshots.
