topic Re: Report Schedule error: Resource name and Location need to match in Report Server

Report Schedule error: Resource name and Location need to match

bobjSrikanth — Thu, 09 Dec 2021 06:42:26 GMT

Hi There,

I have schedule a report in report server it got failed and thrown below error. Could you please help me in understanding the issue.

[0] -1055784932: Resource name and Location need to match. Resource name: SME LP DATE. Location: PolicyBased_36686F87_B3FA_4760_A613_9C6D47A37170.. The exception was raised by the IDbCommand interface.

[1] -1055129594: The current operation was cancelled because another operation in the transaction failed.
[2] -1055784932: The command has been canceled.. The exception was raised by the IDbCommand interface.

Re: Report Schedule error: Resource name and Location need to match

Icey — Mon, 13 Dec 2021 07:24:20 GMT

Hi bobjSrikanth ,

Could you share me more details?

1. What's your data source and connection type?

2. Does this report work before?

3. How about creating a new one?

4. Only this report has the issue or all of your reports have this issue?

5. What's your Power BI Report Server and Power BI Desktop (Optimized for Report Server) version? Can the latest version work for you?

Best Regards,

Icey

Re: Report Schedule error: Resource name and Location need to match

bobjSrikanth — Mon, 13 Dec 2021 08:34:24 GMT

Hi Icey,

Thank you for your reply, please find the details below.

1. What's your data source and connection type?

SQL server import query

2. Does this report work before?

This is very first time we are scheduling (new environment).

3. How about creating a new one?

All reports are having same issue.

4. Only this report has the issue or all of your reports have this issue?

All reports.

5. What's your Power BI Report Server and Power BI Desktop (Optimized for Report Server) version? Can the latest version work for you?

We are using September release PBI RS and pb desktop tool( optimised for rs September version). Using desktop tool I'm able to refresh the report.

Thanks and regards,

Srikanth

Re: Report Schedule error: Resource name and Location need to match

bobjSrikanth — Tue, 14 Dec 2021 07:47:59 GMT

Hi,

and also other report having below error. For your information we have developed these reports using Power BI desktop version(Services) and reopened and uploaded to server using PBI desktop(Optimized for server).

If this is the problem is there any workaround to resolve the issue?

Kindly help me by provideing solution.

Error:

1056505856: COM error: Microsoft.PowerBI.ReportServer.ASEngineManagedRoot, V1 models are not supported by V3 execution framework..

Thanks,

Srikanth M

Re: Report Schedule error: Resource name and Location need to match

Icey — Thu, 16 Dec 2021 09:59:05 GMT

Hi bobjSrikanth ,

For your information we have developed these reports using Power BI desktop version(Services) and reopened and uploaded to server using PBI desktop(Optimized for server).

Please don't use the normal PBI Desktop (Service) for creating reports running in Power BI Report Server. It is suggested to ALWAYS use the version of Power BI Desktop (Optimized for Report Server) that matches your Report Server version.

Then, please refer to this document to use tools for troubleshooting.

Logs relevant for scheduled refresh of Power BI reports
Enabling Verbose Logging
ExecutionLog

For your data security, please don't share your log here.

Best Regards,

Icey

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

Re: Report Schedule error: Resource name and Location need to match

bobjSrikanth — Thu, 16 Dec 2021 10:25:35 GMT

Hi Icey,

we have developed these reports in PBI desktop(service) and the same set of reports we need to deliver for other customer who is using PBI RS.

Please see the schedular log message below.

Resource name and Location need to match. Resource name: UW DATE SME. Location: PolicyBased_36686F87_B3FA_4760_A613_9C6D47A37170.. The exception was raised by the IDbCommand interface.

UW DATE SME is one of the table in the model, I thought there is some issue with the table so I deleted the table and rescheduled but still getting same error(Even UW DATE SME removed from the model).

Re: Report Schedule error: Resource name and Location need to match

Icey — Fri, 17 Dec 2021 05:45:10 GMT

Hi bobjSrikanth ,

we have developed these reports in PBI desktop(service) and the same set of reports we need to deliver for other customer who is using PBI RS.

So you just create report in normal PBI Desktop (for Service). After that you open it (the same one) in PBI Desktop (for Report Server) and upload it into Power BI Report Server.

Please use PBI Desktop (Optimized for Report Server) to re-create your report and then upload to PBIRS. Do not just upload the one created in normal Desktop. Please check if the issue is still there after this.

Best Regards,

Icey

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