Power BI Tutorial (18/50) - How to Read Multiple Excel Files

In this video you can explore, How to Read Multiple excel files in Power BI
Things you can Learn
What is Folder Source in Power BI
How to Read Multiple excel / csv files in Power BI
SSIS For Each loop task in POWER BI (Similar Task)

Source Files

#PowerBI #MultipleExcelFiles #Automation

power bi tutorial, power bi for beginners, power bi tutorial for beginners, dashboard power bi, power bi data, power bi excel, power bi dax, dax, microsoft power bi, power bi desktop, power bi report, power bi español, power bi sql, power query, power by, power bi server, powerbi, power bi curso, power bi filter, tableau, using power bi, power bi slicer, power bi kpi, power bi sharepoint, power bi map, power bi tutorial, power bi for beginners, power bi tutorial for beginners, dashboard power bi, power bi data, power bi excel, power bi dax, dax, microsoft power bi, power bi desktop, power bi report, power bi español, power bi sql, power query, power by, power bi server, powerbi, power bi curso, power bi filter, tableau, using power bi, power bi slicer, power bi kpi, power bi sharepoint, power bi map, tutorial power bi, power bi for beginners, power bi tutorial for beginners, dashboard power bi, excel power bi, excel, dax, power bi dax, power bi report, power bi desktop, power bi microsoft, filter power bi, power query, power bi curso, power query power bi, power bi sql, tableau, power bi español, powerbi, slicer power bi, using power bi, python power bi, power bi reports, sharepoint power bi, kpi power bi, power bi interview questions and answers, concatenate power bi, how to install power bi desktop, power bi administration, power bi november 2019 update, power bi overview, arcgis power bi, power bi report builder, power bi gantt chart, conditional formatting in power bi, sumx power bi, power bi on mac, python power bi, sharepoint power bi, power bi pro, calculate power bi, power bi update

[nasugem]

thanks a lot for the video, it helps me

[lakshmikanthparvathapuram]

Thanks for the wonderful video Nag..
Here the columns names and number of columns in all the files should be same?

[vinipowerbi]

Sir i had three files in folders, they were messy, their columns were merged. I edited them and loaded into power query. Now forth file is clean. But when I loaded errors are showing. The format is not matching. Now how do I mess this file like early files. What should be done?

[suralokeshwarareddy]

Could you please share the data files too over here for our practice

[tarungangadhar]

Hey is there any other way to automate data by clicking refresh button in power bi home page when the columns are not same

[madhavig]

Here looks like sources files are same Bangalore -Jan only so please update with all other location source files..You can observe the same links except the first link..Difficult to practice sir

[AnnoyedBigWaterfall-zcvd]

How to create model for 25 excel files all hold different kinds of data

[phanichow]

videos are not in order please re arrange in order for power bi tutorials