Power BI relationship with SharePoint Lis

[Anonymous]

Hi,

I imported a list from SharePoint to power BI as part of my data. I would like to merge both my excel and sharepoint data.

For example, excel has all the department names and sharepoint list has the department name and employees. Is there a way I can link the employees to the deparment on the excel data in power bi?

[v-juanli-msft · Accepted solution]

Hi

In addition, i would like to share an article how to create relationships among tables

https://docs.microsoft.com/en-us/power-bi/desktop-create-and-manage-relationships

With correct relationships, you could use both tables together to analyze for your requirement.

If you need to merge or append two tables to one table, you could open Edit queries and use the Merge queries/Append queries.

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data#combine-data

Best Regards

Maggie

[Anonymous]

@Anonymous 

You need to crearte a relationship between the tables.

If the department name is a unique value, connect these columns together.

Good Luck!
A