Forum Discussion

jpcrjbball's avatar
jpcrjbball
Regular Visitor
4 years ago

Content column will not expand into transform file, independent of file/file type

All,

I apologize if my terminologies are inccorect.

 

For about 4 months now, our company has been using power query/dataflows. We expand mostly csv files and have succesfully for awhile now. About 8-10 days ago we became unable to expand the content column and create a "Sample file".

 

When we click the down arrows in the content column, we get this error.

 

This error is independent of the file. We have tried multiple csv files and text files of different formats. We are continually getting this error. The queries/dataflows that are currrently built and utilize this function, are refreshing fine. We are not able to build any new queries/dataflows with new sources.

 

The expand table function works fine in the desktop app for the same exact csv/text files. We are accessing an azure blob storage container and this also works fine for already built dataflows and for the desktop app.

 

This seems to be an issue isolated to power query/dataflows. We are trying to find workarounds, but have had no luck so far. 

 

It is very strange to us that the exact process has worked for months and all of the sudden, the exact same code from the advanced editor will not accomplish what it previous has. 

 

Thank you for any time and effort you expaend helping us out.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Can you post the Mashup Text?

     

    --Nate

    • jpcrjbball's avatar
      jpcrjbball
      Regular Visitor
      4 years ago

       

      section Section1;
      shared XXX = let
      Source = AzureStorage.Blobs("XXX"),
      Navigation = Source{[Name = "XXX"]}[Data],
      #"Split column by delimiter" = Table.SplitColumn(Navigation, "Name", Splitter.SplitTextByEachDelimiter({"/"}, QuoteStyle.Csv), {"Name.1", "Name.2"}),
      #"Filtered rows" = Table.SelectRows(#"Split column by delimiter", each [Name.1] = "Files"),
      #"Filtered hidden files" = Table.SelectRows(#"Filtered rows", each [Attributes]?[Hidden]? <> true)
      in
      #"Filtered hidden files";
      shared #"Sample file" = let
      Source = AzureStorage.Blobs("XXX"),
      Navigation = Source{[Name = "XXX"]}[Data],
      #"Split column by delimiter" = Table.SplitColumn(Navigation, "Name", Splitter.SplitTextByEachDelimiter({"/"}, QuoteStyle.Csv), {"Name.1", "Name.2"}),
      #"Filtered rows" = Table.SelectRows(#"Split column by delimiter", each [Name.1] = "Files"),
      #"Filtered hidden files" = Table.SelectRows(#"Filtered rows", each [Attributes]?[Hidden]? <> true),
      #"Navigation 1" = #"Filtered hidden files"{0}[Content]
      in
      #"Navigation 1";
      shared Parameter = let
      Parameter = #"Sample file" meta [IsParameterQuery = true, IsParameterQueryRequired = true, Type = type binary, BinaryIdentifier = #"Sample file"]
      in
      Parameter;
      shared #"Transform Sample file" = let
      Source = Csv.Document(Parameter, [Delimiter = ",", Columns = 1, Encoding = 65001, QuoteStyle = QuoteStyle.None]),
      #"Promoted headers" = Table.PromoteHeaders(Source, [PromoteAllScalars = true]),
      #"Changed column type" = Table.TransformColumnTypes(#"Promoted headers", {{"RPMBIN", Int64.Type}})
      in
      #"Changed column type";