Forum Discussion
Expression.SyntaxError: Token ')' expected.
If you only need that tab then you need to specify that.
I would recommend you click the Binary link for the first attachment and then examine the code that creates. Then replace the new steps by the appropriate sequence.
I want to connect PBI directly from outlook, that email contains two files one is excel file and the other one is PDF file.
In the next image,in the extension field, I have filtered by .xlsx, in AttachmentContent field is where I want to put this formula: Table.TransformColumns( #"Filtered Rows4",{"AttachmentContent",each Excel.Workbook(_ true)}) in order to see table instead of Binary.
I need to mention that the file I want to connect contains four tabs, I only need the yellow tab:
Is there another option to do this?
Thank you
Super UserIf you only need that tab then you need to specify that.
I would recommend you click the Binary link for the first attachment and then examine the code that creates. Then replace the new steps by the appropriate sequence.