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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.