Share
Report
5Hello!
I'm currently working on a Power BI report that is supposed to show data from a Survey sent to a customer list from our company.
This report needs to show everyone that has received the survey and their response to it.
I was recently added as a co-owner on the Customer Voice Project, I think this information is relevant because in this post it is suggested that some information can be missed if the person trying to connect to CDS is not the Project Owner. In my case, I was added to it in September 2021, but data from April is available to me, so I'm not sure the post I mentioned applies to my case.
In Microsoft Docs, it is suggested that the Common Data Service supports paging of query results.
Is there any chance the request response I'm receiving is paged? If so, is there any way I can work around this?
More details on the Power BI report below:
- On Power BI, we first connect to the "Common Data Services" using our CRM Web URL, pull data from the "surveyinvite, surveyresponse, surveyreminder, survey, project, question and questionresponse" tables. No filtering is made, only data normalization on those tables.
- From the 607 invites sent out (according to the Dynamics 365 Dashboard), only 417 show up on the "msfp_surveyinvite" table loaded in Power BI.
- The data that is shown presents different dates on the "CreatedOn" column, they can be shown from April until October, but I've noticed that there is data missing in between dates.
If any other details are needed please let me know so I can help the support.
Kind Regards.
All responses (
Answers (
