HELP

[David54]

Hello PBI community, nice to write them. I have 9 Excel files that present similar tables and I must generate the statistics of the merging of these files with power bi.

The restrictions are as follows:

1. Excel files (9) vary in quantity according to the number of projects evaluated per month. For example, in December there were 9 projects and in January 2020 there will be 12 projects to evaluate. That is, some projects will be maintained and some will be added to this new evaluation. How could it be automated in Power BI?

Thank you very much community

[Jayendran]

Hi @David54 ,

I couldn't able to understand your question clearly.

You want to automate what in PowerBI ? Powerbi is visulation tool. 

If you excel is going to grow in the future(in terms of rows), you can easily get the updated records by using the PowerBI Refresh