Forum Discussion
Helper IIIWe cannot convert the value "[Record]" to type Record causes refresh fail
Hi, I'm trying to schedule a refresh but it is failing with this error:
"We cannot convert the value "[Record]" to type Record"
My data sources are Dynamics CRM and SQL Server
I'm using a Personal Gateway, it is turned on and recently updated
I can refresh and publish from the desktop
Data Privacy is set to Organization for both data sources
Any idea how I can identify where the problem is?
Hi edwardrmiles,
Do you have fastcombine turned on on the personal gateway? If not here's a link on how to do it: https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-enable-fast-combine/#turn-on-fast-combine
15 Replies
Hi edwardrmiles,
Based on test, Dynamic CRM use the connect directly mode to link, this datasource can refresh directly without a gateway. After publish to service, you only need to modify the credentials.
Regards,
Xiaoxin Sheng
edwardrmilesThanks Anonymous, but the option to connect directly isn't availble to me as the model blends OData with SQL Server on-prem. See error message below
dimazaidMicrosoft Employee
Hi edwardrmiles,
Do you have fastcombine turned on on the personal gateway? If not here's a link on how to do it: https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-enable-fast-combine/#turn-on-fast-combine
I have this error AND the only datasource in use is Dynamics 365 CRM. I am not using a data gateway because one is not required for this online source.
Like others in this thread, the odata credentials are not showing errors and the privacy level is set to organizational. Any ideas?
- Sweet-Tany resolution for this? having similar issues.
What was the solution here? Auto refresh is failing with "Failure details: We cannot convert the value "[Record]" to type Record. "
