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.
Super UserSecond parameter needs to be a list, identified by { and not (
I tried as well, but it does not work:
- lbendlin
Remove the "true" part.
What are you trying to accomplish?
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
- lbendlin
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.