cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

We 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?

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Power BI Team dimazaid
Power BI Team

Re: We cannot convert the value "[Record]" to type Record causes refresh fail

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-...

12 REPLIES 12
Community Support Team
Community Support Team

Re: We cannot convert the value "[Record]" to type Record causes refresh fail

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.

 

Capture3.PNG

 

Capture.PNGCapture2.PNG

 

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: | |

Re: We cannot convert the value "[Record]" to type Record causes refresh fail

 

Thanks @v-shex-msft, 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

 

refresh issue.PNG

 

 

 

 

 

Power BI Team dimazaid
Power BI Team

Re: We cannot convert the value "[Record]" to type Record causes refresh fail

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-...

Highlighted

Re: We cannot convert the value "[Record]" to type Record causes refresh fail

Thanks @dimazaid, it worked!

taraskaduk Regular Visitor
Regular Visitor

Re: We cannot convert the value "[Record]" to type Record causes refresh fail

I have the same error.

Only instead of "Record" it says "Table"

 

The Fast Combine fix didn't help me though. Still having this error.

Can it be because I run a fast combine from a different computer?

 

 

The Microsoft Support heldesk has been silent for over 1.5 weeks now, regardless of constant follow-ups.

Power BI Team dimazaid
Power BI Team

Re: We cannot convert the value "[Record]" to type Record causes refresh fail

Hi @taraskaduk,
What do you mean you're running the fastcombine on a different computer? Are you using the personal gateway? This needs to be configured on the same machine where your gateway is running. 

taraskaduk Regular Visitor
Regular Visitor

Re: We cannot convert the value "[Record]" to type Record causes refresh fail

FastCombine is on the same machine as Personal Gateway. But that's not the machine I'm working from primarily. Which shouldn't matter

Power BI Team dimazaid
Power BI Team

Re: We cannot convert the value "[Record]" to type Record causes refresh fail

Sorry for the delay. 
I need to learn more about your queries and setup. Please msg me here so we can connect via email. 

Thanks!
Dimah

DAN Regular Visitor
Regular Visitor

Re: We cannot convert the value "[Record]" to type Record causes refresh fail

Hi @dimazaid

 

I have the same error but for 2 differents sources : CRM & Sharepoint.

On Power BI Desktop the refresh works great.

On Power BI Service it doesnt. I supposed that since these sources are in the cloud, they don't need to pass by the on-prem gateway. 

Moreover, I use a On-Prem gateway so the "fastcombine" doesn't count ( and my setting is already set at Ignore ).

 

Do you have any ideas about my problem? Thanks,

 

1.png2.png3.png

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 125 members 1,382 guests
Please welcome our newest community members: