Forum Discussion
Fabric Data Science Tutorial - Sample Data not accessible
Hello there,
I am attempting to complete the Data Science Tutorial in Fabric:
Tutorial: Ingest data into a lakehouse - Microsoft Fabric | Microsoft Learn
However, when running the notebook to ingest the file from the blob url it creates a Churn.csv file with the following content:
Hi there v-ssriganesh,
The issue has not been resolved. It has been acknowledged by the Product Group. They have confirmed that blob access is closed due to new security requirements. PG is actively working to come up with an alternative approach.
They have asked for some more time to share an update.
Savio.
Hello all,
The support engineer was able to direct me to tutorials that have valid blob links to access the sample datasets.
Within Fabric, choose a workload (in this case I chose Data Science). Then "Select" Explore a Sample.
Then choose the sample notebook of interest:
And run the code.
What is different is the remote_url. "https://synapseaisolutionsa.z13.web.core.windows.net/data/bankcustomerchurn"
This URL is publicly available and produces the correct rows of data within the churn.csv file.
Microsoft will need to update the links in their Learn.com tutorials + GitHub Sample Notebooks.
suparnababu8 v-ssriganesh Thank you for your time on this.
Savio.
23 Replies
Hello all,
The support engineer was able to direct me to tutorials that have valid blob links to access the sample datasets.
Within Fabric, choose a workload (in this case I chose Data Science). Then "Select" Explore a Sample.
Then choose the sample notebook of interest:
And run the code.
What is different is the remote_url. "https://synapseaisolutionsa.z13.web.core.windows.net/data/bankcustomerchurn"
This URL is publicly available and produces the correct rows of data within the churn.csv file.
Microsoft will need to update the links in their Learn.com tutorials + GitHub Sample Notebooks.
suparnababu8 v-ssriganesh Thank you for your time on this.
Savio.Hello Savio_FERNANDES,
Thank you for sharing your insights. Kindly consider marking this response as “Accept as Solution” to help other community members find it more easily and resolve similar issues efficiently.
Thank you.Unfortunately, the link no longer works. We are getting a Requested file is unavailable error.
Thank you for the detailed response.
I replicted your scenario. It's loading csv file, but when accessing the csv file it's throwing an error.like you mentioned. Please have a look on below image
Requesting CST team to assist on this. Let's wait for CST team to respond on this.
Thank you!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!Hello there! Thank you very much for taking the time to reply.
I did have a lakehouse attached and I did run the code. The code runs. Yes it creates a Churn.csv file for me as well. But did you look inside the Churn.csv file? (EDIT: ah I see that you have, thanks for checking). It doesn't have data. It has that error message inside the Churn file.
Also, even if I wanted to get the file manually where would I get it? It isn't reachable.Yes, Agree. I ran the csv file to display. it's throwing error. I altered my reply above. Pls refresh the page and have a look.
Let's wait for CST team to respond on this.
Thank you!
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Ugh! Yeah, this is still an issue several months later. I was able to find a version of the file for a tutorial demo I was working with that required this file on GitHub. Here is a link, I hope someone else finds this helpful as well.
dp-data/churn.csv at main · MicrosoftLearning/dp-data · GitHub
Best of luck!
The download works; however not all the column names in the tutorial are found in this data set.
Yes, I later observed that too. I have not been able to find the file that was supposed to be used for training. Made me wonder if they removed what might be considered PII from the file and updated it, but not the documentation - just an assumption there. However, the altered version of this file affects the training classes and materials used to demonstrate the tutorials. I gave up and moved onto a different topic.
Hi Savio_FERNANDES,
Thank you for posting your query in the Microsoft Fabric Community Forum.
I was able to reproduce your scenario and successfully downloaded the sample dataset (churn.csv) as referenced in the tutorial. Here’s what I did:- Created a Lakehouse in Power BI Service.
- Used the following code (as in the tutorial):
import os, requests if not IS_CUSTOM_DATA: remote_url = "https://synapseaisolutionsa.blob.core.windows.net/public/bankcustomerchurn" file_list = [DATA_FILE] download_path = f"{DATA_ROOT}/{DATA_FOLDER}/raw" if not os.path.exists("/lakehouse/default"): raise FileNotFoundError("Default lakehouse not found, please add a lakehouse and restart the session.") os.makedirs(download_path, exist_ok=True) for fname in file_list: if not os.path.exists(f"{download_path}/{fname}"): r = requests.get(f"{remote_url}/{fname}", timeout=30) with open(f"{download_path}/{fname}", "wb") as f: f.write(r.content) print("Downloaded demo data files into lakehouse.")This successfully created the churn.csv file in the Lakehouse > Files > raw folder.
Also note: The URL used to download the file
“https://synapseaisolutionsa.blob.core.windows.net/public/bankcustomerchurn/churn.csv” appears accessible from notebook environments, even though it is not publicly browsable in a web browser.
Further if any tutorial’s sample data URL remains inaccessible and no updated dataset is available publicly, you can report this issue via the feedback links on the tutorial page.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.Hello v-ssriganesh
Up to this fine the code is executing. But later when we are trying to display the result. It's throwing error in the result output table. Please follow below chat carefully.
Thank you!
Hi there,
Thank you for the time you took to answer and reproduce.
However, if you take the next step to inspect the churn.csv file that you downloaded/created, you will see that there is no sample data inside it.
As I mentioned I am able to create the churn.csv file, but the content/data is not available to us.This issue was also reproduced and confirmed by the other super user below.
Could you please inspect the content of the file and confirm whether or not you have sample data (rows) inside it?
Thanks,Savio.
Hello Savio_FERNANDES,
I apologize for missing this. As previously mentioned, if the tutorial's sample data URL remains inaccessible or the data is missing, you can report the issue via the feedback links on the tutorial page or raise a support ticket for further investigation.
You can create a Microsoft support ticket using the link below:
https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket
Thank you, suparnababu8 for sharing your valuable insights.If you find this information useful, please accept it as a solution and give it a 'Kudos' to assist others in locating it easily.
Thank you.
