Get data from folder

[Cyriackpazhe]

The picture below shows the two excel sheets available in the folderWhen i try to combine , this is what i get.When i combine i get the second picture and i'm confused what i should do from there. What will happen if i click the parameter and press tranform??

What happens when i click the each table provided and press okay??

What is the purpose of 4 queries that is created automatically. What is the Other queries??
Why are the other tables missing. 

[grazitti_sapna · Accepted solution]

Hi @Cyriackpazhe,

Seems like you are loading data from Sharepoint folder?

Creating Individual Tables

If you require individual tables, make individual queries for each file or dataset.
Use "Get Data" → "SharePoint Folder", and filter by file name.

Rather than altering queries, click "Load" straight away when choosing the data.
This avoids unnecessary transformation steps in Power Query.

If you require merging files from a SharePoint folder:
Choose "Combine" when loading files.
Power BI automatically identifies similar file structures and combines them.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!

[v-hashadapu]

Hi @Cyriackpazhe , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[v-hashadapu]

Hi @Cyriackpazhe , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[v-hashadapu]

Hi @Cyriackpazhe , Thank you for reaching out to the Microsoft Community Forum.

Please let us know if your issue is solved. If it is, consider marking the answer that helped 'Accept as Solution', so others with similar queries can find it easily. If not, please share the details.
Thank you.

[ZhangKun · Accepted solution]

The purpose of this connector is to simplify the import of files. It is suitable for simple files, which is friendly to novices. It will automatically generate some queries based on the user's selection to read and parse the file content.

[grazitti_sapna · Accepted solution]

Hi @Cyriackpazhe,

Seems like you are loading data from Sharepoint folder?

Creating Individual Tables

If you require individual tables, make individual queries for each file or dataset.
Use "Get Data" → "SharePoint Folder", and filter by file name.

Rather than altering queries, click "Load" straight away when choosing the data.
This avoids unnecessary transformation steps in Power Query.

If you require merging files from a SharePoint folder:
Choose "Combine" when loading files.
Power BI automatically identifies similar file structures and combines them.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.
💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.
🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.
🔗 Curious to explore more? [Discover here].
Let’s keep building smarter solutions together!