cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Reply
hellodazza
Helper I
Helper I

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 I
Helper I

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors