The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi, Team
I created a schema enabled lakehouse, and the name is 'lakeschema'.
My workspace name has only letters in it, but I'm getting the error below.
1. An error occurred when trying to load from Files to a table.
Server Error.
Message : Operation is not supported for workspaces with non-alphanumeric characters in the workspace name. Please ensure that your workspace name has only letters or digits.
Error Code : UnsupportedWorkspaceName
2. An error occurred when Notebook tried to load a file.
InvalidHttpRequestToLivy: [TJS_OnelakecatalogUnsupportedWorkspaceName] Use only letters and numbers for workspace names with schema enabled lakehouse. HTTP status code: 400.
Thanks,
Hong
Solved! Go to Solution.
Hi, @VinayKumar7
Thank you for your response.
I tested the same again in the workspace where the error occurred, but it works fine.
I then created new workspaces (letters only, lettes with space, and non-alphabetic letters) and tested them, and they work fine.
So, the feature is in preview.
Thanks,
Hong
Hi, @VinayKumar7
Thank you for your response.
I tested the same again in the workspace where the error occurred, but it works fine.
I then created new workspaces (letters only, lettes with space, and non-alphabetic letters) and tested them, and they work fine.
So, the feature is in preview.
Thanks,
Hong
Hi @Hongju_Jung ,
Even I also faced same issue when I started learning Fabric. Below are the steps I tried and it works for me.
First Delete existing workspace you created "lakeschema" under Lakehouse.
Step 1: Create a new general workspace with a name of your choice, selecting a licensing mode in the Advanced section that includes Fabric capacity (Trial, Premium, or Fabric).
Now that you have a workspace, it's time to create a data lakehouse for your data files.
Step 2: In the Synapse Data Engineering home page, create a new Lakehouse with a name of your "lakeschema".
Step 3: View the new "lakeschema" lakehouse, and note that the Lakehouse explorer pane on the left enables you to browse tables and files in the lakehouse.
Step 4: In your workspace it's created by "dbo" schema, in below screenshot by default it should be empty files/folders.
Step 5: Finally load you CSV files into Tables.
User | Count |
---|---|
6 | |
4 | |
3 | |
2 | |
2 |
User | Count |
---|---|
16 | |
16 | |
10 | |
6 | |
6 |