Troubleshooting Power BI integration

Research and resolve common issues when using Report Builder with Power BI.

Failure to publish to Power BI

Scheduled workbooks that require Power BI publishing are dependent on Power BI services to be up and running. Two main reasons for a failure to publish are:

  • Power BI services may be down.
  • The user who scheduled the workbook no longer has valid Microsoft account credentials.

Each Report Builder scheduled task gets three tries per scheduled run:

  • After the first unsuccessful attempt, you will get this message: "“We were unable to publish this scheduled workbook to Microsoft Power BI. We will try again shortly.”
  • After the second unsuccessful attempt, you will get no message.
  • After the third unsuccessful attempt, you will get this message: “We were unable to publish this workbook to Power BI.”

Broken visualizations in Power BI

Here are the top reasons why you could end up with broken visualizations after publishing Report Builder requests to Power BI:

  • You edited a request in Report Builder, such as changing metrics or dimensions and then republished to Power BI. Editing requests can break your visualizations.
  • You deleted a request that was used in a visualization.

Report Builder needs to be authorized to access your organization resources. This access can only be granted by an admin. Ask an admin to grant you permission.

Have a Microsoft Admin review the “Users can register application” setting found under: Microsoft Azure > Azure Active Directory > User Settings allows options. If this option is set to No, then that admin can register these types of applications.

Users can grant Access by using the following link.

Admins granted access for every one by using the following link.

Reaching the API limit

Reporting in Power BI works with the Analytics Reporting API, so API threshold limits apply. For more information see Web Services Error Codes.

On this page