Forum Discussion

dgelfand's avatar
dgelfand
New Member
6 years ago

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...
Need Help
GilbertQ's avatar
GilbertQ
Super User
6 years ago
It would appear that the new of your cube is using one of the reserved characters?
dgelfand's avatar
dgelfand
New Member
6 years ago

What would the "Name" be referring to here? Neither my data set nor any of the table or column names in it have these reserved characters.  Is it something in my M queries?

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    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.
    • dgelfand's avatar
      dgelfand
      New Member
      6 years ago

      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?

       

      • jitparwa's avatar
        jitparwa
        Regular Visitor
        6 years ago

        dgelfand : Can you let me know if your incremental refresh is working with it? As I wasnt able to see partitions in my cube and neither it was working.