Forum Discussion
Open the data model
Hi b-kopik ,
We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.Thank you.
Hello b-kopik ,
Just to clarify, storing data in a Fabric Lakehouse is different from SharePoint. In SharePoint, you can still download the original Excel file, but in Lakehouse, the file is ingested into OneLake and stored as structured data (Delta/Parquet format) for analytics. So, users can't download the original Excel file directly from Lakehouse like they can from SharePoint. If it's important to have the raw Excel files available for download, SharePoint is better for file sharing, while Lakehouse is best for analytics and scalable storage.
About the file location in Lakehouse: if you only see the file name in the table view, the data has been ingested into a table and the original Excel file isn't stored as-is. To find physical files, go to your Lakehouse and check the Files section where uploaded files like Excel, CSV, and Parquet will show up there. Tables created from these files are stored separately in the Tables section.
This approach lets you keep Excel files in SharePoint for downloads, while using Lakehouse for long-term analytics and governance.
Thank you.
Thank you. I am wondering if we need Lakehouse then, given the size of our datasets and since we would like to have the ability to download the data as needed.