How can we improve Power BI?

incremental refresh for date not just date/time

Incremental Refresh appears to only function for inserting the parameters into a Date/Time format.
What about where users are using DirectQuery, which does not allow us to change the format type of a column, and the SQL Server data being queried is only in Date format, not Date/Time?
Please allow parameters and incremental refresh to function as well for Date format columns.

1 vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Andrew shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →

    1 comment

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)
      Submitting...
      • Andrew commented  ·   ·  Flag as inappropriate

        As I was testing some more, am I wrong to think Incremental Refresh can be applied to DirectQuery? It is strictly limited to Import? What about Dual within the new Composite Model release though?

      Feedback and Knowledge Base

      Ready to get started?

      Try new features of Power BI today by signing up and learn more about our powerful suite of apps.