Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Jaunkalns
Frequent Visitor

Data source from web page with drop-down slicers?

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.

2 ACCEPTED SOLUTIONS
v-yuezhe-msft
Employee
Employee

@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

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.

View solution in original post

4 REPLIES 4
v-yuezhe-msft
Employee
Employee

@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

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.

@v-yuezhe-msft

Thank you for the reply.

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

@Jaunkalns,

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

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.

@v-yuezhe-msft

Thank you for the reply.

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors