Getting Started – Formatted Text Table

Welcome! This comprehensive guide will help you quickly get started with the Formatted Text Table visual for Power BI, featuring multi-platform markup parsing, intelligent format detection, security sanitization, column-specific configuration, and enterprise content integration.

📋 Comprehensive Feature Overview

🔍 Multi-Platform Parsing ✨

Support for 9+ enterprise markup languages
Intelligent format auto-detection
Confluence, Jira, Slack, Teams, GitHub integration
Markdown, HTML, RTF format support
Performance-optimized parsing engines

🎨 Professional Formatting ✨

Original markup styling preserved
Power BI theme integration
Column-specific format configuration
Responsive table layout
Rich text rendering in table cells

📊 Column-Specific Controls ✨

Per-column markup format selection
Individual column width adjustment
Column-specific security levels
Header styling and formatting
Flexible column reordering

💬 Smart Content Detection ✨

Automatic format recognition
Fallback parser hierarchy
Content validation and sanitization
Error handling with graceful degradation
Performance metrics and monitoring

🔄 Enterprise Security

Built-in XSS protection
Configurable security levels
Content sanitization engine
CSP compliance checking
Safe rendering of external content

🎯 Power BI Integration

Native table visual experience
Theme-aware styling
Standard context menu support
Responsive design principles
AppSource compliance

📊 Enhanced Data Setup & Requirements

⚠️ Important: Each column should contain consistent markup format for optimal parsing and display results.

Enhanced Data Model Structure

— Enhanced data structure with formatted content ✨

SELECT 

    ProjectID,

    ‘h1. Project Overview\n\nStatus: {{color:green}}Active{{color}}\nPriority: High’ as ConfluenceContent,

    ‘Current Sprint\n- [x] Requirements gathering\n- [ ] Development\n- [ ] Testing’ as MarkdownContent,

    ‘:white_check_mark: Completed\n:warning: Review needed\n:x: ~Blocked~’ as SlackContent,

    ‘{\rtf1\ansi\deff0 {\fonttbl{\f0 Times New Roman;}}{\colortbl;\red255\green0\blue0;}\f0\fs24 \cf1 Priority Item\cf0}’ as RTFContent

FROM ProjectsTable

Supported Markup Formats Reference

Format	Platform	Status	Description	Example
Markdown	GitHub, General	✅ Tier 1	Standard markdown with GitHub extensions	bold italic code
Confluence Wiki	Atlassian	✅ Tier 1	Confluence wiki markup format	bold italic {{color:red}}text{{color}}
Jira Wiki	Atlassian	✅ Tier 1	Jira issue and comment formatting	bold italic {color:red}text{color}
Slack Markdown	Slack	✅ Tier 1	Slack-specific formatting with emoji	bold italic :emoji: ~strikethrough~
Teams Markdown	Microsoft Teams	✅ Tier 1	Teams message formatting	bold italic ~~strikethrough~~
HTML	Web/Email	✅ Tier 1	Sanitized HTML content	<b>bold</b> <i>italic</i>
RTF	Microsoft Office	✨ Enhanced	Rich Text Format documents	{\rtf1\ansi\b bold text\b0}
Plain Text	Universal	📝 Fallback	Unformatted text content	Simple text content

⚙️ Comprehensive Configuration Guide

Step 1: Prepare Your Content Data

Clean Content: Ensure markup syntax is valid for each platform
Consistent Formats: Use consistent markup format within each column
Test Syntax: Validate markup in original platforms before importing
Handle Encoding: Ensure proper UTF-8 encoding for special characters
Size Optimization: Keep content within reasonable size limits for performance

Example Data Preparation:

ConfluenceContent = 

“h2. Status Update\n\n” +

“Project: Digital Transformation\n” +

“Status: {{color:green}}On Track{{color}}\n” +

“Next Milestone: {{color:blue}}Phase 2 Complete{{color}}\n\n” +

“h3. Key Metrics\n” +

“|| Metric || Value || Trend ||\n” +

“| Completion | 75% | ↗ |\n” +

“| Budget | 92% | → |”

Step 2: Configure Basic Visual

Add Visual: Insert the Formatted Text Table visual into your report
Map Columns: Drag text columns containing markup to “Values” field well
Set Column Headers: Configure meaningful column headers
Test Basic Display: Verify content renders with basic formatting

Step 3: Enable Enhanced Features ✨

🎨 Column Format Configuration

Access Column Settings: Format pane > Column Formatting
Select Format: Choose specific markup format for each column
Set Auto-Detection: Enable intelligent format detection
Test Rendering: Verify formatting applies correctly

💬 Security Configuration

Security Level: Choose from Strict, Moderate, or Permissive
Content Filtering: Configure allowed HTML tags and attributes
XSS Protection: Enable advanced security scanning
Test Security: Verify potentially unsafe content is properly sanitized

📊 Column Layout Setup

Column Widths: Set individual column width ratios
Text Alignment: Configure left, center, right alignment per column
Header Styling: Customize header appearance and formatting
Row Styling: Configure alternating row colors and spacing

🔍 Performance Optimization

Enable Caching: Format pane > Performance > Enable parser caching
Set Limits: Configure content size limits per cell
Monitor Performance: Review parsing performance metrics
Optimize Large Tables: Consider pagination for large datasets

🔄 Format Detection Settings

Auto-Detection: Enable automatic format recognition
Fallback Order: Configure parser priority hierarchy
Custom Patterns: Add custom format detection patterns
Manual Override: Set specific formats for known content types

