How to Dynamically update a parameter value based on data from a client’s website to PowerBI Desktop

Here is the scenario:

1. I have a base URL parameter in my Power BI report.
2. This base URL needs to be dynamically updated based on a value retrieved from the client’s website.
3. The client’s website is built using React.js.
4. I need this update to occur seamlessly within Power BI Desktop and eventually extend this functionality to scheduled refreshes when published to Power BI Service.

5. I have tried setting up a parameter in Power BI Desktop and manually updating it, but I need a solution that automates this process.

   I appreciate any guidance or solutions you can provide to help achieve this dynamic parameter update within Power BI Desktop.

   Thank you.

Steps Taken:

1 ) Fetch Data from Client's API:

let BaseURL = "https://api.example.com", body = "{""sessionId"": ""efac9d4b-7bd9-4efc-80fd-cb623b076da4"", ""isSearch"": false, ""keyword"": """", ""exploreType"": 2}", Source = Json.Document(Web.Contents(BaseURL, [ RelativePath = "/testAPI/explorer/location_hierarchy", Content = Text.ToBinary(body), Headers = [#"Content-Type" = "application/json"] ])), #"Converted to Table" = Record.ToTable(Source), Value = #"Converted to Table"{1}[Value], #"Converted to Table1" = Record.ToTable(Value), Value1 = #"Converted to Table1"{0}[Value], #"Parsed JSON" = Json.Document(Value1), #"Converted to Table2" = Record.ToTable(#"Parsed JSON"), #"Expanded Value" = Table.ExpandListColumn(#"Converted to Table2", "Value"), #"Expanded Value1" = Table.ExpandRecordColumn(#"Expanded Value", "Value", {"EntID", "EntityName", "Name", "Description", "Type", "Icon", "Room"}, {"EntID", "EntityName", "Name.1", "Description", "Type", "Icon", "Room"})

in #"Expanded Value1"

1. Create Specific Reports:

2. Create Parameter in Power BI Report: Set up a parameter in the Power BI report to dynamically change the base URL or any other required parameters based on the fetched data. Used Power Query parameters and updated them as needed to ensure the data fetch logic uses the latest values.

3. Publish Report to Power BI Service: