how to refresh data in power bi desktop report view

[Anonymous]

Hi,

I'm cleaning data in Power BI desktop, I have sorted my data and column orders in power query and click 'apply and close', when i am back in report view, the can see the changes are not reflected in report view. i have use the refresh button, which seem to update all the queries normally, but the data in reporting view remains old data. 

[v-diye-msft · Accepted solution]

Hi @Anonymous 

I believe you can refer to these similar posts:

https://community.powerbi.com/t5/Desktop/Sorting-by-multiple-columns/m-p/536884#M251918 

https://community.powerbi.com/t5/Desktop/How-to-order-by-column-name-and-measure-value/m-p/860531#M412845 

[amitchandak]

@Anonymous , sorting in power query will not have any impact of visual. What was expected out of it ?

[Anonymous]

it looks column order doesn't change in report view either. 

I want to sort data first by employee id, then by job year. is it possible to sort data on criteria based on 2 columns, the point is i want to add a column to compare individual's job change across years, therefore data needs to be sorted by employee and by year. 

[amitchandak]

@Anonymous , you have that in table not in matrix - https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-march-2020-feature-summary/#_Multi-column_sort

[Anonymous]

sorry, I was in data view, not in reporting view. 

below is how data looks in power query. Data is sorted by employee id and job year.

below is my data view. 

[Anonymous]

I suspect there is some memory issues. I opened a new pbix file, and copied the M codes to the new file, column orders get correct this time. however, I still don't know how to solve the memory issue, i have clear the cache in PB Desktop and 'include in report refresh' is always ticked, so don't know why data view doesn't get refreshed.