✅ Configuration Complete: You should now have a fully configured formatted text table with multi-platform markup support, security sanitization, and professional table styling.

🎯 Advanced Features Usage Guide

🔍 Multi-Platform Parsing ✨

Supported Format Features

Confluence: Colored text, tables, macros, panels, and wiki markup
Jira: Issue formatting, colored text, tables, and wiki syntax
Slack: Emoji, mentions, formatting, and thread-style content
Teams: Message formatting, mentions, and collaborative content
Markdown: GitHub-flavored markdown with code blocks and tables
HTML: Sanitized web content with security protection
RTF: Rich text documents with fonts, colors, and formatting

🎨 Column-Specific Configuration ✨

Per-Column Settings

Format Selection: Choose specific markup parser for each column
Security Level: Set individual security levels per column
Width Control: Configure column width ratios and constraints
Alignment: Set text alignment (left, center, right) per column
Style Override: Apply custom CSS classes to specific columns
Content Limits: Set maximum content size per column

💡 Pro Tip: Use column-specific settings to optimize display for different content types – strict security for external content, permissive for internal documentation.

📊 Intelligent Format Detection ✨

Smart Content Recognition

Pattern Matching: Automatic detection based on markup patterns
Priority Hierarchy: Configurable parser priority for ambiguous content
Confidence Scoring: Parser confidence levels for format detection
Fallback Chain: Graceful degradation to simpler formats when needed
Manual Override: Force specific format when auto-detection fails
Performance Optimization: Efficient format detection with caching

💡 Business Value: Automatically handle mixed content from multiple enterprise platforms without manual format specification.

💬 Security & Sanitization ✨

Enterprise Security Features

XSS Protection: Advanced cross-site scripting prevention
Content Filtering: Configurable allowed/blocked HTML elements
CSP Compliance: Content Security Policy validation
Safe Rendering: Isolated rendering of external content
Audit Logging: Security violation tracking and reporting
Risk Assessment: Content risk scoring and recommendations

🔄 Performance & Caching

Optimization Features

Parser Caching: Cache parsed content for repeated use
Lazy Loading: Load content only when visible in viewport
Content Limits: Configurable size limits prevent performance issues
Batch Processing: Efficient processing of large datasets
Memory Management: Automatic cleanup of unused parsed content
Performance Metrics: Real-time parsing performance monitoring

⚡ Advanced Table Controls

Comprehensive Table Styling

📁 Table Section:

🎨 Headers (subgroup): Header styling, fonts, and colors
📊 Rows (subgroup): Row spacing, alternating colors, and borders
📝 Content (subgroup): Text styling, alignment, and formatting
⚙️ Layout (subgroup): Column widths, responsive behavior

Available Controls:

Responsive Design: Automatic column adjustment for different screen sizes
Theme Integration: Automatic Power BI theme color adoption
Custom Styling: Override default styles with custom CSS
Accessibility: WCAG-compliant table structure and navigation

🎯 Enterprise Integration

Data Source Connectivity: Direct integration with enterprise platforms
Content Synchronization: Real-time updates from source systems
Bulk Import: Efficient processing of large content volumes
Format Preservation: Maintain original formatting and styling
Audit Trail: Track content changes and parsing history

🔧 Comprehensive Troubleshooting Guide

❌ Format Detection Issues ✨

Verify content contains recognizable markup patterns for target format
Check Format pane > Column Formatting for manual format override
Test with simplified content to isolate parsing issues
Review format detection confidence scores in performance panel
Ensure content encoding is UTF-8 for special characters

❌ Content Not Displaying ✨

Check security level settings – strict mode may block content
Verify content size is within configured limits
Review security violation logs for blocked elements
Test with plain text content to verify basic functionality
Check column width settings – content may be hidden

❌ Performance Issues ✨

Enable parser caching in Format pane > Performance
Reduce content size limits for large datasets
Check parsing performance metrics for bottlenecks
Consider pagination for tables with many rows
Review memory usage and enable automatic cleanup

❌ Security Warnings ✨

Review security violation logs for specific issues
Adjust security level to balance safety and functionality
Check CSP compliance settings for web content
Verify content source is trusted for permissive security
Test with sanitized content to isolate security conflicts

❌ Formatting Not Preserved

Verify correct markup format is selected for column
Check original content syntax in source platform
Test format-specific features (colors, tables, links)
Review parser-specific limitations for complex formatting
Ensure Power BI theme doesn’t override critical styling

❌ Table Layout Problems

Check column width ratios in Format pane > Layout
Verify responsive design settings for different screen sizes
Test text alignment settings for each column
Review header and row styling for visibility issues
Ensure adequate visual space for formatted content

🎉 Advanced Best Practices

Content Preparation ✨

Validate markup syntax in original platforms
Use consistent formatting within each column
Optimize content size for performance
Test with representative sample data
Plan column layouts for different content types

Security & Compliance ✨

Use appropriate security levels for content sources
Regularly review security violation logs
Test content sanitization thoroughly
Implement audit trails for content changes
Validate CSP compliance for web content

Performance Optimization ✨

Enable parser caching for repeated content
Monitor parsing performance metrics
Use pagination for large datasets
Optimize column widths for content types
Consider lazy loading for large tables

Enterprise Integration ✨

Connect directly to enterprise content platforms
Implement automated content synchronization
Use format detection for mixed content sources
Plan for real-time content updates
Create comprehensive documentation dashboards

🚀 Ready to Get Started? This comprehensive visual transforms ugly raw markup from enterprise platforms into beautifully formatted, professional table content that maintains original styling and supports secure, high-performance display in Power BI dashboards!