Forum Discussion
Data transformations on PBI Query Editor not reflected on Table View on Desktop App
Try this step
1. Contextual Filtering:
Slicers or Filters: If you have any slicers or filters applied on the page, they might be affecting the data displayed in the Table View.
Relationships: Ensure that any relationships between tables are defined correctly and are not causing unintended filtering.
2. Data Model Changes:
Calculated Columns or Measures: If you've added or modified calculated columns or measures, they might be influencing the data displayed.
Hidden Columns: Ensure that the columns you expect to see are not hidden in the Table View.
3. Query Editor Transformations:
Order of Transformations: The order in which you applied transformations in the Query Editor might be affecting the final output. Try rearranging the steps to see if it makes a difference.
Conditional Logic: If you used conditional logic (e.g., IF statements, filters) in your transformations, ensure they are functioning as expected.
Troubleshooting Steps:
Remove Filters: Start by removing any slicers or filters from the page and see if the correct data is displayed.
Check Relationships: Verify that your relationships are defined correctly and are not causing unintended filtering.
Review Transformations: Double-check your Query Editor transformations to ensure they are applied correctly and in the desired order.
Create a New Table: If the issue persists, try creating a new calculated table based on your transformed data and see if the output matches your expectations.
If still get trouble please share the pbix file with dummy data.