Forum Discussion

Frequent Visitor

8 years ago

importing dynamic json file

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://f...

Tips and Tricks

Anonymous

Not applicable

8 years ago

Jannis68,

Please check parameters in the query editor of attached PBIX file.

Regards,
Lydia

dynamic json.pbix26 KB

Frequent Visitor

8 years ago

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

Anonymous
Not applicable
8 years ago
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-p/395121.

Regards,
Lydia
- Jannis68
  Frequent Visitor
  8 years ago
  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
  - Anonymous
    Not applicable
    8 years ago
    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

Related content