Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have three tables, all are related and i am doing group by on specific columns.
I am able to get the data but now i want the pagination to be appilied on this using dax query. Can any one help on this.
Hi @Anonymous,
The visual itself handles the pagination.
What extra do you want to achieve, can you kindly exoplain a bit?
Prateek Raina
Hi @prateekraina,
That's right but i want the dax query to be called from the c# using ADOMDClient and retrive the data based on the pagination.
Wait...What !!
The question you posted initiallty is very far from what you have replied now.
It would be better if you can explain what are you doing.
Try to tell the problem statement clearly so that people can help you.
For example:
1. From where are you pulling data from?
2. Why do you want to call DAX from C#? What benefit will it provide?
3. What do you intend to do with the data when pullled from c#?
Prateek Raina
1. I have web application from there i am trying to pull the data by calling the dax query using ADOMDClient.
2. I have millions of records in the DB and i want to do the aggregation on that. So Cube will give the result faster than the SQL.
3. I am displaying in the UI
Hi @Anonymous,
I strongly feel that you have posted this question in a wrong forum as this forum is about Microsoft Power BI Desktop.
Nevertheless, I found this on the internet related to your query. Might help.
Prateek Raina