Forum Discussion
Solved
SharePoint List Data
Hello, I am a new PBI user. I imported a SharePoint list as a data source to PBI desktop. When I loaded the data I transformed it. All fields are populating as expexted except one gives me an ID...
Jbro Great - so this means they can select multiple employees. I would choose the expand to new rows, but depending on what info this table holds and what relationships it has with other tables you may need to reference the query first and do the expand in a new query and create a relationship.
I've done a video on survey data that has similar issues of needing to split one table into fact and dimension tables, so it may give you some context for your data or may just confuse you: https://www.youtube.com/watch?v=UAjAtbN1MAY&lc=UgxgL2VT3OuiI6v8ZVd4AaABAg
Understanding Fact and Dimension table concepts will help you a lot too:
https://excelwithallison.blogspot.com/2020/08/its-complicated-relationships-in-power.html