How to Resolve Issues Loading Data from Tables with Spaces in Their Names?

[rubayatyasmin]

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?

[rubayatyasmin · Accepted 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

[Anonymous]

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

[rubayatyasmin]

Done, thanks