Change connection string of get data based on different clients

[amaleranda]

Hello PowerBI Gurus,

I have a requirement as below

- data is hostted in a web API. (there are three diffrent locations) means I have three diffrent API links. 

   1) http://mail.companyinfo.com.au:6066/DS/REST/TServerMethods1344/getCompanyData/DEX/GetJYPBPOSTJC/ - Budget Data

  2) http://mail.companyinfo.com.au:6066/DS/REST/TServerMethods1344/getCompanyData/DEX/GetJKPost/- Actual Data

 3) http://mail.companyinfo.com.au:6066/DS/REST/TServerMethods1344/getCompanyData/SOM/GetOpen/ - PO Data

-I have created a report using those links and it works fine. 

Now I have  5 diffent clients. I need to use the same PBIX file so they can dynamically change their server names. 

Only thing change for the new clients are mail.companyinfo.com.au:6066 part of the sting. Is there any way I can prompt user to enter different part in a parameter before they extract their data  so new clints dynamic part would be 

classic-france.nykensanalytics.com:6056 instead of mail.companyinfo.com.au:6066 is there anyway I can achieve this. below is a example of my PowerQuery.  All three PowerQueries for each link is similar transformaton. 

[Mariusz · Accepted solution]

Hi @amaleranda 

Sure, you can use the parameters as per below.

Create Parameter

Adjust your M code as below.

source = Json.Document( Web.Contents( Parameter1 ) )

Also, see the video that includes set up and how to invoke.

https://www.youtube.com/watch?v=7TfV8qTUyfU&t=185s

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn