I have a project of Net Core which it create database, tables and measures in a Tabular model. I would like to query some tables like we would do in SQL, for example, "select * from myTable". I've seen Microsoft documentation but I can't find an example that explains how to query a table of my tabular model. How can I do it? Could you give me an example?
I would like to query the cube and get a array like:
| TableA.Column1 | TableA.Column2 | TableB.Column1 | TableC.MeasureA |
|---|---|---|---|
| 1 | Marketing | Rosario | $999 |
| 2 | Finance | Córdoba | $456 |
The DAX equivalent for SELECT is EVALUATE, the equivalent for
is