How to retrieve texts from Html SharePoint List source in Power BI

Recently I have been put in to a scenario where I need data from SharePoint list to be published into Power BI Report. The columns used in SharePoint list where of type Multi Line Text and contained HTML tags. Up here I am going to show how to consume HTML in Power BI reports, Power BI itself offers way to clean your HTML text allowing you to use only text from it.

Step 1: Connect to SharePoint List  using PowerBI
Step 2: Select Transform Data
Step 3: Find column FieldValueAsHtml, click to expand and select the column with Html data and click ok. This will extract the column data and create a new column with only texts extracted from Html. This new column will be called FieldValueAsHtml.YourColName.



Enjoy.

Comments

Popular posts from this blog

Getting Started With MariaDB

Installing MariaDB on Ubuntu using SUDO