topic Re: Noob Question About TOM in Developer

Noob Question About TOM

Beefheart — Wed, 03 May 2023 10:23:22 GMT

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.

Re: Noob Question About TOM

lbendlin — Fri, 05 May 2023 01:53:00 GMT

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)

Re: Noob Question About TOM

Beefheart — Fri, 05 May 2023 07:06:51 GMT

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