Skip to content
Jess Panni By Jess Panni Principal I
Developing U-SQL: Local Data Folder

Those of you dabbling around with/in Azure Data Lake and Visual Studio will be aware that it is possible to run U-SQL scripts locally on your development machine. This is useful when developing and debugging scripts against small sets of data since you do not incur the overhead of submitting and running jobs up on Azure.

U-SQL can access data files stored locally on your development machine, however, Microsoft have recently changed the location of the local root data folder. This will effect anyone who installed Visual Studio Tools for Data Lake prior to 12th December 2015.

Discover your Power BI Maturity Score by taking our FREE 5 minute quiz.

For version 2.0.3000.0 the root data folder is:


And for versions greater than 2.0.4000.0 the folder you need is:


If in doubt, you can also find this location in Visual Studio:

  1. Open Server Explorer
  2. Select Azure/Data Lake Analytics/(local)
  3. Open the properties window (F4) and look for the DataRoot property.
Power BI Weekly is a collation of the week's top news and articles from the Power BI ecosystem, all presented to you in one, handy newsletter!

I hope this helps.

Jess Panni

Principal I

Jess Panni

Jess has over 25 years' experience helping companies succeed through the smart use of technology. He has spent most of his career working for leading Microsoft partners across the UK and Australia and is now Principal at endjin, working with clients to envision and execute disciplined innovation programmes.

Jess worked at endjin between 2015-2020.