1 – Power Query and Advanced Modelling
- Dynamic parameters
- Advanced import
- Organisation and best practices
- Differences between Import, Direct Query and Direct Lake
- Advanced modelling with TMDL
2 – Advanced DAX and Time Intelligence
- Advanced functions
- DAX optimisation
- DAX queries
3 – Security and Governance (RLS)
- Implementation of Row-Level Security
- Role management and permissions in the Service
- Gateway configuration and refresh scheduling
- Fabric (Power BI) administration
4 – Other features
- Alerts
- Paginated Reports
- Write-back