![]() ![]() Here’s a few remarks about our case:Įach of these files has only 1 month of data – we’ll have a file for January with just 1 sheet in it that will have all of the data for January. These files are provided by a 3 rd party in order to give us a better understanding of the whole market and how well some products are doing on each market. ![]() In this specific case, we have an Office 365 group that we’ve created where we store some external sales data that do not come from our system. Have you ever wanted to consolidate, combine or append data from multiple excel spreadsheets or workbooks? I bet you have, and it has been a painful process either done manually or via 3 rd party add-ins. In this blog post, we’ll show you how, with the newest version of the Power BI Desktop and Power Query for Excel, you can combine multiple data from Excel files into one big tall table. ![]() As I mentioned earlier, it is still in its Beta stage and more development is in the pipeline.This post was contributed by Ken Puls and Miguel Escobar, Power BI experts and authors of the new ebook, "agic Tricks for Data Wizards".
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |