Dynamics365 HTML text tags from stylized notes passed to Power BI

(0) Share

Report

Posted on by MuensterAndMonkeys

Premise:
Our operations team is constructing a Power BI report that relies on annotations/notes entity data.
The query and visualization associated work as intended, except the notestext column contains HTML stylization tags that shouldn't be there.

The above is an example note within our development environment with "Test Note1"
as the title and "note test" in the body.

The above is the particular column shows the HTML tags within our Power BI report.
This is the same body-text as in the first screenshot, but surrounded
by stylization and tags.

Question:
What is a good approach to sanitize, remove, or work around the HTML tags that import with our notetext?
This must be accomplished without disabling "rich text format" option within Dynamics.

Thank you for your help - Ian

All responses (1)

Answers (0)

MuensterAndMonkeys 5 on at

Like (0)

Report

RE: Dynamics365 HTML text tags from stylized notes passed to Power BI

Replying to bump this post. Currently investigating business rules within Dynamics as a potential solution.