After 'applying' new column arrangement in Edit Queries, 'Data' tab does not show the arrangement.

[rickylee]

Hello,

I am new to powerbi. I have a problem and hope someone got a solution. After 'applying' new column arrangement in Edit Queries, 'Data' tab does not show the arrangement.

For example, I clicked' close and apply' in Edit Queries which I rearranged some columns.

Then, I go to the Data tab but found columns were not rearranged. I have already disabled 'enable parallel loading of tables' in File > Options > Data Load > Parallel loading of tables.

Does anyone know if this is a defect or a feature which I misused?

Thanks,
Ricky

[rickylee]

Hi @v-chuncz-msft @Stachu,

Although this problem can be solved, it caused me to rebuild all relationships and added all formula. Now, I have a table with 100 formula and I don't really want to rebuild everything again. Are there any other solutions?

Thanks,
Ricky

[v-chuncz-msft]

@rickylee,

In the Query Editor, right click the query and toggle "Enable load".

[rickylee]

Hi @v-chuncz-msft,

'Enabled load' was enabled already. I disabled it, re-enabled it and clicked 'apply'. I can see many steps in the 'Applied steps' column of the query editor. 

I start to think if this is a defect now.

Thanks,
Ricky

[Stachu · Accepted solution]

if you disapble, click apply and then enable and apply again then the new sort order will apear there. The same was happening in PowerPivot, the only way I found to overwrite it was to unload and then load the table in the model

[rickylee]

Hi @Stachu,

It worked. But in the report tab, all my diagrams are gone. They are now diaplayed with a cross and says "Something's wrong with one or more filters". I have tried to refresh the data, restart power bi and re-creat the relationship. No joys. Do I have to do everything again?

Thanks,
Ricky 

[Stachu]

when you click on the visual it should show which measures/fields are causing issues - anything you can fix there?
if not then probably you will have to redo the visuals

[rickylee]

@Stachu

I just started everything again. 🙂

Thanks,
Ricky