Forum Discussion
How to setting a dynamic URL connection
our team need connect different web page to get data,
Is here have any way to create a parameter URL link, let user just choose parameter, then can connect different page data?
Thank you for help.
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
8 Replies
Anonymous check this out, you need to do similar and use Web data source within power bi desktop.
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
The solution posted here helped me to create a web connection with a parameter set up. I am extracting data table from a web page, different values in parameters set up to pull different table based on parameter value, but I can see only the related data of currently selected parameter value in the table.
How to use all the tables fetched for all the list values in parameter table (appended)?
Thanks.
