cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mkrapez Frequent Visitor
Frequent Visitor

Trying to combine Multiple Excel files from SharePoint on PowerBI

I followed the tutorial from https://powerbi.microsoft.com/fr-fr/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

The excel files have 4 rows empty before the headers 

 

- So I tried two approaches:

Not combining the files yet and just editing them to filter only the files that I want that have the same headings. Then combining them and it only gives me one files rows and all others are null. Also, when I click the filter button on the header it says List may be incomplete, and click Load more, I load more and it shows all the feilds that I wanted on the filter tab but dont show on the acutal spreadsheet.

 

 - Also tired what was recommended which was to combine them, all the excel files have 4 rows empty before the headers not sure if this causes a problem. and when I click okay it only gives me the rows of the example file I picked, and all other values are Null.

 

Not sure why its not combining them even when I have all the files filtered to the correct ones, also the button that I see everywhere that says 'Combine Binaries' on mine its called Combine Files? Please help me figure this out. 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Trying to combine Multiple Excel files from SharePoint on PowerBI

@mkrapez,

 

You may check the steps in The Advanced Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
3 REPLIES 3
Highlighted
mkrapez Frequent Visitor
Frequent Visitor

Combine Excel files from sharepoint on PowerBI

I followed the tutorial from https://powerbi.microsoft.com/fr-fr/blog/combining-excel-files-hosted-on-a-sharepoint-folder/

The excel files have 4 rows empty before the headers 

 

- So I tried two approaches:

Not combining the files yet and just editing them to filter only the files that I want that have the same headings. Then combining them and it only gives me one files rows and all others are null. Also, when I click the filter button on the header it says List may be incomplete, and click Load more, I load more and it shows all the feilds that I wanted on the filter tab but dont show on the acutal spreadsheet.

 

 - Also tired what was recommended which was to combine them, all the excel files have 4 rows empty before the headers not sure if this causes a problem. and when I click okay it only gives me the rows of the example file I picked, and all other values are Null.

 

Not sure why its not combining them even when I have all the files filtered to the correct ones, also the button that I see everywhere that says 'Combine Binaries' on mine its called Combine Files? Please help me figure this out. 

Community Support Team
Community Support Team

Re: Trying to combine Multiple Excel files from SharePoint on PowerBI

@mkrapez,

 

You may check the steps in The Advanced Editor.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
mkrapez Frequent Visitor
Frequent Visitor

Re: Trying to combine Multiple Excel files from SharePoint on PowerBI

Okay, so I was able to combine them all correctly but I do not have the data source yet! I've tried the same process on Excel. The problem is when I try to apply the query it takes probably 2 hours to try and load all the rows, and it seems to load them twice. then I get an error saying im not connected anymore and that my credentials are invalid but they arent. I am just trying to combine them all and be able to use them. But they are just stuck in power query ?

 

 

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 299 members 3,163 guests
Please welcome our newest community members: