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.
Solved! Go to Solution.
Hi Sukhi5710,
You can use power query function Web.Contents(url as text, optional options as nullable record) as binary to achieve the data from the website. In addtion, it seems like the websit need username and password so that you may add your browser cookies to the function. It can't be ensured that you can access the data your want from the website because it depends on the dom tree of website.
In addtion, if you can access the data from the website, you can publish your report to power bi service and set schedule refresh so the data will be imported to the dataset again after a scheduled time.
Regards,
Jimmy Tao
Hi Sukhi5710,
You can use power query function Web.Contents(url as text, optional options as nullable record) as binary to achieve the data from the website. In addtion, it seems like the websit need username and password so that you may add your browser cookies to the function. It can't be ensured that you can access the data your want from the website because it depends on the dom tree of website.
In addtion, if you can access the data from the website, you can publish your report to power bi service and set schedule refresh so the data will be imported to the dataset again after a scheduled time.
Regards,
Jimmy Tao