Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Sukhi5710
New Member

PowerBI used to track rewards flights availability?

Does powerBi has solution that can track and alert Aeroplan flights availability? Instead of searching for rewards flights available on Aeroplan.com , can set email alerts if it becomes available? It would do Random search for specific flight, date and trigger email alert?
1 ACCEPTED SOLUTION
v-yuta-msft
Community Support
Community Support

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

View solution in original post

2 REPLIES 2
Sukhi5710
New Member

Does powerBi has solution that can track and alert Aeroplan flights availability? Instead of searching for rewards flights available on Aeroplan.com , can set email alerts if it becomes available? It would do Random search for specific flight, date and trigger email alert?
v-yuta-msft
Community Support
Community Support

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.