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)

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