Forum Discussion
"Unexpected error" when reading sharepoint folder full of large text files using Dataflows
Advocate IIIThank 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!
Advocate IVHope 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.
- fabo
Hi jmdh , thank you for your suggestion.
Unfortunately, it didn't workout for me. I can summarize the steps for both methods as followed:
Using SharePoint.Files
1. Source = SharePoint.Files("https://xxxxx.sharepoint.com/sites/xxxxx", [ApiVersion = 15])
2. #"Keep Content" = Table.SelectColumns(Source ,{"Content"})
Using SharePoint.Contents
1. Source = SharePoint.Contents("https://xxxxx.sharepoint.com/sites/xxxxx", [ApiVersion = 15])
2. #"Shared Documents" = Source{[Name="Shared Documents"]}[Content]
3. Data = #"Shared Documents"{[Name="Data"]}[Content]4. #"Keep Content" = Table.SelectColumns(Data ,{"Content"})
With both approaches I come to the same next step: combine files (expand the content), selecting the two down arrows next to the field name Content.
That's the point where I get this unexpected error, no matter which of the previous functions I use.