Power BI Troubleshooting

Let's get to the bottom of those Power BI issues you may encounter when setting up or using this functionality:

  • How to deal with the 429 Too Many Requests error:


The cause of the error:
You might have exceeded the Precoro API limits due to the excessive use of queries from Power BI. Without the use of filters, the suboptimal queries pulled an excessive amount of data.

The solution: The best course of action is to wait and then execute targeted requests. Additionally, you can set up incremental data updates in Power BI to reduce the number of queries.

  • How to deal with the Access to the resource is forbidden error:

The cause of the error: When connecting the company to synchronize data, carefully check the details when entering your email or token, because if the authorization credentials are entered incorrectly, you will receive this error.
The solution: Reconnect using the correct email and token. Make sure those credentials belong to a user who has access to the company in Precoro.

Find the guide on token generation in the Using API in Precoro article.

  • How to deal with the connector not being displayed in the list of available ones:

The cause of the error: You may have accidentally put the connector file in the wrong folder. The path to the connector file must be exactly C:\Users\[userName]\Documents\Power BI Desktop\Custom Connectors\.

Another reason could be that you downloaded Power BI from the app store, and subsequently, it affected the folder names and paths. We recommend downloading Power BI Desktop from https://www.microsoft.com/en-us/download/details.aspx?id=58494. 

The solution: Reinstall Power BI Desktop and put the connector file carefully following the instructions

  • How to deal with the issue when data sources are not saved, and the connector must be reintegrated every time:

The cause of the error: You have not logged into your Power BI account.

The solution: Create your official Power BI account by registering on the website. Then, log in to your account on the desktop version of Power BI on your computer. This way, you can save all the configured infromation and avoid having to create reports from scratch every time.