Query a table with TOM - Analysis Services C#

189 views Asked by At

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
1

There are 1 answers

2
David Browne - Microsoft On

The DAX equivalent for SELECT is EVALUATE, the equivalent for

select * from myTable

is

evaluate 'myTable'