topic Re: REST API executeQueries in Developer

REST API executeQueries

sunrise — Tue, 09 Nov 2021 11:31:35 GMT

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.

Re: REST API executeQueries

lbendlin — Wed, 10 Nov 2021 01:50:33 GMT

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.

Re: REST API executeQueries

Anonymous — Fri, 12 Nov 2021 09:12:44 GMT

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