In this video, I will discuss four hidden pitfalls in Power BI that can wreck your data model and/or report right out of the gate. I will show you not only how to avoid these problems, but how to create a comprehensive template that effectively addresses all of them as well as speeds up your Power BI development.
Brian
***** Video Details *****
00:00 Introduction
00:41 Horseman #1: Auto-detect relationships
02:26 Horseman #2: Auto date/time
05:20 Horseman #3: Auto summarizations
08:43 Horseman #4: Unmarked date tables
13:48 Turning off key fields
14:23 Theming tips
***** Related Links *****
Enterprise DNA Extended Date Table – https://forum.enterprisedna.co/t/extended-date-table-power-query-m-function/6390
Setting Up A Dynamic Startdate And Enddate For Power Query Date Tables – Query Editor Tutorial – https://youtu.be/iveCss_hzDo
How to Automate Tabular Editor 3 With Scripts To Simplify Repetitive Tasks – https://youtu.be/luaI_x0GXuw
***** Learning Power BI? *****
FREE COURSE – Ultimate Beginners Guide To Power BI – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi
FREE COURSE – Ultimate Beginners Guide To DAX – http://portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax
FREE – Power BI Resources – http://enterprisedna.co/power-bi-resources
FREE – 60 Page DAX Reference Guide Download – https://enterprisedna.co/dax-formula-reference-guide-download/
Enterprise DNA Membership – https://enterprisedna.co/membership
Enterprise DNA Online – http://portal.enterprisedna.co/
Enterprise DNA Events – https://enterprisedna.co/enterprise-dna-events-page/
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerBIReporting #PowerBIDataModeling