Forum Discussion
creating drill-down drop-downs in Power BI reports (while data source is web API)
Standard Power BI reports in Import mode cannot re-call a web API in response to a slicer selection, so a live drill from API 1 to API 2 is not natively supported.
The usual workaround is to pre-load all combinations at refresh time. In Power Query, loop through every possible first-API value, call the second API for each, and union the results into one table. Then the slicer just filters the pre-loaded table like a normal filter.
If the parameter space is too large to fully pre-load, use Paginated Reports (Report Builder) with a parameterized REST/OData dataset. Paginated Reports resolve their query at render time, so the selected value is passed straight into the second API call.
If this helped, a thumbs up and accepting the solution would be appreciated.
Best,
Shai Karmani
Standard Power BI reports in Import mode cannot re-call a web API in response to a slicer selection, so a live drill from API 1 to API 2 is not natively supported.
The usual workaround is to pre-load all combinations at refresh time. In Power Query, loop through every possible first-API value, call the second API for each, and union the results into one table. Then the slicer just filters the pre-loaded table like a normal filter.
If the parameter space is too large to fully pre-load, use Paginated Reports (Report Builder) with a parameterized REST/OData dataset. Paginated Reports resolve their query at render time, so the selected value is passed straight into the second API call.
If this helped, a thumbs up and accepting the solution would be appreciated.
Best,
Shai Karmani
Hi Shai_Karmani ,
Thanks for your insights. Your solution in the second paragraph makes sense. Web API data could only be imported, so I'll try this out. Currently there isn't too much data so I'll grab all the data while it loops. If there's too much data, I'll try the third paragraph.
Jason
