Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello!
I´ve connected PBI to my exchange server and trying to create a report from that data.
I decided to use the Body.HtmlBody from the email, because it was much more structured and thus could be manipulated more easy then Body.TextBody
It looks fine enough in the Query editor:
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><p><strong>Process: </strong>Customer Cancellation</p>
<p><strong>Type:</strong>Billing</p>
<p><strong>Segment:</strong> Private</p>
<p><strong>Description:</strong> This is a test!.</p>
<p><strong>Customer:</strong> Test!</p>
<p><strong>Transaction-ID:</strong>Test!</p>
<p><strong>Attached file:</strong></p>
<p><strong>UserName:</strong>TestMan</p>
<p><strong>Department: </strong>HR</p>
<p> </p>
However when i´m viewing the same data in the Data Tab it looks like this:
My guess is that PBI is reading the html code or something, but how can this be avoided?
Regards
Kim
Solved! Go to Solution.
Hi @Megadeth,
AFAIK, power bi not support to analysis rich text and HTML elements/styles.
If you get date from web site or rich text, power bi will convert them to text with original format style tags.
Regards,
Xiaoxin Sheng
Hi @Megadeth,
AFAIK, power bi not support to analysis rich text and HTML elements/styles.
If you get date from web site or rich text, power bi will convert them to text with original format style tags.
Regards,
Xiaoxin Sheng
Hello!
I´ve connected PBI to my exchange server and trying to create a report from that data.
I decided to use the Body.HtmlBody from the email, because it was much more structured and thus could be manipulated more easy then Body.TextBody
It looks fine enough in the Query editor:
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"><p><strong>Process: </strong>Customer Cancellation</p>
<p><strong>Type:</strong>Billing</p>
<p><strong>Segment:</strong> Private</p>
<p><strong>Description:</strong> This is a test!.</p>
<p><strong>Customer:</strong> A95655</p>
<p><strong>Transaction-ID:</strong> 002MFC7</p>
<p><strong>Attached file:</strong></p>
<p><strong>UserName:</strong> SSL59</p>
<p><strong>Department: </strong>HR</p>
<p> </p>
However when i´m viewing the same data in the Data Tab it looks like this:
My guess is that PBI is reading the html code or something, but how can this be avoided?
Regards
Kim
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
101 | |
86 | |
64 |