Forum Discussion
Combine multiple files from different data
There are many good book out there that can do this. Yes, my book was written from the perspective of taking someone who has zero knowledge of Power BI and walking them through the entire lifecycle of importing data, cleaning it up, building a data model, building the report, publishing the report and sharing the report. The entire book is pretty much one big example of how to do things in Power BI.
But there are many great tools online as well! https://docs.microsoft.com/en-us/power-bi/guided-learning/
With regards to automatic refresh. Skipping past Direct Query, which you would not be using with multiple Excel files, you would be working in import mode. So, Power BI imports the data from your Excel files into an internal data model that is then used for reporting. However, you can setup an automatic schedule so that if the Excel files are updated, the data model in Power BI gets updated with the new information.
I dont understand very well where you say "Yes, once published to the Service, you can setup automatic refresh. ".
Excel files are in a folder, should I pass this information for sharepoint to have more interactive work? Our just refresh the excel file in the folder?
There are many good book out there that can do this. Yes, my book was written from the perspective of taking someone who has zero knowledge of Power BI and walking them through the entire lifecycle of importing data, cleaning it up, building a data model, building the report, publishing the report and sharing the report. The entire book is pretty much one big example of how to do things in Power BI.
But there are many great tools online as well! https://docs.microsoft.com/en-us/power-bi/guided-learning/
With regards to automatic refresh. Skipping past Direct Query, which you would not be using with multiple Excel files, you would be working in import mode. So, Power BI imports the data from your Excel files into an internal data model that is then used for reporting. However, you can setup an automatic schedule so that if the Excel files are updated, the data model in Power BI gets updated with the new information.