cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cjs_007 Frequent Visitor
Frequent Visitor

Dynamic URL Parameters

Hi Everyone,

 

Relative newbie to Power Bi so thank you for any of the help.

 

Working on a fun project for myself just to learn Power Bi and have gotten myself stumped.

 

I'm playing around with some data from URL for some video game data using the URL below as my data source.

https://esi.evetech.net/latest/markets/10000002/history/?datasource=tranquility&type_id=34

The "10000002" is linked a orders in a region, and the "34" is linked to an item in the game. Changing those variables changes the data pulled. I've set up two text parameters under the advanced tab in the Data Source Settings. I've set them to pull and have it working so that if change 34 to 35 it changes the data set (this is exactly what I want).

I have a list of all regions in the game along with the respective region names, and I also have a list of all item numbers along with their respective items.

I would like to be able to set up a filter that dynamically changes the URL based on that filter. Is that possible? So for example if 34 is Tritanium, and 35 is Pyerite (in game items) - I'd like to be able to search for Pyerite and have the URL change the 34 to a 35 and update my visuals autmatically. Like I Said before I have this working by manually typing in the Item number but would like it a bit easier to use.

 

Is this even possible? Any pointers  in the right direction would be greatly appreciated! Thank you in advance!

3 REPLIES 3
cjs_007 Frequent Visitor
Frequent Visitor

Re: Dynamic URL Parameters

let
    Source = Json.Document(Web.Contents("https://esi.evetech.net/latest/markets/" & Region & "/history/?datasource=tranquility&type_id=" & #"Item number")),
    #"Converted to Table" = Table.FromList(Source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Converted to Table", "Column1", {"average", "date", "highest", "lowest", "order_count", "volume"}, {"Column1.average", "Column1.date", "Column1.highest", "Column1.lowest", "Column1.order_count", "Column1.volume"})
in
    #"Expanded Column1"

Here is what is currently in the advanced editor. I'm just trying to get a way to edit the Region and Item Number by using a attribute filter in the visual itself. Not sure if this is possible or where to start.

 

Thanks again for reading.

Moderator v-yuezhe-msft
Moderator

Re: Dynamic URL Parameters

@cjs_007,

It seems that you want to pass the value in the filter of Power BI report to the source URL. If that is the case, it is not possible. 

You can create item number parameter and region parameter in Power BI Desktop query Editor, for the parameter, you can provide a list of value or get the parameter values from a query. Then you are able to choose different value in dropdown of parameter to change source URL.

1.PNG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
cjs_007 Frequent Visitor
Frequent Visitor

Re: Dynamic URL Parameters

Thank you for the response. This is what I was finding in the various places I looked on the internet but I appreciate you confirming it was not possible.

 

Thanks again.

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 99 members 1,357 guests
Please welcome our newest community members: