Forum Discussion
Trouble modifying Incremental Refresh Effective Date through XMLA
I'm trying to modify the Effective Date of an Incremental Refresh in SSMS using the XMLA endpoint as referenced here: https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh#xml...
Hi there
It might be that, what happens if you try and refresh manually.
I think possibly there might be something not 100% correct in your JSON.
It might be that, what happens if you try and refresh manually.
I think possibly there might be something not 100% correct in your JSON.
The error was caused by the M generated by the Navigation step using the Snowflake connector.
Example:
Schema = Database{[Name="Fact",Kind="Schema"]}[Data]
The quotes around "Fact" seem to be triggering the error even though they are escaped. I ended up resolving this by switching from the Snowflake connector to an ODBC connection. Any suggestions on how to handle this while using the Snowflake connector?
