Power BI - Create a query to consolidate multiple identical Excel sheets

Hi there, my name is Andres and I’m the data analyst of our group. I have developed several reports and dashboards using PowerBI and queries to connect it with Excel, from 1 to many spreadsheets at a time. I think I get what you need, still, would be great to talk via chat to discuss details and hopefully work together.

Hi there, As an expert in Power BI i can help you with this project. Please feel free to contact me to discuss further details. Best regards Miljan

Hello Sir Im excel VBA macro and formula Expert :) for combining your 10 workbook to a single data sheet in 1 file excel i think better we use macro VBA to combine it :) please ping me if u interested to combine your file via VBA macro Sir :) i can do it in few hour if u want :) Thank you Sincerely Galih :)

Hello, I can do this you want in Power BI as i am an experienced Power BI developer with over 8 years in the field. Please check my portfolio to see my work. Thanks!

Hi, I could do it in VBA if you do not mind. That would be open for modifications and future enhancements to manipulate data before the compilation so the final output will be much cleaner than it would be doing just Power BI

Hello, i have dozens of those, i hope i can be of assistance to you solving this. i consider myself very good at power query and power bi looking forward working with you

Hi there. I am a decorated BI Manager with 10 years experience in BI and Data Science. Ive started numerous BI teams and was trained by Microsoft SA on PowerBi. Im willing to work on a POC to prove. Relevant Skills and Experience 8 years experience in Powerbi. Im also the owner of the Cape Town SA powerbi PUG group. Excellent Manager, analyst and developer. Family man with the loyalty that comes with it.

I am Mechanical Engineer, I can deal with Excel perfectly.

Hi, My name is Piyush. I am new to Freelancer, but I have been working with Microsoft Dynamics CRM since 2011 and with Power BI since 2017. I am also a Microsoft Certified Professional for Power Bi and Dynamics CRM. I am pretty much familiar with anything Power BI related. I can work with you to develop the solution, or I can deliver the complete solution of the dashboard and reports. I can also assist with integrating with internal data sources and third-party systems such as Azure Platform and Cloud Services. Here is some work I have done before related to Power BI: •Dashboards created previously for profit and loss statements for the companies which include Month-to-date, Month-on-Month, Year-to-Date, Year-on-Year comparisons with interactive drill-downs to understand the revenue flow of the company. •Balance Sheets for the company-level data to understand the Assets and Liabilities on a real-time basis by row level Security. •Reports created previously with the cash flow statements to visualize the investments, operating and financial activities. •Visualized the data for accounts receivable and accounts payable to understand the pending payments/incomes on generated invoices. •Deployed Power Bi Embedded Applications I’m very eager to assist you in making your Project successful. Additional Activities- A leader of Seattle PowerApps User Group I can help you with any Power BI related customization needs. Let me know if you are interested. Thanks, Piyush Zope

Hi, I have a good expierence working woth Power BI. It´s a amazing tool to complement with excel. Regards