Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi, I've just set up my first dataset with a scheduled refresh, which is failing for the following reason:
We cannot convert the value "[Record]" to type Record. Table: Lead Consultant Earliest Date.
I'm taking data straight from Dynamics 365 CRM, so everything is in the cloud, so don't believe I need to create a personal data gateway (which I've seen as a solution to this 'message' elsewhere).
I don't know how to solve this and get this refreshing. Any help would be gratefully received as new to this.
Thanks!
Hello Andy,
I guess the problem is related with the columm record at the table Lead Consultant Earliest Date.
Probably something related with the format.
Goes to Modelling and try use another data format
Hi @guibenassi - thanks for the reply. I got in touch with Power BI support at Microsoft and without me doing anything to my data, it started refreshing correctly. So, I don't think there was anything wrong with my tables/data. They seemed to imply that they rolled out some things in the backend and that possibly sorted out the issue?!? I wish I could say what solved it to help others (especially on this community forum).
Thanks,
Andy
Hi @Anonymous ,
It is hard to troubleshooting without any detailed information, please share more details to help us clarify your scenario?
For example:
data source type(dynamic crm online/on premise), detailed error message, any advanced query operations in query table, snapshot...
In addition, you can also take a look at following link about similar issues:
We cannot convert the value "[Record]" to type Record causes refresh fail
Regards,
Xiaoxin Sheng
Hi @v-shex-msft
Sorry I didn't give enough info.
The data source type is Dynamics CRM online (when I click on Gateway Connection) - it says You don't need a gateway for this dataset, because all of its data sources are in the cloud.
As an example, this is the error message I'm getting:
Hi @Anonymous ,
I try to use your activity id to get detailed error message, but I haven't found anything useful. Can you please open a support ticket to get better support from power bi team?
Regards,
Xiaoxin Sheng
Thanks for trying @v-shex-msft - I have now been in touch with Power BI Support.