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 rdparty 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. I thinks it’s very interesting use of Power BI and Sahrepoint and i suggest you to read it: This post was create by Ken Pulse and Miguel Escobar and published on power bi Blog.
0 Comments
Leave a Reply. |