![]() ![]() ![]() This will minimise the amount of work/rework you have to do in the future. In other words, your objective should always be to have the absolute minimum amount of interaction with the source files possible and push all the work into Power Query. My advice to all my Power Query students is “zero touch the file”. It could be a transactional file that grows in length each time or it could be a dimension/lookup table (such as Customers) that can change slowly over time, and you always want to see the latest version. This pattern is common if your new file contains a superset of all the data. Over the next few weeks I will share a couple of simple techniques for the other 2 common scenarios starting today with pattern 2 above. I have previously shared an article explaining pattern 1 (how to combine all files in a folder with Power Query). This could be in addition to pattern 1 or 2 above. You have a workbook with multiple sheets within a single workbook that need to be combined.Each day/month/year you get a new file and it replaces the old file.All the data in all the files need to be combined and loaded. Each day/month/year you get a new file containing incremental data. ![]() There are 3 common patterns that come to mind. There are quite a few common business scenarios where you get data in the form of a file on a regular basis from some source system and you need to process these files into your Power BI reports. Relationships in Power BI and Power Pivot.Who Needs Power Pivot, Power Query and Power BI Anyway?.The Best Way to Install Power BI Desktop.30 Reasons You Should Be Considering Power BI.Dimensional Modeling (Excel and Power BI).Power BI for the Business Analyst (with live Q&A). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |