Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
AkshayManke
Advocate I
Advocate I

See Records is Showing Data with HTML Tags - Needs to be in Normal Text

‎09-26-2018 12:06 AM

Hi,

 

We have a SharePoint List for similar like a IT Helpdesk System. The list has several Rich Text columns to capture the resolution steps, actions etc. We have created Power BI Dashboards for Reports Visualizations. When we right click on any visualization, there is an option called See Records where we can see all the data.

 

The problem here is, the data which is shown is with HTML tags (for example: "<div class=""ExternalClass127C1243DE4D45DC9F7374BBB3106AB5""><html> <div>Test</div> </html></div>")

 

Even if I export the data in to an CSV file, still it shows in HTML which is not solving the purpose.  I want the data to be shown in normal text within Power BI Itself using See Records option.

 

I am sure that, i am not the first who facing the issue and there must be some efficient way to have it tackled. 

 

Can anyone please help with solution.

 

Regards,

Akshay

Labels:
Message 1 of 8
24,305 Views
0
1 ACCEPTED SOLUTION
AkshayManke
Advocate I
Advocate I

‎12-31-2018 10:20 PM

After going through several references, i found that the column type was "Enhanced rich text" hence the html tags was getting added. I have changed the type to "Plain Text" and then the tags were removed from the PBI reports. This worked well for me for now.

View solution in original post

Message 4 of 8
24,206 Views
7 REPLIES 7
AkshayManke
Advocate I
Advocate I

‎01-16-2019 03:20 AM

I got the reference on the below post and it worked as expected.

 

https://whitepages.unlimitedviz.com/2018/04/power-bi-report-rich-text-sharepoint/

 

Below the orignal post.

 

https://community.powerbi.com/t5/Integrations-with-Files-and/Importing-Multiple-Lines-of-Text-field-...

 

Akshay

Message 8 of 8
24,151 Views
0
AkshayManke
Advocate I
Advocate I

‎01-16-2019 03:17 AM

I got the reference on the below post and it worked as expected.

 

https://whitepages.unlimitedviz.com/2018/04/power-bi-report-rich-text-sharepoint/

 

Below the orignal post.

 

https://community.powerbi.com/t5/Integrations-with-Files-and/Importing-Multiple-Lines-of-Text-field-...

 

Akshay

Message 7 of 8
24,151 Views
0
AkshayManke
Advocate I
Advocate I

‎01-16-2019 03:15 AM

I got the solution by referring to the below post.

 

https://whitepages.unlimitedviz.com/2018/04/power-bi-report-rich-text-sharepoint/

 

Got the above post from the below reply.

 

https://community.powerbi.com/t5/Integrations-with-Files-and/Importing-Multiple-Lines-of-Text-field-...

 

Hope someone can use it!!

 

Regards,

Message 6 of 8
24,151 Views
0
AkshayManke
Advocate I
Advocate I

‎12-31-2018 10:20 PM

After going through several references, i found that the column type was "Enhanced rich text" hence the html tags was getting added. I have changed the type to "Plain Text" and then the tags were removed from the PBI reports. This worked well for me for now.

Message 4 of 8
24,207 Views
kearley
Regular Visitor
In response to AkshayManke

‎06-02-2022 11:30 AM

Thanks for your solution.  It's sad that the grid does not offer common features one would expect or at least display rich text when detected.

Message 5 of 8
4,955 Views
0
v-chuncz-msft
Community Support
Community Support

‎09-27-2018 01:05 AM

@AkshayManke,

 

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/Removing-HTML-Script-from-data-in-Query-Editor/td-p/351995

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Message 2 of 8
24,286 Views
AkshayManke
Advocate I
Advocate I
In response to v-chuncz-msft

‎09-27-2018 10:43 PM

Hi Sam,

 

Thanks for responding to my question. I checked the M-Script but since i am new to this domain, unable to get the desired results. Could you please give more clarity that how to use it. Also, my PBIX is based on a sharepoint list and i want that when a user clicks on See Records then the data should be visible in plain text.

 

Appreciate your answer.

 

Regards,

Akshay

Message 3 of 8
24,279 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All