Forum Discussion
Helper VSharepoint Shortcut
Hello ,
I am trying to get xlsx file from sharepoint folder to my tables section in the Lakehouse but I cannod read it through the shortcut. And if there any other practices rather than shortcusts since I am new in Fabric .
another question the shortcut gets the new data immediately ?
Best Regards
Hello ahmedshalabyy12
If you plan to use a single Excel data file, it's recommended to use Dataflow Gen2 to import it into your Lakehouse Tables. This is a low-code, production-friendly approach.
For guidance, you can refer to this blog:
SharePoint Folder into Microsoft Fabric - Hat Full of Data
5 Replies
- deborshi_nag
Super User
Hello ahmedshalabyy12
If you plan to use a single Excel data file, it's recommended to use Dataflow Gen2 to import it into your Lakehouse Tables. This is a low-code, production-friendly approach.
For guidance, you can refer to this blog:
SharePoint Folder into Microsoft Fabric - Hat Full of Data
- tayloramy
Hi ahmedshalabyy12,
The sheet name field is not the file name, it is the name of the sheet within the file.
v-ssriganeshCommunity Support
Hi ahmedshalabyy12,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to deborshi_nag for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
- v-ssriganesh
Hello ahmedshalabyy12,
Hope everything’s going great with you. Just checking, the issue been resolved or are you still running into problems? Sharing an update can really help others facing the same thing.
Thank you.
ahmedshalabyy12Hello v-ssriganesh thank you for following up and thanks for deborshi_nag and tayloramy for their answers, However I searched more about this topic I cannot load xlsx files into tables only CSVs Dataflow gen2 is considered as an answer and there's another solution for larget files to load the xlsx file into a notebook and change it to csv
