Forum Discussion
Dynamically load rest api result based on the input params
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.
Edit parameter settings in the Power BI service - Power BI | Microsoft Learn
NOTE: This is NOT dynamic.
5 Replies
API based data sources are only accessible in Import Mode.
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?
in import mode, yes. Meaning the parameter changes will be reflected after the next successful semantic model refresh.
Can you please share the reference which I can use for api call with dynamic parameter?
