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?
Go to Solution.
In addition, i would like to share an article how to create relationships among tables
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.
You need to crearte a relationship between the tables.
If the department name is a unique value, connect these columns together.
Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.
Register by September 5 to save $200
Check out what's new in the Power BI Community!
Continue your learning in our online communities.