How to view the design of report including queries and calculations

[Anonymous]

To validate the information in a report I want to see the content of the visuals including the query, calculations, sorting in a design view which I can check against actual data. Similar to a MS Access design view.

[amitchandak]

@Anonymous , There is no consolidated view. You Can use Power Query to check transformation(Home -> Transform Data-> Transform data)

You can check each table for measures and columns and filed pane.

You Can also take help from external tools like Tabular Editor 2(Open Source), DAX studio