cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
UsePowerBI
Post Prodigy
Post Prodigy

How to download an xls via a URL that needs authentication?

Hello

 

I have a url that when I type it in MS Edge, it will download an xls file, after I have logged in via a form to this domain/website.

 

How can I load this xls file into PowerBI by just using the cookie from MS Edge without having to re-authenticate? Ie. just download the xls via PowerBI as I do via MS Edge?

 

I tried various types of authentication and none seems to work as it shows the login webpage in the web preview.

 

Thanks!

1 REPLY 1
PhilipTreacy
Super User
Super User

Hi @UsePowerBI 

You won't be able to do this via PBI.  The cookie created in Edge (or another browser) is for that browser, it isn't accessible from within Power BI.

You could use VBA to enter credentials into the form, see this blog post for an example

Web Scraping Filling in Forms With VBA

Regards

Phil



Did I answer your question? Then please mark my post as the solution.
If I helped you, click on the Thumbs Up to give Kudos.


Blog :: YouTube Channel :: Connect on Linkedin


Proud to be a Super User!


Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!