So I have run into another issue when working in direct query mode (which I need to do due to the way my client is embedding their Power BI in D365 as otherwise there will be huge data load issues - I think?!)… I am unable to create a date table in the way that I have been doing after following the tutorials on this site
Does anyone have a workaround for this so that I can still develop some deep dive insights using dates? I currently can’t see any date hierarchies and so can’t produce meaningful insights by period / quarter / month / annual etc etc - which is pretty fundamental to what is needed !!