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

  • Twitter
  • LinkedIn

Subscribe

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

Categories

Administration Business Intelligence Data Warehouse Architecture ETL O365 PASS Power BI PowerShell Reporting Services SQL Server

Other Posts You’d Like

  • A user-friendly way to deal with role-playing dimensions in Power BI
  • Automating Power BI deployments: Connecting to the service
  • Automating Power BI deployments: Assign workspace permissions
  • Automating Power BI deployments: A series
  • Automating Power BI deployments: PowerShell basics
  • Automating Power BI deployments: Deploying reports
  • Upgrading SSRS 2005 to 2012
  • Automating Power BI deployments: Change data source credentials

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.