Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
110 | |
91 | |
84 | |
66 |