Forum Discussion
How to update report data automatically
Hi CLCastroEn ,
It can be done in PBI Desktop, but it can also be done in DataFlows online in the PBI Service. The example picture I attached earlier is actually from an online DataFlow implementation where I use this technique to combine millions of rows of GPS data.
Pete
Hi CLCastroEn ,
1) Go to New Source then select Sharepoint Folder.
2) Navigate to the folder where all your Excel files are kept and select Combine & Load. Make sure that the only files in this folder are the ones you want to combine.
3) You will see that Power Query has set up some steps for you like this:
4) Select Transform Sample File query and you should see one of your Excel files in there. Perform all the transformations in this query that you want done to ALL of the files in the folder BEFORE they are combined e.g. Use first row as headers, Change Types etc.
5) You should see one of the queries has not been blocked from loading to the model (name is not in italic script). This is the combined result of all of your Sharepoint files. You can then perform further transformation in this query on the combined dataset.
Pete