SSRS Error: Query execution failed for dataset. The attribute cannot be found for entity. Specify a valid query, and try again.

(0) Share

Report

Posted on by owins

I am developing an SSRS report for a Dynamics 365 client. I have developed reports for other clients without any issues, but for some reason I am unable to add any custom attributes to the FetchXML without getting the error mentioned above. I have set up the Data Source connection string as follows:

https://[MyClientInstance].crm.dynamics.com;[UniqueNameFromDeveloperResources]

I used Advanced Find to develop the initial query and then copied the FetchXML in the Query window of the Data Source in SSRS. I am able to refresh the fields. I am also able to run the FetchXML in the Query Designer window. It returns records, including all custom fields, without a problem.

The only time I am having an issue with the query is when I attempt to preview the report.

I am using Visual Studio 2015.

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

Wahaj Rashid 11,321 on at

Like (0)

Report
RE: SSRS Error: Query execution failed for dataset. The attribute cannot be found for entity. Specify a valid query, and try again.

Hi,

This usually happens when the connection string is incorrect.

Can you make sure:

Client instance is crm.dynamics.com (it could change depending on the region), for example, in my region, it is, crm4.dynamics.com

Secondly, make sure the Unique organization name is correct (case sensitive).

Let me know if you still face this problem.

Best,

Wahaj

(if it helps, mark it verified)

Was this reply helpful? Yes No