Limitations

PowerBI Robots uses the Microsoft Power BI API to communicate with Power BI

You can find more information below about the Microsoft API limitations:

Excel Limitations

The maximum number of rows available to export is 30,000.
Exports using Underlying do not work if the data source uses Analysis Services live connection on versions older than 2016, when the tables in the model do not have a unique key.
Exports using Underlying do not work if Show items with no data is enabled for the visualization.
If filters are applied to the visualization, the exported data will also be filtered.
If using DirectQuery, the maximum amount of data that can be exported is 16 MB. Exports may result in less than the maximum number of rows, especially if when using multiple columns, data that is difficult to compress, or factors are present that increase file size and decrease number of rows exported.
Power BI only supports export on visuals that use basic aggregates. Export is not available on visuals using model or report measures.
Custom and R visuals, are not supported.
Power BI admins have the ability to disable the export data feature.
Concurrent export data requests from the same session are not supported. Multiple requests should be run synchronously.

Dataset Restrictions

This operation is only supported for datasets in a new workspace (V2 workspace).
The user issuing the request needs to have Build permissions for the dataset.
The Allow XMLA endpoints and Analyze in Excel with on-premises datasets tenant setting needs to be enabled.
Datasets hosted in AsAzure or live connected to an on-premise Analysis Services model are not supported.
Only one query returning one table of a maximum of 100k rows is allowed. Specifying more than one query will return an error.
Issuing a query that returns more than one table or more than 100k rows will return limited data.

Paginated Report Limitations

Considerations and limitations

Exporting a paginated report that has a Power BI dataset as its data source, is not supported for service principals.
When exporting a paginated report with an effective identity, the username must be an existing user from your tenant’s Azure Active Directory.
When using Gen2, the number of Power BI exports is limited to 50 paginated report pages per minute per capacity.
The exportToFile API allows one request in a five minute window when using Premium Per User (PPU).

Report Server

The limitations of using Power BI Report Server option of PBI Robots are:

Reports that requires authentication to access - the report URL needs to be accessed anonymous, otherwise the final result will be a screenshot with PowerBI Report Server requesting to login
you can't use the filter settings (Filters, slicers, and bookmarks) is not supported.
you can't print/select other pages besides the default page of your report (it is not possible to target a specific page, only the default one).

This happens because reports are rendered through a direct URL (limitations of Microsoft's API).

PreviousAPI NextSupport

Last updated 5 months ago

Excel Limitations

The maximum number of rows available to export is 30,000.

Exports using Underlying do not work if the data source uses Analysis Services live connection on versions older than 2016, when the tables in the model do not have a unique key.

Exports using Underlying do not work if Show items with no data is enabled for the visualization.

If filters are applied to the visualization, the exported data will also be filtered.

If using DirectQuery, the maximum amount of data that can be exported is 16 MB. Exports may result in less than the maximum number of rows, especially if when using multiple columns, data that is difficult to compress, or factors are present that increase file size and decrease number of rows exported.

Power BI only supports export on visuals that use basic aggregates. Export is not available on visuals using model or report measures.

Custom and R visuals, are not supported.

Power BI admins have the ability to disable the export data feature.

Concurrent export data requests from the same session are not supported. Multiple requests should be run synchronously.

Dataset Restrictions

This operation is only supported for datasets in a new workspace (V2 workspace).

The user issuing the request needs to have Build permissions for the dataset.

The Allow XMLA endpoints and Analyze in Excel with on-premises datasets tenant setting needs to be enabled.

Datasets hosted in AsAzure or live connected to an on-premise Analysis Services model are not supported.

Only one query returning one table of a maximum of 100k rows is allowed. Specifying more than one query will return an error.

Issuing a query that returns more than one table or more than 100k rows will return limited data.

Paginated Report Limitations

Considerations and limitations

Exporting a paginated report that has a Power BI dataset as its data source, is not supported for service principals.

When exporting a paginated report with an effective identity, the username must be an existing user from your tenant’s Azure Active Directory.

When using Gen2, the number of Power BI exports is limited to 50 paginated report pages per minute per capacity.

The exportToFile API allows one request in a five minute window when using Premium Per User (PPU).

Report Server

The limitations of using Power BI Report Server option of PBI Robots are:

Reports that requires authentication to access - the report URL needs to be accessed anonymous, otherwise the final result will be a screenshot with PowerBI Report Server requesting to login

you can't use the filter settings (Filters, slicers, and bookmarks) is not supported.

you can't print/select other pages besides the default page of your report (it is not possible to target a specific page, only the default one).

This happens because reports are rendered through a direct URL (limitations of Microsoft's API).