ADGraphEntityOperationFailed error in Paginated report dynamic subscription

[Anonymous]

Hi , we experienced Power BI Paginated Report Dynamic Subscription returning below errors since 16th Jan 24:
0]Microsoft.PowerBI.Common.HttpClientRequestFailedException: Http client GET request to <pi>https://graph.microsoft.com/v1.0/groups?$filter=mail+in+(%27</pi> failed with BadRequest. ExceptionCorrelation=3997649580904037225.0 CreationActivityStackString=Activity stack: [CPJD > EMIS > EMIS > EMSP > GGGN > GSDO] ... StatusCode=BadRequest ExceptionCulprit=System at Microsoft.PowerBI.CommonUtilities.Web.MonitoredHttpClient.AsyncHttpCommandBase.<EnsureResponseStatusCodeIndicatesSuccess>d__9.MoveNext() in  :\\Sql\CloudBI\AS\src\PowerBi\CommonUtilitiesHttpClient\MonitoredHttpClient.cs:line 365 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw() at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task) at Microsoft.PowerBI.CommonUtilities.Web.MonitoredHttpClient.AsyncHttpCommand`1.<Run>d__21.MoveNext() in .

Do you know the root cause? 

Thanks,

[Anonymous · Accepted solution]

I've found the issue is with there an apostrophe in the email address, for e.g., Firstname.O'Kay@.... 

[Anonymous]

Hi @Anonymous ,

Please check the following points:

Mismatched Parameter Names: One possible reason for the error is that the subreport does not have the same parameter name as the master report. You need to make sure that the parameter name in the subreport matches the parameter name in the master report, and that the parameter value is passed correctly from the master report to the subreport.

Incorrect Parameter Values: Make sure you select your values and run your report prior to creating your subscription to ensure the correct parameter values are captured.

Recipient Data Issues: When setting up a dynamic subscription, you need to select a Power BI dataset that contains your recipient data (i.e., email address, respective parameters). If there’s an issue with the recipient data or the mapping between recipients and parameters, it could lead to errors.

Create a dynamic subscription for a paginated report (Preview) - Power BI | Microsoft Learn

Hope it helps!

Best regards,
Community Support Team_ Scott Chang

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.