Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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....
  • v-micsh-msft's avatar
    v-micsh-msft
    10 years ago

    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

     

     

ankitpatira's avatar
ankitpatira
Community Champion
10 years ago

Anonymous check this out, you need to do similar and use Web data source within power bi desktop.

  • Anonymous's avatar
    Anonymous
    Not applicable
    10 years ago

    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, 

    • v-micsh-msft's avatar
      v-micsh-msft
      Microsoft Employee
      10 years ago

      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

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        10 years ago

        Thank you very much, it is easier than my M parameter.

    • gowthami's avatar
      gowthami
      New Member
      8 years ago

      Hi All,

       

      I have scenario where my web application URL is  http://in-coevsts/KPISTestData

       

      In the above URL if we click on any hyperlink then anonther opens with data URl As 

       

      http://in-coevsts/Trend?dtk=CADCOR

      http://in-coevsts/Trend?dtk=MOBFWK

      .... so on 

       

      I want to display power BI report to the above specific url  data 

       

       

      Please can any one help me on this?