Daniel Otykier

My feedback

  1. 868 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    Signed in as (Sign out)

    We’ll send you updates on this idea

    started  ·  97 comments  ·  SQL Data Warehouse » Integration  ·  Flag idea as inappropriate…  ·  Admin →
    Daniel Otykier supported this idea  · 
  2. 57 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    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  · 
  3. 8 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    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  · 
  4. 102 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    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  · 
  5. 70 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    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?

  6. 43 votes
    Sign in
    (thinking…)
    Sign in with: oidc
    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