Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
In the Query Editor, right click the query and toggle "Enable load".
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
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
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
97 | |
82 | |
75 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |