Edit

Known limitations in plan (preview)

Review the following known issues and limitations before you begin working with plan (preview).

Supported limits might vary depending on client resources, Fabric capacity, and Power BI XMLA query limits.

Important

This feature is in preview.

B2B user support

Plan doesn't support Microsoft Entra B2B IDs.

Workspaces or tenants that use private links don't support plan items.

Semantic model

  • You must have Admin or Build permissions on the semantic model.
  • Semantic models in Direct Lake mode require additional configuration.
  • Semantic model connections only support OAuth-based and service principal-based authentication.
  • Semantic models published in My workspace aren't supported.

Semantic model renaming

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.

Capacities supported

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 don't support XMLA endpoints are also unsupported.

Database-level row-level security (RLS) support

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.

PowerTable DMTS connection recovery

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.

Workspace permissions

  • Users with the Contributor role can't create or share cloud connections.
  • Users with lower-level workspace roles, such as Contributor, can't create plan items that require embed token generation.

Workspace renaming

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 limit

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.

Maximum number of sheets per item

A plan item supports up to 25 sheets. Keep the number of sheets within this limit to avoid problems when working with the item.

Maximum number of visuals per 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.

Infobridge cell limit

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 cell limit

Writeback supports up to 1.2 million cells per operation. Writeback operations that exceed this limit aren't supported and might fail.