Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
during the refresh phase I receive the error 'Failed to modify the connection string due to %s, has it ever happened to you? the source is SQL Server, on the same source I have other datasets that update without problems.
Thank you
Solved! Go to Solution.
Hi @fmilidoni ,
Have you used fuzzy queries in the sql query defined in the source?( like "select a,b from table where table.a like '%s%'" )
You could check if sql query works properly.
Hi @fmilidoni ,
Have you used fuzzy queries in the sql query defined in the source?( like "select a,b from table where table.a like '%s%'" )
You could check if sql query works properly.
Hi ,
I am using AWS Redshift as a databource as ODBC connection. I am getting same error while configuing Incremental Refresh. I have created RangeStart and RangeEnd Parameters as datetime column. In the dataset I added the filter to use the start and end parametrs. I have enabled incremental refresh sucessfully on my desktop but after publishig to Power BI service, I am getting this error after waiting for 5 hours "Parameter substitution failed with following error: 'Failed to modify the connection string due to error "%s"'. " I don't have any fuzzy queries at all in the dataset.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.