Forum Discussion
Copying several files including power query into a new folder
Hello, I was looking for help about how to copy a folder with 3 excel workbooks that hold the data in 3 corresponding sheets, 1 Power Query workbook, and 1 workbook that has a pivot table and cha...
Great point. I haven't made and used a full data model yet, although I've tried them out.
The reason for the power query, is for 2 of the data files, once I pull them into power query, I perform column unpivots and grouping. I'm not fully familiar with data models, would I be able manipulate the data the same way with only a data model?
The reason for the power query, is for 2 of the data files, once I pull them into power query, I perform column unpivots and grouping. I'm not fully familiar with data models, would I be able manipulate the data the same way with only a data model?
cpartridge , yes, Power Query is for data transforming. As soon as you did that you may load result into data model, it's not necessary to have this intermediate result in the grid. And from data model you may generate PivotTable adding DAX measures as necessary.