Posts

Showing posts from June, 2021

Checklist for Finalizing a Data Model in Power BI Desktop

  Checklist for Finalizing a Data Model in Power BI Desktop The checklist focuses on the data model itself, rather than report design. For sound practices and suggestions about report design, check out Meagan's series:   Design Concepts for Better Power BI Reports .  This checklist does **NOT** include: Visuals or reports in Power BI Desktop Performance-related specifics (because it always depends) Testing specifics or approaches After publishing to either Power BI Service or Power BI Report Server Ongoing administration and management such as data refresh Terminology: Data model = the data imported to Power BI; also known as the dataset (formerly known as Power Pivot) PBIX = the Power BI Desktop file Field = columns and derived measures which are displayed in the field list Query = source query in the Query Editor (formerly known as Power Query) Why Is the Power BI Data Model So Important? There are many things you can do with report visuals – change field names, adjust formats, a