Daniel Otykier

My feedback

  1. 827 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      started  ·  84 comments  ·  SQL Data Warehouse » Integration  ·  Flag idea as inappropriate…  ·  Admin →
      Daniel Otykier supported this idea  · 
    • 55 votes
      Sign in
      Check!
      (thinking…)
      Reset
      or sign in with
        Password icon
        Signed in as (Sign out)

        We’ll send you updates on this idea

        under review  ·  5 comments  ·  SQL Server » Bugs  ·  Flag idea as inappropriate…  ·  Admin →
        Daniel Otykier commented  · 

        It looks like Excel uses the XMLA DISCOVER command for MDSCHEMA_MEASUREGROUPS to populate the "Show fields" dropdown. For a Tabular model, this command seems to always return all the tables in a model - regardless of whether a table is hidden or not, or whether it contain any measures or not.

        Logically, a table should not be reported as a measure group if it does not contain any (visible) measures. But to prevent breaking changes, I would suggest a new property or perhaps an annotation on the table, which would prevent that table from being reported in the DISCOVER command (or corresponding DMV) for MDSCHEMA_MEASUREGROUPS.

        Daniel Otykier supported this idea  · 
      • 8 votes
        Sign in
        Check!
        (thinking…)
        Reset
        or sign in with
          Password icon
          Signed in as (Sign out)

          We’ll send you updates on this idea

          1 comment  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
          Daniel Otykier commented  · 

          Tables should be prioritised, in my opinion, as it is relatively easy to access data in files using a custom SSIS script component. But with an SSIS connector that could read data directly from an ADLA table, we would no longer need to end all our U-SQL scripts with an OUTPUT statement, which would be a huge improvement!

          Daniel Otykier supported this idea  · 
        • 102 votes
          Sign in
          Check!
          (thinking…)
          Reset
          or sign in with
            Password icon
            Signed in as (Sign out)

            We’ll send you updates on this idea

            21 comments  ·  Azure Analysis Services  ·  Flag idea as inappropriate…  ·  Admin →
            Daniel Otykier supported this idea  · 
          • 69 votes
            Sign in
            Check!
            (thinking…)
            Reset
            or sign in with
              Password icon
              Signed in as (Sign out)

              We’ll send you updates on this idea

              3 comments  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
              planned  ·  Saveen responded

              This work necessary to support this is in progress.

              Daniel Otykier supported this idea  · 
              Daniel Otykier commented  · 

              Any update on this?

            • 43 votes
              Sign in
              Check!
              (thinking…)
              Reset
              or sign in with
                Password icon
                Signed in as (Sign out)

                We’ll send you updates on this idea

                under review  ·  2 comments  ·  Data Lake  ·  Flag idea as inappropriate…  ·  Admin →
                Daniel Otykier supported this idea  · 
                Daniel Otykier commented  · 

                On a related note, we need the ability to dynamically TRUNCATE partitions, for example by specifying a rowset with a list of partition buckets to be truncated.

              Feedback and Knowledge Base