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
hellodazza
Helper II
Helper II

Extracting Html Table from Outlook Email

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. 

screenshot.jpg

 

hellodazza_1-1678771268951.png


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



2 REPLIES 2
hellodazza
Helper II
Helper II

Hi @lbendlin , 

I want to extract the data and compile them to be later used with any visualization. Thanks.

Cheers
Darren

lbendlin
Super User
Super User

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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors