Menu

  • About Me
  • Event Schedule
  • Copyright

Martin's Blog

Power Query



Every Power BI model needs a Date entity

Martin Schoombee

1 comment

February 5, 2018

Unless your source data contains no dates at all, every Power BI model should have a Date entity. Chances are good that you’ve ignored a built-in option in Power BI Desktop that’s enabled by default (image below). While the “Auto Date/Time” option isn’t the worst thing you could do in Power BI Desktop (i.e. the …

Continue reading

Categories: Business Intelligence, Power BI, Power Query•

Connect & Follow

  • X
  • LinkedIn

Subscribe

Enter your email address to follow this blog and receive notifications of new posts by email.

Categories

Administration Azure Data Factory Business Intelligence Career ETL General O365 Power BI PowerShell SQL Server

Other Posts You’d Like

  • Dynamic column mapping in Azure Data Factory
  • Automating Power BI deployments: Update refresh schedule
  • Automating Power BI deployments: Change data source credentials
  • The hidden costs of Azure Data Factory's managed virtual network
  • Automating Power BI deployments: Trigger a refresh
  • The value of durable keys in type-2 dimensions

Archives

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.

To find out more, including how to control cookies, see here: Cookie Policy

Powered by WordPress.com.

Loading Comments...