Below we give you some tips about setting up your data model and creating reports and dashboards in Power BI Desktop.
- Only import the tables and fields you use in your dashboard. Try to keep the data model as compact as possible, which gives a better performance and keeps the model clear. See Data reduction techniques for Import modeling – Power BI | Microsoft Docs.
- Set up the data model as a ‘star model’, with facts and dimensions. See Understand star schema and the importance for Power BI – Power BI | Microsoft Docs.
- Use one-to-many relationships between your tables as much as possible, with the filter direction going from the dimension table to the fact table. Only use the ‘many-to-many relationships’ and the crossfilter direction ‘both’ if you know their impact. See Model relationships in Power BI Desktop – Power BI | Microsoft Docs.
- Edit your tables (adding and modifying columns) as much as possible in Power Query. See Query overview in Power BI Desktop – Power BI | Microsoft Docs.