combining files in share point

[MarcUrdang]

Good morning .. I am combining files in PBI from a Sharepoint directory .. there are three files .. 2x File Description A and 1x File Description B. I seem to have successfully pointed to the Share Point folder and can see the three files in my PBI model .. however it seem to only pick up records from the files named File Description A and not File Description B. The structure of the files are however the same. 

Must the file names ALSO be the same?

thanks

Marc

[nandukrishnavs]

@MarcUrdang 

Sheet name and column headers should be the same and in the same order.

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[MarcUrdang]

thank you .. well understood .. 

also can I then put ANOTHER file in that same folder and then bring it in as a separate data source by pointing to it directly? Or should that go into another folder? ie Main folder for data and another folder for any other data sources to join in PBI.

thanks
Marc

[nandukrishnavs]

@MarcUrdang 

If you add files on the same site, in a different folder. Power BI will bring the items to the same level. You can't specify the folder name.

The better approach is implementing a naming convention, for example, start with some common word.

Then apply the filter (start with that common word) before combing the files. This way it combines all the required files only. 

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[MarcUrdang]

Sorry for all the questions but I am a fairly new user so thanks for your patience. ...

So are you saying if I have all the files named A in one directory and the files named B in another directory with same column names and sequence but the sheets are named differently then this approach should work?

[nandukrishnavs]

No, the sheet name and column name must be the same as the ones I mentioned in my previous post.

What I'm trying to say is that Power BI will bring all the files from the site. We cannot specify the folder name. If you keep the same file in a different folder. Power BI will bring both files and combine them.

Create this test on your Power BI desktop, you'll understand.

[MarcUrdang]

wonderful

Thanks a lot. I will accept that as a solution.

Enjoy the rest of the weekend.

Thank you

Marc

[nandukrishnavs · Accepted solution]

@MarcUrdang 

If I answer your question, please mark my post as solution, this will also help others.