cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
wendywang Regular Visitor
Regular Visitor

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.

1 ACCEPTED SOLUTION

Accepted Solutions
v-micsh-msft New Contributor
New Contributor

Re: 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:

11.PNG

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:

12.PNG

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:

13.PNG

 

Click OK to apply.

If you have any further questions, please feel free to post back.

Regards

 

 

6 REPLIES 6
ankitpatira Super Contributor
Super Contributor

Re: How to setting a dynamic URL connection

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

wendywang Regular Visitor
Regular Visitor

Re: How to setting a dynamic URL connection

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 New Contributor
New Contributor

Re: 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:

11.PNG

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:

12.PNG

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:

13.PNG

 

Click OK to apply.

If you have any further questions, please feel free to post back.

Regards

 

 

wendywang Regular Visitor
Regular Visitor

Re: How to setting a dynamic URL connection

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

gowthami Frequent Visitor
Frequent Visitor

Re: How to setting a dynamic URL connection

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?

 

 

 

gowthami Frequent Visitor
Frequent Visitor

Re: Display power BI reports on to web page

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?

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 107 members 1,495 guests
Please welcome our newest community members: