PowerBI used to track rewards flights availability?

[Sukhi5710]

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?

[Sukhi5710]

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 · Accepted 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