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
(thinking…)
Sign in with: facebook google
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
(thinking…)
Sign in with: facebook google
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.