Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi fellow PBIers,
First thing: I know there are several solutions to the Error in the Subject but none of them worked for me.
My problem is as follows:
#"AAMkADYzMmZiMmU5LTAzYzMtNGMzYS05MWIwLTg2ZGI2OTE3NGE5ZABGAAAAAACM8/gWvep/QZRIO1D6QBW8BwAjFkhrLDLaT66NTvauBkrRAADloYILAAAjFkhrLDLaT66NTvauBkrRAAG+e/lUAAA=" = #"Filtered Rows1"{[Id="AAMkADYzMmZiMmU5LTAzYzMtNGMzYS05MWIwLTg2ZGI2OTE3NGE5ZABGAAAAAACM8/gWvep/QZRIO1D6QBW8BwAjFkhrLDLaT66NTvauBkrRAADloYILAAAjFkhrLDLaT66NTvauBkrRAAG+e/lUAAA="]}[Attachments], AttachmentContent = #"AAMkADYzMmZiMmU5LTAzYzMtNGMzYS05MWIwLTg2ZGI2OTE3NGE5ZABGAAAAAACM8/gWvep/QZRIO1D6QBW8BwAjFkhrLDLaT66NTvauBkrRAADloYILAAAjFkhrLDLaT66NTvauBkrRAAG+e/lUAAA="{0}[AttachmentContent], #"Imported Excel" = Excel.Workbook(AttachmentContent),From my understanding the query looks to import from the mail with that exact id.
Thanks a lot in advance and kind regards,
Max
Solved! Go to Solution.
Okay, so I actually found a solution that works. Gonna leave this here too, in case anyone runs into the same problem:
To choose the attachment not based on the Email-ID (like it automatically does) you have to open the "Advanced Editor" in your Power Query and then replace the following code part:
#"AAMkADYzMmZiMmU5LTAzYzMtNGMzYS05MWIwLTg2ZGI2OTE3NGE5ZABGAAAAAACM8/gWvep/QZRIO1D6QBW8BwAjFkhrLDLaT66NTvauBkrRAADloYILAAAjFkhrLDLaT66NTvauBkrRAAG+e/lTAAA=" = #"Filtered Rows1"{[Id="AAMkADYzMmZiMmU5LTAzYzMtNGMzYS05MWIwLTg2ZGI2OTE3NGE5ZABGAAAAAACM8/gWvep/QZRIO1D6QBW8BwAjFkhrLDLaT66NTvauBkrRAADloYILAAAjFkhrLDLaT66NTvauBkrRAAG+e/lTAAA="]}[Attachments], AttachmentContent = #"AAMkADYzMmZiMmU5LTAzYzMtNGMzYS05MWIwLTg2ZGI2OTE3NGE5ZABGAAAAAACM8/gWvep/QZRIO1D6QBW8BwAjFkhrLDLaT66NTvauBkrRAADloYILAAAjFkhrLDLaT66NTvauBkrRAAG+e/lTAAA="{0}[AttachmentContent],
with:
#"SelectAttachment" = #"Filtered Rows1"{0}[Attachments], AttachmentContent = SelectAttachment{0}[AttachmentContent],
then your query will just open the attachment of the Email you filtered for (and ignore the ID)
kind regards, max
@Anonymous,
You may select Sort Descending and Keep Top Rows under Home tab.
@v-chuncz-msft thanks for the reply.
i currently perform the following actions before selecting the attachment:
i tried ur solution by only keeping one top row and then opening the attachment, but it still takes the attachment based on the email-id. not quite there yet.
Okay, so I actually found a solution that works. Gonna leave this here too, in case anyone runs into the same problem:
To choose the attachment not based on the Email-ID (like it automatically does) you have to open the "Advanced Editor" in your Power Query and then replace the following code part:
#"AAMkADYzMmZiMmU5LTAzYzMtNGMzYS05MWIwLTg2ZGI2OTE3NGE5ZABGAAAAAACM8/gWvep/QZRIO1D6QBW8BwAjFkhrLDLaT66NTvauBkrRAADloYILAAAjFkhrLDLaT66NTvauBkrRAAG+e/lTAAA=" = #"Filtered Rows1"{[Id="AAMkADYzMmZiMmU5LTAzYzMtNGMzYS05MWIwLTg2ZGI2OTE3NGE5ZABGAAAAAACM8/gWvep/QZRIO1D6QBW8BwAjFkhrLDLaT66NTvauBkrRAADloYILAAAjFkhrLDLaT66NTvauBkrRAAG+e/lTAAA="]}[Attachments], AttachmentContent = #"AAMkADYzMmZiMmU5LTAzYzMtNGMzYS05MWIwLTg2ZGI2OTE3NGE5ZABGAAAAAACM8/gWvep/QZRIO1D6QBW8BwAjFkhrLDLaT66NTvauBkrRAADloYILAAAjFkhrLDLaT66NTvauBkrRAAG+e/lTAAA="{0}[AttachmentContent],
with:
#"SelectAttachment" = #"Filtered Rows1"{0}[Attachments], AttachmentContent = SelectAttachment{0}[AttachmentContent],
then your query will just open the attachment of the Email you filtered for (and ignore the ID)
kind regards, max
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
94 | |
82 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |