DataZoe Power BI
  • Portfolio

  • Blog

  • Videos

  • Info

  • More

    Use tab to navigate through the menu items.
    • All Posts
    • DAX Pattern
    • Report Design
    • Charticulator
    • Power Query
    • Tabular Data Model
    • Walk-through
    Search
    Working with DateID in Direct Query and Incremental Refresh
    DataZoe
    • Jan 30, 2021
    • 4 min

    Working with DateID in Direct Query and Incremental Refresh

    Scenarios when using DateTime to limit data and maintain query folding can be done with DateIDs! Two scenarios are (1) rolling x days of dat
    163 views0 comments
    Careful with RangeEnd with Incremental Refresh
    DataZoe
    • Nov 3, 2020
    • 1 min

    Careful with RangeEnd with Incremental Refresh

    Lately I've been working with incremental refresh and found that while RangeStart changes with the settings for incremental refresh the...
    30 views0 comments
    DateID compare to DateTime in Power Query for Incremental Refresh
    DataZoe
    • Oct 28, 2020
    • 1 min

    DateID compare to DateTime in Power Query for Incremental Refresh

    Incremental refresh requires a DateTime field and many tables come from the database instead with the DateID column. Here is how to...
    71 views0 comments

    © 2021 by Zoe Douglas (DataZoe). Proudly created with Wix.com.

    • LinkedIn