Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Not applicable

Webscraping a Webpage with a Login and Password

I need some help working through an issue with trying to pull into both desktop and dataflows of a table of data behind a login and password.


The data is coming from


The public version includes historical data, yet not the current records.


The entire historical table is only available behind the pay wall.


I want to pull this data into a dataset for a report.

Community Support
Community Support

Hi @Anonymous 


Let me know if you'd like to get below data:


You might refer to this article: 


Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
Not applicable

@v-diye-msft  Thanks for the suggestion.


I've already tried similar methods and run into the issues of not being able to pass/use login and password to access current values.


Instead, I run into the "Table highlighting is disabled..." error like in the thread below.

Get error message as Table Highlighting is disable... 


I tried to extract data form a website which required credentials and failed dismally. I eventually succeeded with a long workaround using Excel.

If you're interested, you can see how in this thread:


Get data from web with credentials 

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Not applicable



Thanks! I'll look into the link you sent and try it out.


Good luck! (btw, you still need the credentials to get into the dataset- the solution in the thread only solves the problem of getting access to the dataset going through the login requirements; it does not provide a back-entry avoiding login...)


EDIT: I just did a search for a solution using Python and came across this:


Scraping data from web which requires login using Python 

Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors