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

 

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