Occasionally, you will work with multiple datasets that need to be appended to each other. Here's a scenario: you work for a customer service department for a company that provides credit to customers. You are regularly provided .csv and .xlsx files that give summaries of customer complaints regarding credit cards and student loans. You would like to be able to analyze both of these data extracts at the same time but, unfortunately, the credit card and student loan complaints are provided in two separate files. In this example, you will learn how to solve this problem by performing an append operation on these two different files.
- Launch a new instance of the Power BI Desktop, and use the Excel connector to import the workbook ...