REST API executeQueries

[sunrise]

Hello everyone, I'm trying to understand if REST api are what I need.

I created a dataset in Power BI Desktop from an Excel source, and I created  a few hierarchies on it, including the date hierarchy.

There is only one measure.

The point is: I successfully ran executeQueries on this dataset, however I would like to be able to pass the API a hierarchy and a measure, the same way I would do when I drag hierarchies and measures to a chart.

Also, I would expect to get the results based on the hierarchy and the measure passed.

[v-shex-msft]

Hi @sunrise,

Did lbendlin 's suggestions help with your scenario? if that is the case, you can consider Kudo or accept his suggestions to help others who faced similar requirements.

Regards,

Xiaoxin Sheng

[lbendlin · Accepted solution]

Start Performance Analyzer

Start Recording

Refresh Visuals

Open the details for the visual your interested in

Copy Query

Open DAX Studio

Paste Query

Examine and modify DAX as needed

Use the resulting DAX as an inspiration of how to craft your own queries against the REST API.