Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, Could you help me to know why I have this kind of error and how can be solved?
Expression.SyntaxError: Token ')' expected.
Table.TransformColumns( #"Filtered Rows4",("AttachmentContent",each Excel.Workbook(_ true)))
thankyou
Solved! Go to Solution.
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.
Thank you very much for your help, I was abble 😀
Second parameter needs to be a list, identified by { and not (
I tried as well, but it does not work:
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
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.