Forum Discussion
How to setting a dynamic URL connection
Hi wendywang,
We could achieve this using the Get Data->connect to Web->Advanced settings.
Using the following URL as an example:
http://community.powerbi.com/t5/Desktop/How-to-setting-a-dynamic-URL-connection/td-p/57072
First, we need select Connect to Web under Power BI Desktop, select Get Data->Others->Web, then choose Advanced, there would be URL parts listed, and we could click parts to add, when edited the part text box, there would be URL preview available, at here, separate the part that you would like to replace with Parameter, the /desktop for example here:
Click OK, move to the Authentication page, after configure Authentication, the web content should be loaded for us to load/edit, choose edit. When Query Editor opens, click Manage Parameters, create a new parameter which would hold all the changed values, Type set to Text. See:
After saving the new parameter, click on Data Source Settings->change source, on the drop down list under the left of the /Desktop, then select the Parameter, see:
Click OK to apply.
If you have any further questions, please feel free to post back.
Regards
thank you for your share, I create this kind Power BI for our company already, now I need connect our WEB Page, the URL most part is same, some part need parameter, i don't know how to add this parameter to URL,
Hi wendywang,
We could achieve this using the Get Data->connect to Web->Advanced settings.
Using the following URL as an example:
http://community.powerbi.com/t5/Desktop/How-to-setting-a-dynamic-URL-connection/td-p/57072
First, we need select Connect to Web under Power BI Desktop, select Get Data->Others->Web, then choose Advanced, there would be URL parts listed, and we could click parts to add, when edited the part text box, there would be URL preview available, at here, separate the part that you would like to replace with Parameter, the /desktop for example here:
Click OK, move to the Authentication page, after configure Authentication, the web content should be loaded for us to load/edit, choose edit. When Query Editor opens, click Manage Parameters, create a new parameter which would hold all the changed values, Type set to Text. See:
After saving the new parameter, click on Data Source Settings->change source, on the drop down list under the left of the /Desktop, then select the Parameter, see:
Click OK to apply.
If you have any further questions, please feel free to post back.
Regards
Thank you very much, it is easier than my M parameter.
I have a website url as http://in-coevsts/KPISTestData
There are hyper links in website , when we clicked on hyper link in the above url it hits as anonther page and generates anonther URL as
http://in-coevsts/Trend?dtk=CADCOR
http://in-coevsts/Trend?dtk=MOBFWK
......
I want to display reports on the above specific URLs whenever the specific hyper link clicked
How power URl knows which URL is clicked in the web page?
Hello,
I've similar kind of scenario, but there are 2 additional things that I require
1) We have different urls for different environment which uses basic authentication. So when I change my URL, username and password should also change for basic authentication as different URL is mapped with different username and password.
2) How can I do deployment using Azure devops, Is there any stage which can help me achieving the 1st point in an automated way.
For Ex-
for My dev environment I have
URL - https://dev.com/api/countries which is using basic authentication
username - "abc"
password - "123"Now while pushing it to QA env it should be -
URL - https://qa.com/api/countries which is using basic authentication
username - "xyz"
password - "456"