'Query execution failed for dataset. (rsErrorExecutingCommand)' problem

Question

'Query execution failed for dataset. (rsErrorExecutingCommand)' problem

Mengjie1024 0

The report page shows 'Query execution failed for dataset. (rsErrorExecutingCommand)' when I add Chinese character values into this dataset and deploy it on Project Online,

does anyone know which kind of this problem could it be

Olaf Helper 47,441 Reputation points

2023-12-04T12:14:01.2366667+00:00

With that less on informations no one can guess.

when I add Chinese character values into this dataset

Add to where and how?
Anonymous

2023-12-05T02:36:36.0233333+00:00

Hi @吴梦婕

What does the complete error message look like? You can also check the logs to locate the problem: Report Server Service Trace Log.

Best regards,

Aniya
Mengjie1024 0 Reputation points

2023-12-07T08:37:50.2666667+00:00

Hi @Anonymous

I can not find the Report Server Service Trace log file, since there is no such file named 'MSRS13.MSSQLSERVER' under the path of 'C:\Program Files\Microsoft SQL Server'

best regrads,

mengjie
Anonymous

2023-12-07T08:43:25.55+00:00

Hi @Mengjie1024

In SQL Server Reporting Services 2017, the log path: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles.

You can refer to this link: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/reporting-services-log-files-and-sources?view=sql-server-ver16.

Best regards,

Aniya
Mengjie1024 0 Reputation points

2023-12-08T01:12:01.4366667+00:00

Hi @Olaf Helper

I have developed a online report by using query from SQL server datasource, when I executed this report locally, it can show all datasets, but when I deployed it on powerBI report service online, the report page showed 'Query execution failed for dataset. (rsErrorExecutingCommand)' . If I removed the Chinese Characters in the value of this dataset, this problem can be fixed.

Best regards,

Mengjie

1 answer

Your answer

Olaf Helper 47,441 Reputation points

2023-12-04T12:14:01.2366667+00:00

With that less on informations no one can guess.

when I add Chinese character values into this dataset

Add to where and how?
Anonymous

2023-12-05T02:36:36.0233333+00:00

Hi @吴梦婕

What does the complete error message look like? You can also check the logs to locate the problem: Report Server Service Trace Log.

Best regards,

Aniya
Mengjie1024 0 Reputation points

2023-12-07T08:37:50.2666667+00:00

Hi @Anonymous

I can not find the Report Server Service Trace log file, since there is no such file named 'MSRS13.MSSQLSERVER' under the path of 'C:\Program Files\Microsoft SQL Server'

best regrads,

mengjie
Anonymous

2023-12-07T08:43:25.55+00:00

Hi @Mengjie1024

In SQL Server Reporting Services 2017, the log path: C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\LogFiles.

You can refer to this link: https://learn.microsoft.com/en-us/sql/reporting-services/report-server/reporting-services-log-files-and-sources?view=sql-server-ver16.

Best regards,

Aniya
Mengjie1024 0 Reputation points

2023-12-08T01:12:01.4366667+00:00

Hi @Olaf Helper

I have developed a online report by using query from SQL server datasource, when I executed this report locally, it can show all datasets, but when I deployed it on powerBI report service online, the report page showed 'Query execution failed for dataset. (rsErrorExecutingCommand)' . If I removed the Chinese Characters in the value of this dataset, this problem can be fixed.

Best regards,

Mengjie

Answer 1

Greg Low 1,980 Microsoft Regional Director

Keep in mind that SSRS parses your SQL and sends to the database what it thinks you meant, rather than what you actually asked for. It only rewrites the commands because it knows it's SQL Server that it's talking to. What I'd do as a first test, is try to see if it works if you change the connection type to OLEDB as a generic data source, instead of the SQL Server data source. See if that works.

Share via

'Query execution failed for dataset. (rsErrorExecutingCommand)' problem

1 answer

Your answer