Azure Data Lake to Power BI: Special Characters In Directories Causing Issues

Holomew 26

I'm trying to access directories in my Azure Data Lake via Power BI.

Normal directories work fine: https://datalakename...net/folder/folder2/filename.parquet

However, spaces are not working and I get a 404: https://datalakename...net/folder/folder%202/filename.parquet (I've also tried it with an actual space).

Is there any way around this?

Thanks.

PRADEEPCHEEKATLA-MSFT 85,746 Reputation points Microsoft Employee

2021-09-14T07:49:14.37+00:00

Hello @Holomew ,

Thanks for the question and using MS Q&A platform.

I'm able to load the data where the url has special characters in the directory: adl://chepraadls.azuredatalakestore.net/folder/folder%25202/NYCTripSmall.parquet without any issues.

When you say "However, spaces are not working and I get a 404: https://datalakename...net/folder/folder%202/filename.parquet (I've also tried it with an actual space).", could you please share more details on the error message with screenshot?
PRADEEPCHEEKATLA-MSFT 85,746 Reputation points Microsoft Employee

2021-09-20T05:49:54.163+00:00

Hello @Holomew ,

Just checking in if you have had a chance to see the previous response. We need the following information to understand/investigate this issue further.

Share via

Azure Data Lake to Power BI: Special Characters In Directories Causing Issues