Forum Discussion

Beefheart's avatar
Beefheart
Helper I
3 years ago
Solved

Noob Question About TOM

Hello Folks,

 

First, I hope I'm posting in the correct place, if not I'm sorry.

 

I want to access a published PBI dataset in C# using TOM, but I can't seem to find out how you'd query it.
I mean, do you write the query in SQL, Linq, DAX or somthing else?

 

I don't want to do anything too exciting to begin with, just get the items and quantities sold to a given customer in a given date range.

 

Thanks in advance for any help,

 

Beefheart.

Need Help
  • lbendlin's avatar
    lbendlin
    3 years ago

    For that you would use a DAX query.  However, that's not what TOM is about. TOM gives you access to the metadata. For DAX queries you connect to the SSAS instance (XMLA endpoint)

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    3 years ago

    For that you would use a DAX query.  However, that's not what TOM is about. TOM gives you access to the metadata. For DAX queries you connect to the SSAS instance (XMLA endpoint)

  • Beefheart's avatar
    Beefheart
    Helper I
    3 years ago

    Hi lbendlin,

     

    Thank you for the information! To clarify would this be the Microsoft.AnalysisServices.AdomdClient.NetCore.retail.amd64  nuget package?

     

    Thank you again for your time,

     

    Beefheart