Forum Discussion
Fabric Data Science Tutorial - Sample Data not accessible
- 1 year ago
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.
- 1 year ago
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.
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.
- suparnababu81 year agoSuper User
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!
- Savio_FERNANDES1 year agoRegular Visitor
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.
- v-ssriganesh1 year agoCommunity Support
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.
- Savio_FERNANDES1 year agoRegular Visitor
Thank you to suparnababu8 and v-ssriganesh for taking the time. Very much appreciated.
I will open a ticket as mentioned and will report back here on the status.Thanks,
Savio.