Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I am a keen player of fantasy Premier League, and are looking for a way to load team-picks for the players in my private league. The link below shows the structure of the link:
https://fantasy.premierleague.com/drf/entry/722115/event/1/picks
I am looking for a simple M script that can update a flat table based on a table of team_ids and round_numbers. Furhtermore, the array of round number should be within the range of 1 and last round played (can be a parameter). Below is a copy of the current Advanced Editor:
best,
Jan Nylund
@Jannis68,
Please check parameters in the query editor of attached PBIX file.
Regards,
Lydia
Hi,
a good start. I looking for a way to update my table with all rounds played and all players in my league. Both players and rounds could be in separate tables. If I had performed this in Python, I would have used a look. Is there a similar function here?
best,
Jan
@Jannis68,
Yes. You can choose "Query" when creating parameters. For more details, please review this similar thread:https://community.powerbi.com/t5/Desktop/Using-a-table-column-as-a-list-of-values-for-a-parameter/td....
Regards,
Lydia
Hi,
still not there, as far as I can see you only end up with the picks for one player for one round. What I am looking for is a smooth way to open the follwoing links (and to add rounds automatically 😞
https://fantasy.premierleague.com/drf/entry/722115/event/1/picks
https://fantasy.premierleague.com/drf/entry/7707/event/1/picks
https://fantasy.premierleague.com/drf/entry/722115/event/2/picks
https://fantasy.premierleague.com/drf/entry/7707/event/2/picks
.....
Both Player and Round could be a list, my question is how to merge these lists into
best,
Jan
@Jannis68,
What do you mean merge lists? In your scenario, you would need to create two parameters , one for team id, one for round, and you should choose "Query" as suggested value when creating these parameters.
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.