none
Copy/Paste Query Code from PowerBI Desktop UI to Dataflow RRS feed

  • Question

  • Hi,

    I'm following Miguel Escobar "Combine or Append Data: Optimal Combination Pattern".

    Everything works fine when using the code in the PowerBI Desktop, but when trying to copy/paste the code to new dataflow entity I'm getting error.

    Code:

    let
    fnCSV_Read = (MyFile as binary) => 
    Table.PromoteHeaders(Csv.Document(MyFile, [Delimiter=",", Columns=4, Encoding=1255, QuoteStyle=QuoteStyle.None]))
    in
    let
        Source = Folder.Files("C:\Users\Matan\Desktop\Sales"),
        #"Removed Other Columns" = Table.SelectColumns(Source,{"Content"}),
        Content = List.Transform(#"Removed Other Columns"[Content],Binary.Buffer),
        Custom1 = List.Transform(Content,fnCSV_Read),
        Custom2 = Table.Combine(Custom1)
    in
        Custom2
    Wednesday, February 19, 2020 8:48 AM

Answers

All replies

  • Hi Matan. What's the error you're getting?

    Ehren

    Wednesday, February 19, 2020 11:29 PM
    Owner
  • This is the problem,

    I'm not getting any detailed on the error except of "Validating Queries: Query "Query" has an error"

    I can't post the error image because my account not verified.

    Saturday, February 22, 2020 7:40 PM
  • Hi Matan.

    Regardless of the error that appears with "Validating queries", does your query return an error, or is it evaluated correctly in the Preview?

    Angelo


    Angelo Mollame (MSFT)

    Thursday, February 27, 2020 10:18 AM