Mastering DP-500 Exam: External Tools in Power BI!

Are you considering taking the DP-500 Microsoft exam to become a certified Enterprise Data Analyst? In this video, you'll learn what are external tools in Power BI and how they work in synergy with Power BI to help you optimize your enterprise data models.

[heyitsp]

External Tools in Power BI!
- Focus on DAX Studio and Tabular Editor

What are external tools?
- Developed by community and 3rd party developers
- Increase productivity

How do they work?
1. PBI Desktop launches a local instance of analysis services engine
2. PBI Desktop forwards connection details (server name, port number, and database name) to external tool
3. External tool forwards connection details back to AS engine
4. PBID applies modifications

DAX Studio
- Uses:
- Writing DAX
- Performance tuning

- Query plans
- More information on DAX in next video

Tabular Editor
- Go-to tool for data modelling
- Uses:
- Creating and managing object groups
- Setting object level security - can't be managed from PBI Desktop

- Many features that speed up day-to-day development
- Manipulate TOMs
- Manage measures
- Create calculation groups
- Custom KPIs
- Hierarchal views
- 2 versions
- Tabular Editor 2: free service that supports most development tasks
- Tabular Editor 3: paid version, advanced features (worth it! will save you hours of PBI development

Conclusion

- External tools are an important part of the PBI ecosystem
- Extend functionality behind PBI Desktop features
- Speed up development

(Demo)

[cellentmaya]

Thanks for the video. Does Tabular Power Editor 2 work only with Power BI Premium and not with Pro?