Power Platform
Power Platform
Organizer:
- JOSE Organized by
-
-
SharePoint contact field import into Powerbi query
-
SharePoint contact field import into Powerbi query
Hello all – new to the PowerBI, so disclaimer for an easy question, I guess…
I connected PowerBI query with source data from SharePoint list. Some of the columns in SharePoint value are in the Contact (AD Person connection), and are getting fetched in the form of a LIST for each of the cell in the PowerBI column.
I can not clear this list like some of the other look up value, as the value in the contact are possibly including multiple parameters (Email, name, ++)… it gives an error against each line for the contact column…
Any advise on how to slice this contact field into the PBI Query ?
Thank you!
-
1 Reply
-
There ae multiple ways to do this, but here is a quick solution to handle this.
Before doing this, duplicate the query, so you can see the impact before and after the transformation, as I’m sure you will need to adjust the end result.
You can use Power Query to transform and expand these lists into separate columns.
-
Open Power Query Editor:
- In Power BI Desktop, go to the “Home” tab and click on “Transform Data” to open the Power Query Editor.
-
Select the Column with Lists:
- Find the column that contains the lists of contact information.
-
Expand the Column:
- Click on the expand icon (usually looks like two arrows) next to the column header. This will give you options to expand the list into new columns.
- Select the fields you want to expand (e.g., Email, Name, etc.).
-
Handle Errors:
- If there are errors in the expanded columns, you can use the “Remove Errors” option or filter them out.
- You can also use the “Replace Errors” option to handle specific error values.
-
Clean and Transform Data:
- After expanding the columns, you might need to clean and transform the data further to fit your needs. This could include renaming columns, changing data types, or applying additional transformations.
-
Load the Data:
- Once you’re satisfied with the transformations, click “Close & Apply” to load the data back into Power BI.
-
Log in to reply.
