Havens Consulting
Video by: Reid Havens
Learn about a potential pain point when it comes to dealing with DateTime data in a fact table. You can potentially encounter an issue when joining your fact to a calendar table. Specifically if you import a Fact table into your model with a datetime column, and convert that column to a date data type in the model, instead of in Power Query. If you do this then that relationship still won't work until you make that change in Power Query.
Come hang out as Didier Terrien and I talk about (Power BI Sidetools). Power BI Sidetools is an innovative external tool offering unique features to improve productivity when developing reports, with an impressive list of features and tools contained within! Features such as: exporting data to Excel, transferring DAX and M formulas to files, viewing DAX and M code in Visual Studio Code, preview DAX measures in auto-generated tables, and more!
I worked with data for almost 4 decades in various environments as a developer and project manager. Heavy user of Excel for a long time, I try to move data as much as possible to Power BI since it appeared on the market. Working now as the Group Data Quality Officer in Trescal, my skills cover business and IT areas for the benefit of productivity and quality.
Didier's Website
Sidetools Site
Sidetools Support
Didier's Linkedin
Didier's Twitter
Video by: Reid Havens
Discover the new and improved template app (AppSource) install experience within Power BI Desktop.
Come hang out as Chris Finlan and I talk about Paginated Reports, and how Premium Per User (PPU) licenses can unlock them for many businesses. Businesses that previously couldn't afford dedicated capacity Premium licenses.
Since its introduction in 2013, Christopher Finlan has been one of the top evangelists for Power BI in his role at Microsoft. As the lead Business Intelligence Technology Solution resource in the Mid-Atlantic Region, he was responsible for helping over 140 enterprise customers align their specific requirements to the Microsoft Cloud and Data Platform. His unique presentation style and background in “shadow IT” has made him a highly sought-after speaker for customer presentations from the server room to the board room on a wide variety of BI-related topics. Currently a Principal Program Manager on the Power BI team, he leads the efforts around SQL Server Reporting Services, Paginated Reports in Power BI, and managed distribution options like e-mail subscriptions. He has been working in the software industry in various roles, from the product team to pre-sales, technical training, database administration and sales operations. He holds a B.A. from Temple University in Philadelphia.
Signup for our mailing list to gain access to Power BI files and templates from the videos. You’ll receive a welcome email with a link and password to the Blog Files page.
Reid Havens’ early love affair with analytics has, over the past decade, turned into an evolution into data visualization and report design in Power BI.
Since then Reid has been writing articles and creating YouTube videos to share the word of BI, helping to inspire the next generation of Business Intelligence enthusiasts.
