Solved: error for log folder path

Tokimatu · ‎01-22-2019

When I import the data from folder on file server that has deep folder nest, it returns OLE DB or ODBC error: [DataFormat.Error]. These are many over 200 length path. Anyway I want to analyze file server. How can I read all files, its path, size and others from our file server?

Tokimatu · ‎01-23-2019

Data reading was inturrupted when I got the error importing the data from folder.

I use powershell script as below without intrrupting by error.

get-childitem \\fileserver\path -recurse | where-object{! $_.psiscontainer}| select-object
CreationTime,LastAccessTime,LastWriteTime,length, extension,name,directory | export-csv c:\outputfolder\data.csv -encoding UTF8

View solution in original post

v-juanli-msft · ‎01-22-2019

Hi @Tokimatu

Do you get data from Folder in Power BI Desktop?

It seems your path length is larger than the maximum which it can run with.

Best Regards

Maggie

Tokimatu · ‎01-22-2019

Yes. I got the data from Folder in Power BI Desktop.

Is there other procedure to get the long path?

Tokimatu · ‎01-23-2019

Data reading was inturrupted when I got the error importing the data from folder.

I use powershell script as below without intrrupting by error.

get-childitem \\fileserver\path -recurse | where-object{! $_.psiscontainer}| select-object
CreationTime,LastAccessTime,LastWriteTime,length, extension,name,directory | export-csv c:\outputfolder\data.csv -encoding UTF8