Power XL Table Rules and Limitations

Due to Microsoft’s policies, Power XL Table, like all custom visuals developed for Power BI, has the following limitations:

• Naming Limitations
  • Editable columns and tables in Power BI reports must retain the same names as in the data source.
  • For Semantic models, names must match the entities in the model or report Fields sections.
  • For SQL data sources, entity names must match those in the SQL tables (for example, “Customer” in SQL should not be “Customers” in the report). This applies to field or column names as well.
  • Brackets (“[” and “]”) are not supported in measure names.
  • Dots (“.”) are not supported in table names but can be used in schema names. If table names contain unsupported characters, create a compliant view and use it for writing back.
• A maximum of 30.000 records can be displayed at one time. If the underlying table contains more rows, consider using slicers in the report to edit a subset of the data and maintain a seamless workflow. For optimal performance, it is recommended to reduce the displayed table size using slicers.
• Write-Back Limitations
  • Write-back to measures is not supported; only row-level data can be modified. Use the Data Entry Matrix (DEMx) visual for modifying measure values.
  • Non-writable views as data sources for fact tables are not supported. To address this, materialize the view into a physical table, simplify the view, or create INSTEAD OF INSERT | UPDATE triggers. Non-writable views often include complex SQL queries with multiple joins, CASE statements in WHERE clauses, Common Table Expressions (CTEs), and aggregations. To test the view, duplicate it under a different name and execute an INSERT statement against it.
• On-premise Power BI Report Server requires at least the January 2019 version, along with Power BI Desktop for Report Server 2019 January or newer versions.
• Versions older than v1.2.0 may display custom columns instead of PBI columns after changing bookmarks. Save the original layout to resolve this (not the bookmarked one). Use the Save Layout button on the Designer Ribbon or the Save button in Edit mode.
• The Reset filters, slicers, and other data view changes you’ve made yellow button indicates that the report has been modified. Select it before entering Edit mode to avoid retaining Reading view settings.



• Cutting Rules
  • Cutting the entire data table is allowed in Edit mode but not in Reading View.
  • Cutting individual columns is disabled in Edit mode regardless of column type.
• Copy-Paste Limitation - There are limitations on the number of cells that can be pasted at once in the visual, depending on the user’s context and the type of sheet they are working on:
  • Non-Data Sheets (Edit Mode, Reading View, and other views): The limit is 40,000 cells.
  • Data Sheet in Reading View: The limit is 40,000 cells.
  • Edit Mode with Formulas in Datatable: The limit is 3,000 cells.
  • Edit Mode with =IFISROWDIRTY() Formula Outside Paste Range: The limit is 1,000 cells.

  If the user attempts to paste more cells than allowed, a pop-up message will notify them of the limit. This ensures optimal performance and prevents potential issues from pasting too many cells. By adhering to these limitations, users can maintain the functionality and performance of the visual.