Forum Discussion

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago
Solved

Unexpected behavior in Power BI vs expected in Power Pivot - Context transition

Dear all,   I came across some odd behaviour in Power BI Desktop. The query editor has been acting strangely as well. You can get the file here. Let's see if you can reproduce it. We have Table1 as...
Need Help
  • marcorusso's avatar
    marcorusso
    7 years ago

    Just disable Auto Date/Time.

    (explanation would be long, but really - just don't use Auto Date/Time and create your own Date table).

     

  • marcorusso's avatar
    marcorusso
    7 years ago

    Options and settings / Options / Data Load / Time intelligence / Auto Date/Time

    You have that setting enabled and it creates a date table for each date column in the model.

     

AlB's avatar
AlB
Icon for Community Champion rankCommunity Champion
7 years ago

marcorusso

 

What do you mean by disable Auto DateTime? Where?

I don't even have a date table in this case, nor would I actually need one. Just a table with some dates in a column.

Thanks

marcorusso's avatar
marcorusso
Icon for Most Valuable Professional rankMost Valuable Professional
7 years ago

Options and settings / Options / Data Load / Time intelligence / Auto Date/Time

You have that setting enabled and it creates a date table for each date column in the model.

 

  • AlB's avatar
    AlB
    Icon for Community Champion rankCommunity Champion
    7 years ago

    marcorusso

     

    I see. Thanks very much. I didn't even know that option.

    I knew about creating your own date table, which I do,  but not that one is created in the shadow anyway by default.

    If you can point me to some resources that deal with the topic (maybe one of your articles?) I'd certainly appreciate it. 

     

    Many thanks