Answered

CountRows The data returned by the service is invalid

(0) Share

Report

Posted on by Community Power Pla...

Hi there,

I have a couple of CDS entities which I'm using to supply Power Apps. When I use the CountRows function I get an error advising "The data returned by the service is invalid". There are currently only 3 rows in the table so its not a delegation issue.

To troubleshoot, I have added the following to the Default Value of a Text Box which fails:

CountRows('Houses')

With Houses being the name of the Entity.

This works when I point to Entities which are auto generated by Power Apps, but does not work for my custom entities.

Your help is much appreciated.

Richard

Categories:

Entities

All responses (2)

Answers (1)

Community Power Pla... on at

Like (0)

Report

Re: CountRows The data returned by the service is invalid

Thanks for the advice, this seems to have worked!
Verified answer

EricRegnier 8,714 Most Valuable Professional on at

Like (0)

Report

Re: CountRows The data returned by the service is invalid

Hi @Anonymous,
Seems like your missing privileges on those custom entities. You'll need to edit an existing security role (or create a new one) to grant privilege on those entities. Make sure you edit the role(s) that are assigned on the user that is used in the CDS Connector.
Cheers