Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
Check it out now!Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
Hi there,
I would like to extract a html table from outlook email. The table in the emails are always in a standard format. I can see the text format and also the html format of this email. I just want to keep and compile this table in Power Bi as and when we get these kind of emails. I am able to see these emails in Power Bi. I can see the html body and also the text body. Just don't know how to maintain the table and compile them.
Any help appreciated. Thanks.
Clip ID | Titles/Matches | Event Dates | Start Time | End Time | Dur(hr) | SVOD output time | OTT output time | Remarks |
CR000001367 | UAE's International League T20 2023 Gulf Giants v Desert Vipers | 04-Feb-2023 | 2200 | 0220 | 4.5 | 0023 | 2244 | Via Volicon |
SE000001347 | Serie A 22-23 Cremonese vs Lecce | 04-Feb-2023 | 2155 | 2355 | 2 | 0113 | 0009 | Via Volicon |
CR000001547 | UAE's International League T20 Highlights 2023 Match 27 | 05-Feb-2023 | 2200 | 2230 | 0.5 | 2343 | 2323 | Via Volicon |
CR000001368 | UAE's International League T20 2023 Abu Dhabi Knight Rider v Sharjah Warriors | 04-Feb-2023 | 2200 | 0220 | 4.5 | 0343 | 0214 | Via Volicon |
FR000000678 | Ligue 1 22-23 PSG v Toulouse | 04-Feb-2023 | 2355 | 0155 | 2 | 0313 | 0201 | Via Volicon |
FR000000679 | Ligue 1 22-23 Troyes v Lyon | 05-Feb-2023 | 0155 | 0355 | 2 | 0513 | 0407 | Via Volicon |
CR000001548 | UAE's International League T20 Highlights 2023 Match 28 | 05-Feb-2023 | 0230 | 0300 | 0.5 | 0323 | 0305 | Via Volicon |
FR000000680 | Ligue 1 22-23 Rennes v Lille | 05-Feb-2023 | 0355 | 0555 | 2 | 0643 | 0555 | Via Volicon |
Hi @lbendlin ,
I want to extract the data and compile them to be later used with any visualization. Thanks.
Cheers
Darren
Do you want to extract the data, or do you want to display the email in Power BI? For the second option you can use one of the HTML viewer visuals.