cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate I
Advocate I

Fast Combine - what is it?

I'm experienciing an issue with scheduled refersh in the Service and a number of forum posts suggest that enabling Fast Combine for my On-premises data gateway (personal mode) could solve the problem.

[FYI my issue relates to the error message "We cannot convert the value "[Record]" to type Record" with a SharePoint list and a number of .xlsx files as the data sources].

 

However... I can't find any documentation that actually explains what Fast Combine is, and I'm reluctant to action this without understanding why!

 

Can anyone explain to me what Fast Combine is and in what scenarios it needs to be enabled?

 

thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Fast Combine - what is it?

Hi SusieBentley,

 

What is Fast Combine?

To learn more about privacy levels and Fast Combine, you can look at Privacy Levels. By default, the privacy level will be set to private which could result in the error mentioned above. This is because a setting of private will isolate the data source from other sources. An example of where this would be a problem would be a parameterized query getting inputs from another data source.

Turning Fast Combine on will ignore the private setting and allow the execution to occur.

 

Regards,

Jimmy Tao

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Fast Combine - what is it?

Hi SusieBentley,

 

What is Fast Combine?

To learn more about privacy levels and Fast Combine, you can look at Privacy Levels. By default, the privacy level will be set to private which could result in the error mentioned above. This is because a setting of private will isolate the data source from other sources. An example of where this would be a problem would be a parameterized query getting inputs from another data source.

Turning Fast Combine on will ignore the private setting and allow the execution to occur.

 

Regards,

Jimmy Tao

View solution in original post

Highlighted
Advocate I
Advocate I

Re: Fast Combine - what is it?

That's really helpful, thanks Jimmy. Just what I was after.

 

I'm still experiencing my refresh issue but at least I understand if/where Fast Combine comes into this now! Smiley Very Happy

 

Thanks for your quick reply

Susie

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

We are thrilled to announce we will begin running a monthly webinar series named Power BI Dev Camp.

Top Kudoed Authors