Feb 14

Feb 14 Check & Query Data from Tabular Editor

Kurt Buhler

Data Modelling

QUERY YOUR MODEL FROM TABULAR EDITOR

*…*
*view data & test DAX*
*while developing your*
*Power BI Dataset*
CHECK & TEST MODEL DATA

While developing your Power BI Dataset, you must routinely query the model with a table or visual to check data, your model design and your DAX code.
In Power BI this is done in the visual canvas, but how is this done from Tabular Editor? Many developers will work on the Power BI dataset from Tabular Editor with a separate “thin” report open in Power BI Desktop to test & view recent changes. However, this can cost time & efficiency from alternating between two different windows and user interfaces. This becomes particularly problematic when searching transactional data in tables, as there’s no way in a Power BI Desktop “thin report” to see a “table data view”. Instead, you must tediously create a table visual on the canvas to give you what you need. Further,



Power BI visuals can make it more difficult to test & debug initial DAX code due to modified filter context on the report page — if you forget a slicer, filter or interaction, for example.

Instead, you can use Tabular Editor for both developing and querying / testing the model.
This gives immediate, explicit feedback so you can focus on development without wasting time on
*ad hoc*
testing & exploration. There are a number of ways to do this, and this article gives a brief overview of each.

*This article focuses on Tabular Editor 3; any mention of ‘Tabular Editor’ refers to Tabular Editor 3. Note, however that it is also possible to use method 4 in Tabular Editor 2, discussed below.*
Approach Description Automatic Refresh Test RLS with

Impersonation [A]

TE3 [B]

TE2 1. DAX Query Write & execute DAX queries; modify DAX measures within the query scope. ✓ ✓ ✓ ✗ 2. Pivot Grid Drag & drop fields in a formatted pivot table or filters to query the model via MDX. ✓ ✓ ✓ ✗ 3. Preview Data View & filter tab

📌 Check & Query Data from Tabular Editor (Anupgarh)
🏢 Data Goblins
📍 Anupgarh