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.
Hi @Andy_W1 ,
It is hard to troubleshooting without any detailed information, please share more details to help us clarify your scenario?
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:
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 @Andy_W1 ,
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?
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).