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.
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
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 |
---|---|
49 | |
18 | |
17 | |
16 | |
9 |