Review the following known issues and limitations before you begin working with plan.
Supported limits might vary depending on client resources, Fabric capacity, and Power BI XMLA query limits.
Plan doesn't support Microsoft Entra B2B IDs.
Plan items aren’t supported in workspaces or tenants that use private links.
Don't rename a semantic model that's connected to a Plan item. Renaming the semantic model breaks the connection, and the Plan item no longer works with the renamed semantic model.
Power BI Pro and Power BI Premium Per User (PPU) aren't supported for Plan scenarios that use XMLA endpoints and embed tokens. Similarly, lower-capacity SKUs that do not support XMLA endpoints are also unsupported.
PowerTable doesn't support user-specific database-level row-level security (RLS) when connecting to Fabric SQL tables through a database connection. As a result, users might see rows that differ from the expected RLS-filtered results. This limitation exists because PowerTable executes all database queries by using the identity associated with the database connection that the user configures during sheet creation, rather than the identity of the signed-in PowerTable user.
Blend (From Sheets) doesn't support RLS. All data available in the source sheet is visible regardless of the viewer's RLS permissions.
If you delete the DMTS connection that you configured for a PowerTable sheet, or if it becomes unavailable, you can't open the sheet to update the connection. The connection recovery screen doesn't appear, and you see the message "DMTS connection is deleted or not found."
To recover, create a new PowerTable sheet by using the Existing Table option and configure the same table again.
Excel export (Raw mode) supports up to 20 million cells or 1 million rows, while Excel export (Label mode) supports up to 5 million cells.
Sort supports a maximum of 5 million rows. Sort isn't supported when the total number of rows exceeds 5 million.
Group By supports a maximum of 5 million rows. Group By isn't supported when the total number of rows exceeds 5 million.
Insight supports up to 5 million rows. Insight isn't supported when the total number of rows exceeds 5 million.
Find and Replace supports up to 5 million rows. Find and Replace isn't supported when the total number of rows exceeds 5 million.
Snapshot export in Gantt supports up to 100,000 rows, and you can create up to 5 snapshots per table.
Find Action fetches only the first 1,000 records.
A repeating group processes only the first 1,000 items. Additional items beyond this limit aren't processed.
Cascading automation triggers support up to 2 levels, including the initial trigger. Automation chains can't extend beyond two trigger levels, and further cascading triggers aren't executed.
Multiple record operations aren't supported in subsequent automation actions. Subsequent actions support only single-record operations.
Create Record, Update Record, Delete Record, and Form Submission database triggers support writeback of up to 10 records per trigger type. If a user writes back more than 10 records, automation jobs aren't triggered for any of the records. The system doesn't partially execute the automation for the first 10 records.
Scrollbar supports up to 5 million rows. Scrollbar isn't supported when the total number of rows exceeds 5 million. Users can navigate the table only through pagination.
Gantt and Resource Layout support up to 30,000 rows. Gantt and Resource Layout aren't supported when the total number of rows exceeds 30,000.
Automatic application database creation isn't supported when deploying plan items through CI/CD by using a service principal.
Don't rename a workspace that contains a Plan item. Renaming the workspace breaks the Plan item, and the item no longer opens.
Bulk data input supports a maximum of 1 million rows. Uploading more than 1 million rows from an Excel or CSV file isn't supported and might cause the upload to fail.
A Plan item supports up to 25 sheets. Keep the number of sheets within this limit to avoid problems when working with the item.
A Plan item supports up to 50 visuals. Keep the number of visuals within this limit to avoid problems when working with the item.
Each Infobridge query in a Planning sheet supports up to 1.2 million cells. Queries that exceed this limit might fail to load or process.
To work with larger datasets, split the data across multiple Planning sheets and append the queries. This approach supports a consolidated workbook of up to about 5 million cells (for example, across five Planning sheets).
Writeback supports up to 1.2 million cells per operation. Writeback operations that exceed this limit aren't supported and might fail.
