Dynamically load rest api result based on the input params

[JosephKingston]

Hi Team,

I need to load the two select boxes as parameters(Holiday and Brand) from two different db2 tables using sql query. On selecting those 2 values I need to call rest api to get list of companies and populate them in table. On changing any one of the value Holiday or Brand  then again it has to load the companies from api. Is this possible to do? Please share if any reference available.

Holiday Parameter: select distinct hdate from holidays

Brand Parameter: select distinct brand from brands

Company List as Table:  /api/v1/get-companies?hdate-param=01-01-2024&brand-param=Honday,Toyota

Thanks.

[JosephKingston]

Thanks for the reply. I updated parameters details in initial post. Based on changing parameter, is this possible to load the api again and show the updated result?

[lbendlin]

in import mode, yes. Meaning the parameter changes will be reflected after the next successful semantic model refresh.

[JosephKingston]

Can you please share the reference which I can use for api call with dynamic parameter?

[lbendlin · Accepted solution]

Edit parameter settings in the Power BI service - Power BI | Microsoft Learn

NOTE: This is NOT dynamic.

[lbendlin]

API based data sources are only accessible in Import Mode.