Forum Discussion

Tokimatu's avatar
Tokimatu
New Member
7 years ago
Solved

error for log folder path

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 se...
Need Help
  • Tokimatu's avatar
    Tokimatu
    7 years ago

    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

     

     

v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

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's avatar
    Tokimatu
    New Member
    7 years ago

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

     

    Is there other procedure to get the long path?

    • Tokimatu's avatar
      Tokimatu
      New Member
      7 years ago

      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