none
DataFormat.Error - Details: Binary RRS feed

  • Question

  • Hi I have receive a the error "DataFormat.Error - Details: Binary", when I tried to refresh the file with the sources. I already tried to:

    - open the file in Excel directly to test if excel shows restricted Access message,.

    - Save As command to confirm whether "Save as type" is the Excel workbook format: (*.xlsx)

    Nothing works. Do you have any idea what it could be?

    Thanks in advance!

    Regards. Alberto.

    Friday, April 24, 2015 3:56 PM

Answers

  • Can you provide the following details about the origin of the Excel file:

    • How was it created?
      • Excel version?
      • Web service?
    • Is the file password protected?
    • Does the file contain anything other than data, e.g.:
      • Does the file contain any VBA or macros?
      • Does the file contain any connections?
      • Does the file contain any charts, pivot tables or PowerView sheets?
      • Does the file contain a data model?
    • Can you create a similar file with fake data in it that exhibits the problem?

    Thanks, Hadeel


    Thursday, April 30, 2015 8:31 PM

All replies

  • There really isn't enough information here to speculate. Consider using "Send a Frown" as that will at least show us the queries and data sources you're using.
    Sunday, April 26, 2015 11:15 PM
  • Hi, I alreasy send it. Below details:



    Feedback Type:

    Frown



    Timestamp:

    2015-04-27T13:18:37.6249896Z



    Product Version:

    2.21.3974.242 (Release-V2-Public) (x64)



    Excel Version:

    15.0.4693.1000



    Excel Install Location:

    C:\Program Files\Microsoft Office\Office15\EXCEL.EXE



    IE Version:

    11.0.9600.17631



    OS Version:

    Microsoft Windows NT 6.2.9200.0 (x64 en-US)



    CLR Version:

    4.0.30319.34014



    User ID:

    bb0544bd-c0ad-4de0-b3e1-58d1ef16cf94



    Workbook Package Info:

    1* - en-US, fastCombine: Disabled.



    Working set:

    454 MB



    Peak Virtual Memory:

    2.15 GB



    Screenshot:

    <v:shapetype coordsize="21600,21600" filled="f" id="_x0000_t75" o:preferrelative="t" o:spt="75" path="m@4@5l@4@11@9@11@9@5xe" stroked="f">
     <v:stroke joinstyle="miter">
    <v:formulas>  <v:f eqn="if lineDrawn pixelLineWidth 0">
      <v:f eqn="sum @0 1 0">
      <v:f eqn="sum 0 0 @1">
      <v:f eqn="prod @2 1 2">
      <v:f eqn="prod @3 21600 pixelWidth">
      <v:f eqn="prod @3 21600 pixelHeight">
      <v:f eqn="sum @0 0 1">
      <v:f eqn="prod @6 1 2">
      <v:f eqn="prod @7 21600 pixelWidth">
      <v:f eqn="sum @8 21600 0">
      <v:f eqn="prod @7 21600 pixelHeight">
      <v:f eqn="sum @10 21600 0">
     </v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:f></v:formulas>
     <v:path gradientshapeok="t" o:connecttype="rect" o:extrusionok="f">
     <o:lock aspectratio="t" v:ext="edit">
    </o:lock></v:path></v:stroke></v:shapetype><v:shape alt="" id="Picture_x0020_1" o:spid="_x0000_i1025" style="width:1036.5pt;height:558pt;" type="#_x0000_t75">
    <v:imagedata o:href="cid:image001.jpg@01D080D3.9CB3ACA0" src="file:///C:\Users\salasaw\AppData\Local\Temp\msohtmlclip1\01\clip_image001.jpg">
    </v:imagedata></v:shape>



    Formulas:





    section Section1;



    shared AR = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_AR.xlsx")),

    TDSheet_Sheet =
    Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),
    #"First Row as Header" = Table.PromoteHeaders(#"Removed Top Rows"),

    #"Removed Columns" = Table.RemoveColumns(#"First Row as
    Header",{"Column2", "Column4", "Column6"}),

    #"Changed Type with Locale" =
    Table.TransformColumnTypes(#"Removed Columns", {{"The
    period", type date}}, "es-AR"),

    #"Changed Type" = Table.TransformColumnTypes(#"Changed Type with
    Locale",{{"Ex.rate", type number}, {"Payment", type
    number}, {"COGS", type number}, {"Payment percent", type
    number}, {"Overpayment", type number}, {"Payment, USD",
    type number}, {"COGS, USD", type number}, {"Overpayment
    man", type number}, {"Margin, USD", type number}}),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed
    Type",1)

    in

    #"Removed Bottom Rows";



    shared CH = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_CH.xlsx")),

    TDSheet_Sheet =
    Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),

    #"First Row as Header" = Table.PromoteHeaders(#"Removed Top
    Rows"),

    #"Changed Type with Locale" = Table.TransformColumnTypes(#"First
    Row as Header", {{"The period", type date}}, "es-AR"),

    #"Removed Columns" = Table.RemoveColumns(#"Changed Type with
    Locale",{"Column2", "Column4", "Column7"}),

    #"Changed Type" = Table.TransformColumnTypes(#"Removed
    Columns",{{"Ex.rate", type number}, {"Payment", type
    number}, {"COGS", type number}, {"Payment percent", type
    number}, {"Overpayment", type number}, {"Payment, USD",
    type number}, {"COGS, USD", type number}, {"Overpayment
    man", type number}, {"Margin, USD", type number}}),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed
    Type",1)

    in

    #"Removed Bottom Rows";



    shared #"1C LATAM" = let

    Source = Table.Combine({AR,CH,CO,CR,PE,US,VE,BR}),

    #"Filtered Rows" = Table.SelectRows(Source, each true)

    in

    #"Filtered Rows";



    shared CO = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_CO.xlsx")),

    TDSheet_Sheet = Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),

    #"First Row as Header1" = Table.PromoteHeaders(#"Removed Top
    Rows"),

    #"Removed Columns" = Table.RemoveColumns(#"First Row as
    Header1",{"Column2", "Column4", "Column7"}),

    #"Changed Type with Locale" =
    Table.TransformColumnTypes(#"Removed Columns", {{"The
    period", type date}}, "es-AR"),

    #"Changed Type" = Table.TransformColumnTypes(#"Changed Type with
    Locale",{{"Ex.rate", type number}, {"Payment", type
    number}, {"COGS", type number}, {"Payment percent", type
    number}, {"Overpayment", type number}, {"Payment, USD",
    type number}, {"COGS, USD", type number}, {"Overpayment
    man", type number}, {"Margin, USD", type number}}),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed
    Type",1)

    in

    #"Removed Bottom Rows";



    shared CR = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_CR.xlsx")),

    TDSheet_Sheet =
    Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),

    #"First Row as Header1" = Table.PromoteHeaders(#"Removed Top
    Rows"),

    #"Changed Type with Locale" = Table.TransformColumnTypes(#"First
    Row as Header1", {{"The period", type date}},
    "es-AR"),

    #"Removed Columns" = Table.RemoveColumns(#"Changed Type with
    Locale",{"Column2", "Column4", "Column6"}),

    #"Changed Type" = Table.TransformColumnTypes(#"Removed
    Columns",{{"Ex.rate", type number}, {"Payment", type
    number}, {"COGS", type number}, {"Payment percent", type
    number}, {"Overpayment", type number}, {"Payment, USD",
    type number}, {"COGS, USD", type number}, {"Overpayment
    man", type number}, {"Margin, USD", type number}}),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed
    Type",1)

    in

    #"Removed Bottom Rows";



    shared PE = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_PE.xlsx")),

    TDSheet_Sheet = Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),

    #"First Row as Header1" = Table.PromoteHeaders(#"Removed Top
    Rows"),

    #"Removed Columns" = Table.RemoveColumns(#"First Row as
    Header1",{"Column2", "Column4", "Column7"}),

    #"Changed Type with Locale" =
    Table.TransformColumnTypes(#"Removed Columns", {{"The
    period", type date}}, "es-AR"),

    #"Changed Type" = Table.TransformColumnTypes(#"Changed Type with
    Locale",{{"Ex.rate", type number}, {"Payment", type
    number}, {"COGS", type number}, {"Payment percent", type
    number}, {"Overpayment", type number}, {"Payment, USD",
    type number}, {"COGS, USD", type number}, {"Overpayment
    man", type number}, {"Margin, USD", type number}}),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed
    Type",1)

    in

    #"Removed Bottom Rows";



    shared US = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_US.xlsx")),

    TDSheet_Sheet =
    Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),

    #"First Row as Header1" = Table.PromoteHeaders(#"Removed Top
    Rows"),

    #"Removed Columns" = Table.RemoveColumns(#"First Row as
    Header1",{"Column2", "Column4", "Column7"}),

    #"Changed Type with Locale" =
    Table.TransformColumnTypes(#"Removed Columns", {{"The
    period", type date}}, "es-AR"),

    #"Changed Type" = Table.TransformColumnTypes(#"Changed Type with
    Locale",{{"Ex.rate", type number}, {"Payment", type
    number}, {"COGS", type number}, {"Payment percent", type
    number}, {"Overpayment", type number}, {"Payment, USD",
    type number}, {"COGS, USD", type number}, {"Overpayment
    man", type number}, {"Margin, USD", type number}}),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed
    Type",1)

    in

    #"Removed Bottom Rows";



    shared VE = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_VE.xlsx")),

    TDSheet_Sheet =
    Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),

    #"Removed Columns" = Table.RemoveColumns(#"Removed Top
    Rows",{"Column2", "Column3", "Column6"}),

    #"First Row as Header1" = Table.PromoteHeaders(#"Removed
    Columns"),

    #"Changed Type with Locale" = Table.TransformColumnTypes(#"First
    Row as Header1", {{"The period", type date}},
    "es-AR"),

    #"Changed Type" = Table.TransformColumnTypes(#"Changed Type with
    Locale",{{"Ex.rate", type number}, {"Payment", type
    number}, {"COGS", type number}, {"Payment percent", type
    number}, {"Overpayment", type number}, {"Payment, USD",
    type number}, {"COGS, USD", type number}, {"Overpayment
    man", type number}, {"Margin, USD", type number}}),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed
    Type",1)

    in

    #"Removed Bottom Rows";



    shared BR = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_BR.xlsx")),

    TDSheet_Sheet =
    Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),

    #"First Row as Header1" = Table.PromoteHeaders(#"Removed Top
    Rows"),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"First Row as
    Header1",1),

    #"Changed Type" = Table.TransformColumnTypes(#"Removed Bottom
    Rows",{{"Ex.rate", type number}, {"Payment", type
    number}, {"Payment, USD", type number}, {"COGS, USD", type
    number}, {"Margin, USD", type number}}),

    #"Changed Type with Locale" =
    Table.TransformColumnTypes(#"Changed Type", {{"Payment,
    USD", type number}, {"COGS, USD", type number}, {"Margin,
    USD", type number}}, "es-AR"),

    #"Changed Type with Locale1" =
    Table.TransformColumnTypes(#"Changed Type with Locale", {{"The

    period", type date}}, "es-AR"),

    #"Removed Columns" = Table.RemoveColumns(#"Changed Type with
    Locale1",{"Column2"})

    in

    #"Removed Columns";<o:p></o:p>



    Alberto Salas

    Monday, April 27, 2015 1:21 PM
  • Which query in the workbook about is giving you this error?
    Monday, April 27, 2015 4:50 PM
    Moderator
  • The workbook  is AR

    Alberto Salas

    Monday, April 27, 2015 5:20 PM
  • Hi Alberto,
    There are many queries within your AR workbook. If you look at all the queries in your workbook, could you tell which one returns an error when you refresh?


    Thanks, Hadeel


    Tuesday, April 28, 2015 1:48 AM
  • Hi Haddel, The error message is "DataFormat.Error" - Details: Binary

    Alberto Salas

    Tuesday, April 28, 2015 12:44 PM
  • I understand but which query in your workbook produces that error?

    Thanks, Hadeel

    Wednesday, April 29, 2015 7:56 PM
  • Hi Hadeel, the workbook is :

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_AR.xlsx")),


    Alberto Salas

    Thursday, April 30, 2015 2:44 PM
  • In PowerQuery tab there is a button called 'About' Can you click on it and see which version are you using? Also, check for updates and see if updating to the latest version would solve the problem.

    Unfortunately we can't tell what's wrong without being able to repro the problem on our end and that will require access to your excel file, so we will mark that as a last resort if update doesn't fix the problem.


    Thanks, Hadeel

    Thursday, April 30, 2015 4:53 PM
  • This is the version: 2.21.3974.242

    I couldn´t find if this is the lastest version.


    Alberto Salas

    Thursday, April 30, 2015 5:01 PM
  • Yes that's it. Would it be possible to share your workbook and the Excel file you use it as a source with us? As long as it doesn't contain private or sensitive data that you are not in liberty of sharing it. If so, Please use the Send a Frown button and attach your workbook an excel file. We will get an email to look into it.

    Thanks, Hadeel

    Thursday, April 30, 2015 5:49 PM
  • Yes, It contain private date. I am not able to attach the email. Below you will see the frown message:

    Feedback Type:

    Frown



    Timestamp:

    2015-04-27T13:18:37.6249896Z



    Product Version:

    2.21.3974.242 (Release-V2-Public) (x64)



    Excel Version:

    15.0.4693.1000



    Excel Install Location:

    C:\Program Files\Microsoft Office\Office15\EXCEL.EXE



    IE Version:

    11.0.9600.17631



    OS Version:

    Microsoft Windows NT 6.2.9200.0 (x64 en-US)



    CLR Version:

    4.0.30319.34014



    User ID:

    bb0544bd-c0ad-4de0-b3e1-58d1ef16cf94



    Workbook Package Info:

    1* - en-US, fastCombine: Disabled.



    Working set:

    454 MB



    Peak Virtual Memory:

    2.15 GB



    Screenshot:

    <v:shapetype coordsize="21600,21600" filled="f" id="_x0000_t75" o:preferrelative="t" o:spt="75" path="m@4@5l@4@11@9@11@9@5xe" stroked="f">
    <v:stroke joinstyle="miter">
     <v:formulas>
    </v:formulas></v:stroke></v:shapetype>


    Formulas:


    section Section1;



    shared AR = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_AR.xlsx")),

    TDSheet_Sheet =
    Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),
    #"First Row as Header" = Table.PromoteHeaders(#"Removed Top Rows"),

    #"Removed Columns" = Table.RemoveColumns(#"First Row as
    Header",{"Column2", "Column4", "Column6"}),

    #"Changed Type with Locale" =
    Table.TransformColumnTypes(#"Removed Columns", {{"The
    period", type date}}, "es-AR"),

    #"Changed Type" = Table.TransformColumnTypes(#"Changed Type with
    Locale",{{"Ex.rate", type number}, {"Payment", type number},
    {"COGS", type number}, {"Payment percent", type number},
    {"Overpayment", type number}, {"Payment, USD", type
    number}, {"COGS, USD", type number}, {"Overpayment man",
    type number}, {"Margin, USD", type number}}),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed
    Type",1)

    in

    #"Removed Bottom Rows";



    shared CH = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_CH.xlsx")),

    TDSheet_Sheet =
    Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),

    #"First Row as Header" = Table.PromoteHeaders(#"Removed Top
    Rows"),

    #"Changed Type with Locale" = Table.TransformColumnTypes(#"First
    Row as Header", {{"The period", type date}}, "es-AR"),

    #"Removed Columns" = Table.RemoveColumns(#"Changed Type with
    Locale",{"Column2", "Column4", "Column7"}),

    #"Changed Type" = Table.TransformColumnTypes(#"Removed
    Columns",{{"Ex.rate", type number}, {"Payment", type
    number}, {"COGS", type number}, {"Payment percent", type
    number}, {"Overpayment", type number}, {"Payment, USD",
    type number}, {"COGS, USD", type number}, {"Overpayment
    man", type number}, {"Margin, USD", type number}}),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed
    Type",1)

    in

    #"Removed Bottom Rows";



    shared #"1C LATAM" = let

    Source = Table.Combine({AR,CH,CO,CR,PE,US,VE,BR}),

    #"Filtered Rows" = Table.SelectRows(Source, each true)

    in

    #"Filtered Rows";



    shared CO = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_CO.xlsx")),

    TDSheet_Sheet =
    Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),

    #"First Row as Header1" = Table.PromoteHeaders(#"Removed Top
    Rows"),

    #"Removed Columns" = Table.RemoveColumns(#"First Row as
    Header1",{"Column2", "Column4", "Column7"}),

    #"Changed Type with Locale" = Table.TransformColumnTypes(#"Removed
    Columns", {{"The period", type date}}, "es-AR"),

    #"Changed Type" = Table.TransformColumnTypes(#"Changed Type with
    Locale",{{"Ex.rate", type number}, {"Payment", type
    number}, {"COGS", type number}, {"Payment percent", type
    number}, {"Overpayment", type number}, {"Payment, USD",
    type number}, {"COGS, USD", type number}, {"Overpayment
    man", type number}, {"Margin, USD", type number}}),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed
    Type",1)

    in

    #"Removed Bottom Rows";



    shared CR = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_CR.xlsx")),

    TDSheet_Sheet =
    Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),

    #"First Row as Header1" = Table.PromoteHeaders(#"Removed Top
    Rows"),

    #"Changed Type with Locale" = Table.TransformColumnTypes(#"First
    Row as Header1", {{"The period", type date}},
    "es-AR"),

    #"Removed Columns" = Table.RemoveColumns(#"Changed Type with
    Locale",{"Column2", "Column4", "Column6"}),

    #"Changed Type" = Table.TransformColumnTypes(#"Removed
    Columns",{{"Ex.rate", type number}, {"Payment", type
    number}, {"COGS", type number}, {"Payment percent", type
    number}, {"Overpayment", type number}, {"Payment, USD",
    type number}, {"COGS, USD", type number}, {"Overpayment
    man", type number}, {"Margin, USD", type number}}),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed
    Type",1)

    in

    #"Removed Bottom Rows";



    shared PE = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_PE.xlsx")),

    TDSheet_Sheet = Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),

    #"First Row as Header1" = Table.PromoteHeaders(#"Removed Top
    Rows"),

    #"Removed Columns" = Table.RemoveColumns(#"First Row as
    Header1",{"Column2", "Column4", "Column7"}),

    #"Changed Type with Locale" = Table.TransformColumnTypes(#"Removed
    Columns", {{"The period", type date}}, "es-AR"),

    #"Changed Type" = Table.TransformColumnTypes(#"Changed Type with
    Locale",{{"Ex.rate", type number}, {"Payment", type
    number}, {"COGS", type number}, {"Payment percent", type
    number}, {"Overpayment", type number}, {"Payment, USD",
    type number}, {"COGS, USD", type number}, {"Overpayment
    man", type number}, {"Margin, USD", type number}}),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed
    Type",1)

    in

    #"Removed Bottom Rows";



    shared US = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_US.xlsx")),

    TDSheet_Sheet =
    Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),

    #"First Row as Header1" = Table.PromoteHeaders(#"Removed Top Rows"),

    #"Removed Columns" = Table.RemoveColumns(#"First Row as
    Header1",{"Column2", "Column4", "Column7"}),

    #"Changed Type with Locale" =
    Table.TransformColumnTypes(#"Removed Columns", {{"The
    period", type date}}, "es-AR"),

    #"Changed Type" = Table.TransformColumnTypes(#"Changed Type with
    Locale",{{"Ex.rate", type number}, {"Payment", type
    number}, {"COGS", type number}, {"Payment percent", type
    number}, {"Overpayment", type number}, {"Payment, USD",
    type number}, {"COGS, USD", type number}, {"Overpayment man",
    type number}, {"Margin, USD", type number}}),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed
    Type",1)

    in

    #"Removed Bottom Rows";



    shared VE = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_VE.xlsx")),

    TDSheet_Sheet = Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),

    #"Removed Columns" = Table.RemoveColumns(#"Removed Top
    Rows",{"Column2", "Column3", "Column6"}),

    #"First Row as Header1" = Table.PromoteHeaders(#"Removed
    Columns"),

    #"Changed Type with Locale" = Table.TransformColumnTypes(#"First
    Row as Header1", {{"The period", type date}},
    "es-AR"),

    #"Changed Type" = Table.TransformColumnTypes(#"Changed Type with
    Locale",{{"Ex.rate", type number}, {"Payment", type
    number}, {"COGS", type number}, {"Payment percent", type
    number}, {"Overpayment", type number}, {"Payment, USD",
    type number}, {"COGS, USD", type number}, {"Overpayment
    man", type number}, {"Margin, USD", type number}}),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"Changed
    Type",1)

    in

    #"Removed Bottom Rows";



    shared BR = let

    Source = Excel.Workbook(File.Contents("C:\1Creports\1C_BR.xlsx")),

    TDSheet_Sheet =
    Source{[Item="TDSheet",Kind="Sheet"]}[Data],

    #"Removed Top Rows" = Table.Skip(TDSheet_Sheet,9),

    #"First Row as Header1" = Table.PromoteHeaders(#"Removed Top
    Rows"),

    #"Removed Bottom Rows" = Table.RemoveLastN(#"First Row as
    Header1",1),

    #"Changed Type" = Table.TransformColumnTypes(#"Removed Bottom
    Rows",{{"Ex.rate", type number}, {"Payment", type
    number}, {"Payment, USD", type number}, {"COGS, USD", type
    number}, {"Margin, USD", type number}}),

    #"Changed Type with Locale" =
    Table.TransformColumnTypes(#"Changed Type", {{"Payment,
    USD", type number}, {"COGS, USD", type number}, {"Margin,
    USD", type number}}, "es-AR"),

    #"Changed Type with Locale1" =
    Table.TransformColumnTypes(#"Changed Type with Locale", {{"The
    period", type date}}, "es-AR"),

    #"Removed Columns" = Table.RemoveColumns(#"Changed Type with
    Locale1",{"Column2"})

    in

    #"Removed Columns";<o:p></o:p>



    Alberto Salas

    Thursday, April 30, 2015 6:54 PM
  • Does the workbook C:\1Creports\1C_AR.xlsx gets opened correctly in excel?

    Thanks, Hadeel

    Thursday, April 30, 2015 7:03 PM
  • Yes.

    Alberto Salas

    Thursday, April 30, 2015 7:05 PM
  • Can you provide the following details about the origin of the Excel file:

    • How was it created?
      • Excel version?
      • Web service?
    • Is the file password protected?
    • Does the file contain anything other than data, e.g.:
      • Does the file contain any VBA or macros?
      • Does the file contain any connections?
      • Does the file contain any charts, pivot tables or PowerView sheets?
      • Does the file contain a data model?
    • Can you create a similar file with fake data in it that exhibits the problem?

    Thanks, Hadeel


    Thursday, April 30, 2015 8:31 PM

    Alberto Salas

    Thursday, May 7, 2015 1:49 AM
  • Hi, 

    I've got the same error: Excel file can not be opened. 

    Feedback Type:
    Frown

    Timestamp:
    2015-05-13T06:51:15.1443917Z

    Product Version:
    2.21.3974.242 (Release-V2-Public) (x64)

    Excel Version:
    15.0.4701.1001

    Excel Install Location:
    C:\Program Files\Microsoft Office\Office15\EXCEL.EXE

    IE Version:
    11.0.9600.17633

    OS Version:
    Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 ru-RU)

    CLR Version:
    4.0.30319.18444

    User ID:
    89a363ba-9f4e-4409-8312-dd2852294d4e

    Workbook Package Info:
    1* - en-US, fastCombine: Enabled.

    Working set:
    350 MB

    Peak Virtual Memory:
    1.96 GB


    Formulas:


    section Section1;

    shared #"2014" = let
    Source = Excel.Workbook(File.Contents("2014.xlsx"))
    in
    Source;<o:p></o:p>


    Wednesday, May 13, 2015 7:02 AM
  • Could you click send a frown then attach the file that doesn't have sensitive data and click send so we can investigate this more :)?

    Thanks, Hadeel

    Wednesday, May 13, 2015 8:26 PM
  • Hi Haddel, I already send it. See the last comments

    Alberto Salas

    Wednesday, May 13, 2015 8:38 PM
  • I mean send it to the feedback email that gets generated when you click the send a frown button.

    Thanks, Hadeel

    Wednesday, May 13, 2015 10:26 PM
  • Yes , I sent it. I copied the results here. But the feedback email was sent.

    Alberto Salas

    Thursday, May 14, 2015 9:58 AM
  • Alright, will look into it :)

    Thanks, Hadeel

    Thursday, May 14, 2015 4:46 PM
  • Hi Hadeel, was this issue resolved? I am having the exact same issue. Thank you
    Friday, June 12, 2020 4:10 PM