MediaWiki to DAX Converter

About MediaWiki to DAX Converter

Convert MediaWiki tables to DAX (Data Analysis Expressions) table expressions for Power BI, Power Pivot, and SQL Server Analysis Services. Create calculated tables directly from Wikipedia and other wiki data.

Key Features

• Three DAX Formats: TABLE(), DATATABLE(), and ROW()/UNION() expressions
• Automatic Type Detection: Detects INTEGER, DOUBLE, BOOLEAN, DATETIME, and STRING types
• BLANK() Support: Empty cells converted to BLANK() function
• Custom Table Names: Configure your calculated table name
• Usage Instructions: Optional comments with implementation guidance
• String Escaping: Properly escapes quotes in DAX strings
• File Download: Save as .dax file

How to Use

1. Input MediaWiki Table: Paste your MediaWiki table or upload a .wiki file
2. Set Table Name: Enter the desired calculated table name
3. Choose Format: Select TABLE(), DATATABLE(), or ROW()/UNION() format
4. Review Output: The DAX expression generates automatically
5. Copy to Power BI: Paste into Power BI's "New Table" formula bar

DAX Formats

• TABLE(): Simple format for basic data tables without column definitions
• DATATABLE(): Explicit column types for better performance and type safety
• ROW()/UNION(): Calculated table format with named columns, ideal for small reference tables

Example Conversion

MediaWiki Input:

{| class="wikitable" border="1"
! Product !! Price !! Quantity
|-
| Laptop || 999.99 || 15
|-
| Mouse || 29.99 || 50
|}

DAX Output (DATATABLE format):

MyTable = DATATABLE(
    "Product", STRING,
    "Price", DOUBLE,
    "Quantity", INTEGER,
    {
        {"Laptop", 999.99, 15},
        {"Mouse", 29.99, 50}
    }
)

Common Use Cases

• Wikipedia Data: Import Wikipedia tables into Power BI reports
• Reference Tables: Create lookup tables from wiki data
• Static Data: Add configuration or mapping tables
• Wiki to BI: Convert wiki documentation tables to Power BI tables
• Quick Prototyping: Rapidly create tables for proof-of-concept dashboards

Data Type Detection

• INTEGER: Whole numbers (e.g., 42, 100)
• DOUBLE: Decimal numbers (e.g., 3.14, 99.99)
• BOOLEAN: TRUE or FALSE values
• DATETIME: Date patterns (YYYY-MM-DD or MM/DD/YYYY)
• STRING: All other text data
• BLANK(): Empty cells

How to Add to Power BI

1. Open Power BI Desktop
2. Go to Modeling tab
3. Click New Table
4. Paste the generated DAX expression
5. Press Enter to create the table

About DAX

DAX (Data Analysis Expressions) is a formula language used in Power BI, Power Pivot, and SQL Server Analysis Services. It's designed for data modeling, calculation, and analysis in business intelligence applications.

Privacy & Security

All conversions happen locally in your browser. Your MediaWiki data is never uploaded to any server, ensuring complete privacy and security.

FAQ  MediaWiki to DAX Converter

Do I need to install anything to use this converter?

No. Everything runs entirely in your browser using client-side JavaScript. There is nothing to install, and your data never leaves your device.

Which parts of my MediaWiki table are supported?

This tool focuses on standard MediaWiki table markup with rows and columns. Advanced wiki features like row spans, column spans, or nested tables are not supported and may be ignored or flattened during conversion.

Why are some values wrapped in quotes while others are not?

The converter automatically detects data types per column. Numeric and boolean values are emitted as raw DAX literals, while everything else is treated as text and wrapped in double quotes with proper escaping.

Can I edit the generated DAX before using it?

Yes. The generated expression is a starting point. You can rename the table, adjust column names or types, and add calculated columns or measures directly in Power BI or your DAX editor.

Is this suitable for very large tables?

DAX calculated tables are stored in memory. The converter works best for small to medium-sized tables such as lookups, reference data, or configuration tables. For very large datasets, it is usually better to import data directly from a source system instead of pasting wiki tables.