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.
Hello,
Right now I am connecting to CRM dynamics using Odata Feed and here is the query which is working.
https://cne*******.com/XRMServices/2011/OrganizationData.svc/cdi_surveyanswerSet?$filter=statecode/Value eq 0&$select=cdi_Value,cdi_surveyanswerid,cdi_PostedSurveyId,cdi_contact_cdi_postedsurvey,cdi_question
Here's the thing I need to know,
1. I imported all the table called "cdi_surveyanswerSet" and got the column names from there but it says invalid column name "cdi_surveyanswerid" of table "cdi_surveyanswerSet", where to check what's the exact column name.
2. I wanted to apply filter like cdi_question = "Some String" and cdi_modified_on > (sysdate() -1) just like we do in SQL
Could you please help me with my query ?
Solved! Go to Solution.
You should not write your query into your OData connection string. Just connect and use the query builder to pick a table and select columns. The query editor has a full set of tools for doing this which allows you to see the names of the columns so you don't get errors that you can't diagnose. See my answer in your other thread.
Proud to be a Super User!
You should not write your query into your OData connection string. Just connect and use the query builder to pick a table and select columns. The query editor has a full set of tools for doing this which allows you to see the names of the columns so you don't get errors that you can't diagnose. See my answer in your other thread.
Proud to be a Super User!
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 |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |