Data source from web page with drop-down slicers?

[Jaunkalns]

Hey guys,

I am trying out new things and wanted to find out, if it is possible to gather large amounts of data from a website.

The problem is that the list of data is sorted and can be accessed by using built in slicers.

Here is a similar source of the data that I am talking about: link

Basically, you can choose only 1 parameter from each drop-down.

Is there a way to access all of the data all at once?

I have looked for answers, but have found nothing that would help me!

Hope that there is an answer to my question.

[v-yuezhe-msft · Accepted solution]

@Jaunkalns,

You can try to connect to NFL API in "Get data->web" entry of Power BI Desktop and check if you can get all data at once.

There are some examples for your reference.

API Strategies with Power BI
Power BI – Connect to your secure API

Regards,
Lydia

[v-yuezhe-msft · Accepted solution]

@Jaunkalns,

You can try to connect to NFL API in "Get data->web" entry of Power BI Desktop and check if you can get all data at once.

There are some examples for your reference.

API Strategies with Power BI
Power BI – Connect to your secure API

Regards,
Lydia

[Jaunkalns]

@v-yuezhe-msft

Thank you for the reply.

I also found this solution: https://www.youtube.com/watch?v=6PZSZ53iSos

[v-yuezhe-msft]

@Jaunkalns,

Glad to hear the issue is solved, you can accept your reply as answer to close this thread.

Regards,
Lydia

[Jaunkalns · Accepted solution]

@v-yuezhe-msft

Thank you for the reply.

I also found this solution: https://www.youtube.com/watch?v=6PZSZ53iSos