cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Andy_W1 Regular Visitor
Regular Visitor

Scheduled Refresh failing - We cannot convert the value "[Record]" to type Record.

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!

6 REPLIES 6
Community Support Team
Community Support Team

Re: Scheduled Refresh failing - We cannot convert the value "[Record]" to type Record.

Hi @Andy_W1 ,

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Andy_W1 Regular Visitor
Regular Visitor

Re: Scheduled Refresh failing - We cannot convert the value "[Record]" to type Record.

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:

 

Message We cannot convert the value "[Record]" to type Record. Table: Lead Consultant Earliest Date.
Cluster URI WABI-UK-SOUTH-redirect.analysis.windows.net
Activity ID cc96f8c2-b0d3-439e-a30f-f245d6fe6189
Request ID abe9ca7c-32ed-483c-89ec-503953264130
Time 2019-03-30 01:09:44Z
 
I've taken out this particular table (Lead Consultant Earliest Date) to see if it is this actual table that is causing the problem or if the whole dataset fails. It refreshed in Power BI Service with no problem, so it is something on that particular table.
 
Lead Consultants Earliest Date:
It was a duplicate of another table and then I did a Group By:
 
Group By.PNG
And then I created some new measures, as our 'year' runs from August to July, so had to say August was month 1, September was month 2, etc etc to get the months to show from August onwards.
 
Lead Consultants.PNG
 
The visualisations update if I force a refresh in the Desktop, but it doesn't refresh in the Service.
 
Thank you for looking at my query, and I hope I've given enough info now.
 
Thanks,
Andy
Community Support Team
Community Support Team

Re: Scheduled Refresh failing - We cannot convert the value "[Record]" to type Record.

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?

Support Ticket.gifsubmit a support ticket

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
Andy_W1 Regular Visitor
Regular Visitor

Re: Scheduled Refresh failing - We cannot convert the value "[Record]" to type Record.

Thanks for trying @v-shex-msft - I have now been in touch with Power BI Support.

guibenassi Frequent Visitor
Frequent Visitor

Re: Scheduled Refresh failing - We cannot convert the value "[Record]" to type Record.

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

 

Andy_W1 Regular Visitor
Regular Visitor

Re: Scheduled Refresh failing - We cannot convert the value "[Record]" to type Record.

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