Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Rant. All i'm trying to do is build power bi reports from web site data that needs a log in first... I do not have 5 years to catch up on Python/Javascript/C++/Hacking the World/Defragment Visual Basic Server Algorithms to figure this out.
I have a website I need data from.
I have a log in
I even know the field names that the website uses txtpassword = password , txtusername = ...username. #mindblown
Power Bi will not log in to it.
And i've spent 10 days searching for a way to use python, selenium, SQL Servers, automated french restaurants, hacking time. there is not a single simple article on this and parsers are terrible.
Goal : use Power Automate to pull up data from a site that needs a log in first, save data.
Please, Simple, Help. If this does not exist then please, someone spend 4 hours programming something that can change the fabric of the internet.
I looked through a bunch of threads on this. Most of them were not resolved but these ones looked a bit more promising:
https://community.powerbi.com/t5/Desktop/Connect-to-a-website-that-has-credential/m-p/414112
https://kohera.be/power-bi/the-hidden-gems-of-the-function-web-contents/
User | Count |
---|---|
98 | |
91 | |
84 | |
73 | |
67 |
User | Count |
---|---|
115 | |
102 | |
98 | |
71 | |
66 |