Incremental Refresh Error

[xfidelitydj]

Hello,

After setting up incremental refresh based on a date range parameter filter applied to "Modified Date" of a SharePoint Online list, we receive the following error in our Premium Service Refresh History

The JSON DDL request failed with the following error: Failed to save modifications to the server. Error returned: 'Parameter substitution failed with following error: 'Neither mashup nor gateway connection string detected for incremental refresh parameter substitution'. Parameter substitution failed with following error: 'Neither mashup nor gateway connection string detected for incremental refresh parameter substitution'.

Any suggestions?

Thanks!

[Anonymous]

Same error here using application insights source. 

[gmarrone · Accepted solution]

I get the same error message, and I am too trying to implement incremental reload (as per May release of Power BI).

Honestly, I believe this is a bug as the feature is still in preview.

[xfidelitydj]

Hello,

After setting up incremental refresh based on a date range parameter filter applied to "Modified Date" of a SharePoint Online list, we receive the following error in our Premium Service Refresh History

The JSON DDL request failed with the following error: Failed to save modifications to the server. Error returned: 'Parameter substitution failed with following error: 'Neither mashup nor gateway connection string detected for incremental refresh parameter substitution'. Parameter substitution failed with following error: 'Neither mashup nor gateway connection string detected for incremental refresh parameter substitution'.

Any suggestions?

Thanks!

[Anonymous]

HI @xfidelitydj,

Based on error message, it seems like there are something wrong with your datasource connection and parameters.

I'd like to suggest you to take a look at below link to know more about power bi service parameters:

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev,

Regards,

Xiaoxin Sheng