I’m working with a client who has a report set up with directquery (the report was built by another developer). He wants me to make some adjustments to the model and report, but I can’t view the actual data. I’ve read some articles about directquery but I’m still fuzzy on how it works from a developer point of view.
My question is on the process of building reports when using directquery. Since I can’t view the queries themselves (the actual columns and rows of the tables), how can I build measures or understand what’s going on below the hood? Right now all I can see are the visuals in the report and the names of the tables in the datamodel view, but I can’t view the actual dataset in the data view.
What’s the normal order of operations for using directquery as a developer? Do I need to import the tables, work with the data to build the model, measures and visualizations, and once this is all done, then transfer back to directquery?
Or is there a way for me to work with the dataset while directquery is set up? My main question is whether I need the client to allow me to import the tables to work on the reports, and once I’m finished, transfer everything back to directquery.