Answered

the data returned by the service is invalid.

(0) Share

Report

Posted on by Community Power Pla...

When i use CountRows() to counts the number records in a table which i created in CDS,it reports a question that "the data returned by the service is invalid."

I have searched for help,but the articles don't write the Detailed process.I'm still confused.

I wish someone can help me,sincerely.

Best wishes.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (9)

Answers (1)

Joel CustomerEffective 3,224 on at

Like (1)

Report

There is a setting for enhanced delegation in your app that makes CountRows delegable. Without this setting CountRows cannot be delegated to CDS. Is this setting enabled?

if that doesn’t fix it, please post your count rows formula

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@jlindstrom
Yes, i have done it,but it doesn't work.

Is there another way ?

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @Anonymous :
The cause of the problem may be that you lack permissions to this entity.
I suggest you refer to @EricRegnier 's reply in this post:
https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/CountRows-The-data-returned-by-the-service-is-invalid/td-p/622655
In addition, you can also ask the "System Administrator" to give you a higher-level security role.
Best Regards,
Bof

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@v-bofeng-msft
Thanks for helping.

I have seen before and have tried it.But it didn't work.I still have doubt. I don't know concrete steps.

If you have free time,Please tell me the concrete steps.

Sincerely.

Was this reply helpful? Yes No
Verified answer

EricRegnier 8,720 Most Valuable Professional on at

Like (1)

Report
Hi @Anonymous,
To ensure it's not a security/privilege issue, can you confirm that you're System Administrator in the environment? Or can you try with a System Administrator account. To check your roles:
In make.powerapps.com, click on the gear icon on the top right, then Advanced Settings
On the top navigation bar, select Settings --> Security --> Users
Find and select or open your user record and click on "Manage Roles" button in the command bar
Check if you have the security role "System Administrator" check. If not, can you select it and save and close.
If you can assign yourself the role, please check with the system administrator of your organisation
Hope this helps...

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@EricRegnier
Thank you very much

Was this reply helpful? Yes No
ruig 29 on at

Like (0)

Report

This resolved my identical issue. - Thank you @jlindstrom

Was this reply helpful? Yes No
valerie-tsh Microsoft Employee on at

Like (0)

Report

Hi @EricRegnier ,
Does this mean that other users using my app who doesn't have the "System Administrator" role will face the error?

Was this reply helpful? Yes No
EricRegnier 8,720 Most Valuable Professional on at

Like (0)

Report

Hi @valerie-tsh, no suggest users do not have the System Admin role, but users do need the correct privileges in Dataverse (formally CDS). Assigning System Admin role is a quick check to isolate the problem and see if your issue is a privilege issue.

Was this reply helpful? Yes No