Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |