topic Re: Has anyone had success setting up Crealytics project in Fabric? in Data Engineering

Has anyone had success setting up Crealytics project in Fabric?

hstance — Thu, 05 Sep 2024 01:21:11 GMT

How do you read in data from an excel in FAbric? I use crealytics in Synapse, but it doesn't work in Fabric. Has anyone tried?

Re: Has anyone had success setting up Crealytics project in Fabric?

Anonymous — Thu, 05 Sep 2024 06:47:12 GMT

Hi @hstance,

You can create a notebook to use pandas package function to read data from excel: (the sample file is upload to the files folder and I copy the api path to use in the functions)

import pandas as pd # Read an Excel file from your Lakehouse into a Pandas DataFrame # Replace LAKEHOUSE_PATH and FILENAME with your own values df = pd.read_excel("/lakehouse/default/Files/test.xlsx") display(df)

Read and write data with Pandas - Microsoft Fabric | Microsoft Learn

Regards,

Xiaoxin Sheng

Re: Has anyone had success setting up Crealytics project in Fabric?

Anonymous — Thu, 12 Sep 2024 06:59:21 GMT

Hi @hstance ,

Any update on this? Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Re: Has anyone had success setting up Crealytics project in Fabric?

DumboFly — Fri, 04 Oct 2024 05:22:51 GMT

for some reason this doesn't work for me, I changed my lakehouse name, let's say it's called lakehouse_1. Then I use this

# Read in raw data table_path = "/lakehouse_1/Files/test.xlsx" pd_test = pd.read_excel(table_path)

and failed.

however, if I use the ABFS path as the table path, I can read the data successful. Can you please help me with the relative path?

Re: Has anyone had success setting up Crealytics project in Fabric?

jrauj67 — Tue, 24 Jun 2025 09:07:56 GMT

Hi,

I found a way to use Crealytics project in MS Fabric:

You will need to create a lakehouse and a default environment, which will be attached to your notebook.
In your local machine you need to build fat jar with all dependencies.
1. For this purpose create a pom.xml file with this definition:

<project> <modelVersion>4.0.0</modelVersion> <groupId>com.example</groupId> <artifactId>spark-excel-fatjar</artifactId> <version>1.0</version> <packaging>jar</packaging> <dependencies> <dependency> <groupId>com.crealytics</groupId> <artifactId>spark-excel_2.12</artifactId> <version>0.13.5</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-shade-plugin</artifactId> <version>3.4.1</version> <executions> <execution> <phase>package</phase> <goals><goal>shade</goal></goals> <configuration> <createDependencyReducedPom>false</createDependencyReducedPom>  </configuration> </execution> </executions> </plugin> </plugins> </build> </project>

Download the "Binary zip archive" from https://maven.apache.org/download.cgi
Extract the ZIP to a directory like C:\Program Files\Apache\Maven
Add Maven to the System Environment Variables:
- Go to System Properties > Environment Variables
- Under "System variables", edit Path and add:
  C:\Program Files\Apache\Maven\bin
Verify it works using mvn -v and run mvn clean package
Upload spark-excel-fatjar-1.0 into Lakehouse/Files
Add spark property spark.jars with abfss jar path into the default environment (e.g. abfss://<workspace>@onelake.dfs.fabric.microsoft.com/<lakehousename>/Files/spark-excel-fatjar-1.0.jar).
Enjoy.

Re: Has anyone had success setting up Crealytics project in Fabric?

biggusdickus — Fri, 10 Oct 2025 09:52:45 GMT

Excatly what I was looking for kudos to you 🙂