15.2 Merge Data from Multiple Excel Files or Workbooks in Power BI (Power Query) | By Pavan Lalwani

Awesome

Hi Pravan , Again big thank you for the course. One doubt , could you please explain what is Use fuzzy matching to perform the match if possible.

Very Nice Pavan.. This is really helpful. so precise, so informative.. Please keep it up and Thank you.

Hi, How to merge more than 3 excel files with one primary key. All the 3 or 'n' excel files are having same data. It should be dynamic.

Thank you😊😊😊😊

video's are short and simple. planning, Designing series and executing must not have been easy. As a outsider we feel easy. Thankyou for creating series of video. Appreciate your hard work..

If the table join was done with 'Power View' instead of 'Power Query', what would be the difference?

Hi sir, Can one to many/many to many files be joined while data is being loaded instead of one by one?

Thank you

finished practicing

Sir when we apply left join
Then why is it not showing all records of left table.
It only shows the matching records (inner join)

Can this be applied using folder instead of importing data using excel? Just curious.

Thank You! Does this method keep connection to original Excel files as source data? When info changes in each of the individual Excel files, does the PowerBI query update the info in the merged view? Also, can there be 2-way connection and updating? Can data be updated manually in the PowerBI view, and changes can be automatically updated in the original Excel source files?

Hi Pavan,

In AWS quicksight, we can use two different datasets and controlled the visuals(from both datasets) by the same filter by using parameters. Using Parameters we can link two datasets and present all the visuals in the single page itselft and use common filters. Is it possible in Power bi?