Power BI and Dynamic Query

Hi, curious if anyone has successfully queried for data from a baq in Power BI. In order to query using a baq you would use DynamicQuerySvc which requires multiple calls. The first would be GetByID to retrieve the query object then insert parameters if needed then call Execute with that json object. The part I am having problems with is formatting the result from GetByID in Power Query to use in the Execute call.

Completely forgot about the BaqSvc endpoint which will suit my needs

1 Like