Workbook into Lakehouse

[VWLOD]

Hi,

Is there a way to load a Workbook into a Lakehouse as a Table? In the Workspace i get from Upload > Sharepoint a connection. Now in the Workspace I have this Workbook. My question is. Is it possible to somehow load the data from this Workbook into Lakehouse? I now i can use Dataflow to get data from Sharepoint but I wonder if I can't also load data in this way. If not what is it even for? To just have a Workbook in the workspace for the user to read?

[v-gchenna-msft]

Hi @VWLOD ,

Thanks for using Fabric Community.

Supported formats to upload in your workspace is  .pbix or .rdl .

Incase if you want to upload a workbook/ excel you need to use pipelines in data factory.

Hope this ishelpful. Please let me know incase of further queries.

[v-gchenna-msft]

Hi @VWLOD ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

[v-gchenna-msft]

Hi @VWLOD ,

We haven’t heard from you on the last response and was just checking back to see if your query was answered.
Otherwise, will respond back with the more details and we will try to help .

[VWLOD]

Thanks for the answer. Ok, too bad, I thought there is some possibility to use Notebook to read the Excel file/Workbook I uploaded?

[v-gchenna-msft]

Hi @VWLOD ,

Yes, it is possible to read the excel file using Notebook.
You can follow below steps -

In Fabric - Lakehouse click on get data, upload files.

Choose your excel file.

Once you upload your excel file. You will see it on your files.

Click on top open notebook and choose new notebook.

Paste below code into your notebook.

# 1 load excel file into lake house via import data

# 2 import excel file into dataframe, choose path from files ... copy ABFS
import pandas as pd
df=pd.read_excel('abfss://gch..ouse/Files/sales_xl.xlsx')
#display(df)
# 3 save dataframe into parquet, choose path where want to save file using ...
# 4 if parquet not installed, will get error, in this case: !pip install parquet
df.to_parquet('abfss://gch..ouse/Files/sales_parquet.parquet')
#5 read parquet file
dfp=spark.read.parquet('abfss://gch..ouse/Files/sales_parquet.parquet')
# 6 write parquet into a table, go to lakehouse, from top right click on Lakehouse, change it to SQL End Poin and start using SQL on the table.
dfp.write.mode("overwrite").format("delta").saveAsTable("sales_Table")

Please execute the above code with your ABFS path.
You should see below table on your Lakehouse, once refresh.

Hope this is helpful. Please let me know incase of further queries.

[VWLOD]

Again thank you for you support but i didn't mean upload in a lakehouse. I meant Upload in Workspace. The think is to get an Excel file from Sharepoint and save as Table in Lakehouse. I now I can do this easily with Dataflow Gen2 but I'm looking for an alternative. Do you have an Idea how can I get an Excel from Sharepoint? Can I get this with an Notebook? Or is there an another better way? 

[v-gchenna-msft · Accepted solution]

Hi @VWLOD ,

Inorder to get the data from Sharepoint and save as table in lakehouse.
Firstly you need to load the data from Sharepoint to Lakehouse, at present possible way to load the data into lakehouse is:
1. Using Dataflow Gen2 and Data Pipelines to load the data - SharePoint Online List connector overview - Microsoft Fabric | Microsoft Learn
2. Manually uploading a file directly into lakehouse.

As I already said - Supported formats to upload in your workspace is  .pbix or .rdl, but not .xlsx file.

Note: Workspace is not a place to store your data.

Additional Docs to refer - 
Access Fabric data locally with OneLake file explorer - Microsoft Fabric | Microsoft Learn
Set up your SharePoint Online List connection - Microsoft Fabric | Microsoft Learn

Hope this is helpful. Please let me know incase of further queries.

[v-gchenna-msft]

Hi @VWLOD ,

Glad to know that you got some insights. Please continue using Fabric Community on your further queries.