Forum Discussion

Accokeekian's avatar
Accokeekian
Frequent Visitor
6 years ago

"Unexpected error" when reading sharepoint folder full of large text files using Dataflows

Hi there,   Excited for the new features of dataflows from the Nov 2019 update which allows the same "combine" files experience as in power query on desktop. Unfourtunately, when I attempt to load ...
dataflow
Need Help
fabo's avatar
fabo
Icon for Advocate III rankAdvocate III
6 years ago

Hi everyone.

I'm facing the same issue here.  I'm trying to combine Excel files from a Sharepoint folder, but when I try to expand the content I get the "unexpected error" message.  Has this been solved?  Is there a workaround?

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Greetings!

fabo 

  • Accokeekian's avatar
    Accokeekian
    Frequent Visitor
    6 years ago
    No resolution just yet. I have a support ticket in and we're working through the issue.

    Initially msft concluded that it was a file type issues but after testing that was deemed to not be the case. Your issue with Excel files contributes to that view.

    I'll link your comment to my case and keep you updated.
    • fabo's avatar
      fabo
      Icon for Advocate III rankAdvocate III
      6 years ago

      Thank you for replying Accokeekian .

       

      My Excel files have .xlsm extension so it doesn't seem to be the file type.  I leave you the mashup text, it might be useful somehow (translated from spanish):

       

       

      section Section1;
shared data_oferta_prog = let
  Source = SharePoint.Files("https://xxxxxxxxxxx.sharepoint.com/sites/xxxxxxxxxxx", [ApiVersion = 15]),
  #"Filtered rows" = Table.SelectRows(Source, each ([Extension] = ".xlsm")),
  #"Keep content" = Table.SelectColumns(#"Filtered rows", {"Content"}),
  #"Filtered hidden files" = Table.SelectRows(#"Keep content", each [Attributes]?[Hidden]? <> true)
in
  #"Filtered hidden files";
shared #"Example file" = let
  Source = SharePoint.Files("https://xxxxxxxxxxx.sharepoint.com/sites/xxxxxxxxxxx", [ApiVersion = 15]),
  #"Filtered rows" = Table.SelectRows(Source , each ([Extension] = ".xlsm")),
  #"Keep content" = Table.SelectColumns(#"Filtered rows", {"Content"}),
  #"Filtered hidden files" = Table.SelectRows(#"Keep content", each [Attributes]?[Hidden]? <> true),
  Navegation = #"Filtered hidden files"{0}[Content]
in
  Navegation;
shared Parameter = let
  Parameter = #"Example file" meta [IsParameterQuery = true, IsParameterQueryRequired = true, Type = type binary]
in
  Parameter;

       

       

      Thanks!

      • jmdh's avatar
        jmdh
        Icon for Advocate IV rankAdvocate IV
        6 years ago

        Hope this helps: I have faced the same issue many times.
        Now i prefer to use SharePoint.Contents instead of SharePoint.Files which is both easier to reach the files i want ie (their folder) and seems to work well.

        This unexpected error has started in may or June i believe and no one seems to have acknoledged it.

         

        I would love an extension to the API allowing to directly access a given folder.