cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
karlagb20 Regular Visitor
Regular Visitor

Power BI relationship with SharePoint Lis

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?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Power BI relationship with SharePoint Lis

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

2 REPLIES 2
AClerk New Contributor
New Contributor

Re: Power BI relationship with SharePoint Lis

@karlagb20 

You need to crearte a relationship between the tables.

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

Good Luck!
A

Community Support Team
Community Support Team

Re: Power BI relationship with SharePoint Lis

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

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 365 members 3,978 guests
Please welcome our newest community members: