Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I have a database that I update monthly from Excel for Power BI. The layout and panels for the year 2017 are all ready. When I want to insert the 2018 information into the base worksheet, from Excel 2017, it gets very heavy, so I need to create a new Excel worksheet for the year 2018. The problem is that in doing so, Power BI understands the worksheets 2017 and 2018 as different tables so that I can't use the information in the same panel or the formulas I had already created. So, is it possible, in Power BI, to join the two excel sheets so that I can see the information in a single panel? Can I put the information in a single table so that I do not miss the formulas and layouts I've already created?
Solved! Go to Solution.
Hi, I have a database that I update monthly from Excel for Power BI. The layout and panels for the year 2017 are all ready. When I want to insert the 2018 information into the base worksheet, from Excel 2017, it gets very heavy, so I need to create a new Excel worksheet for the year 2018. The problem is that in doing so, Power BI understands the worksheets 2017 and 2018 as different tables so that I can not use the information in the same panel or the formulas I had already created. So, is it possible, in Power BI, to join the two excel sheets so that I can see the information in a single panel? Can I put the information in a single table so that I do not miss the formulas and layouts I've already created?
Hi @ingridsantana,
Two ways for your consideration:
You can import the Excel for 2017 and 2018 one by one, you will get two separate datasets in Power BI desktop, then you can manually append the 2018 dataset to 2017 dataset in Query Editor mode.
Alternatively, you can place the all excel files in a single folder. In desktop, choose "Folder" rather than "Excel" under the data connector list. For details, please see:
Load Multiple Excel (xls or xlsx) Files
Power BI – Importing Multiple Excel Sheets
Best regards,
Yuliana Gu
Hi @ingridsantana,
Two ways for your consideration:
You can import the Excel for 2017 and 2018 one by one, you will get two separate datasets in Power BI desktop, then you can manually append the 2018 dataset to 2017 dataset in Query Editor mode.
Alternatively, you can place the all excel files in a single folder. In desktop, choose "Folder" rather than "Excel" under the data connector list. For details, please see:
Load Multiple Excel (xls or xlsx) Files
Power BI – Importing Multiple Excel Sheets
Best regards,
Yuliana Gu
Hi, I have a database that I update monthly from Excel for Power BI. The layout and panels for the year 2017 are all ready. When I want to insert the 2018 information into the base worksheet, from Excel 2017, it gets very heavy, so I need to create a new Excel worksheet for the year 2018. The problem is that in doing so, Power BI understands the worksheets 2017 and 2018 as different tables so that I can not use the information in the same panel or the formulas I had already created. So, is it possible, in Power BI, to join the two excel sheets so that I can see the information in a single panel? Can I put the information in a single table so that I do not miss the formulas and layouts I've already created?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |