Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I'm using a notebook to load data from a Fabric warehouse called 'warehouse name'. Some of the tables have spaces in their names, and I'm unable to load the data using the ABFSS path shown below:
abfss://workspace_id@onelake.dfs.fabric.microsoft.com/WH_id/Tables/dbo/[Table and name]
When attempting to load the data, I encounter an AnalysisException indicating that the path does not exist:
Loading data from tables without spaces in their names works correctly. I've tried enclosing the table names with backticks (`), single ('), and double (") quotes, but none of these approaches have resolved the issue. Is there a way to load the data without renaming the tables?
Proud to be a Super User!
Solved! Go to Solution.
I was able to solve this after wasting a day. just remove these [ ] from the name and it works. so the path would be
abfss://workspace_id@onelake.dfs.fabric.microsoft.com/WH_id/Tables/dbo/Table and name
Proud to be a Super User!
Hi, @rubayatyasmin
Glad you found your problem, and you can mark your approach as a solution to help more people with similar problems find answers. Thanks for your understand.
Best Regards,
Yang
Community Support Team
Done, thanks
Proud to be a Super User!
I was able to solve this after wasting a day. just remove these [ ] from the name and it works. so the path would be
abfss://workspace_id@onelake.dfs.fabric.microsoft.com/WH_id/Tables/dbo/Table and name
Proud to be a Super User!
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
User | Count |
---|---|
3 | |
1 | |
1 | |
1 | |
1 |
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |