Errors with data refresh

[PBIBeginner2022]

Hi everyone,

I am working on a Power BI report that I did not create. When I update the data in the file with the icon circled in red (see first picture), error messages appear:

• Loading blocked by failures with other requests

However, when I update the table data one by one with a right click and then update the table, there are no error messages. This manipulation takes a long time to perform.

Do you know how to solve this update problem? Can we get around the problem with a script? If yes, how to do it?

Thank you in advance for any help.

[Syndicate_Admin]

I just served this solution to update my tables, thank you very much for the input.

Best regards

[Anonymous]

Your Table1 looks like locked. Check on this one.

[PBIBeginner2022]

How to see it  ? How to unlock this table ?

[Anonymous]

Tu le vois ici

Es-tu Admin ?

Sinon vois avec l'admin 🙂

[PBIBeginner2022]

@Anonymous I refresh one again datas and when I open "Transform data", I have this error:

[Anonymous]

The message says that the Access table is not where the source is searchning

[PBIBeginner2022]

Yes but I don't understand because it's really the source. Moreover, I always have a different error message after refresh datas .....

[Anonymous]

Hello

Did you check in Power query ?

You will find the detail of what is not going right !!

[PBIBeginner2022]

Hi @Anonymous ,

I updated again and here are the error messages that are displayed:

TABLE1

Erreur OLE DB ou ODBC: [DataFormat.Error] La base de données a été placée par l'utilisateur « Admin » sur « XXXXXXXXXXXXXX » dans un état l'empêchant d'être ouverte ou verrouillée..

TABLE2

The loading was cancelled due to an error in loading a previous table.

TABLE3

The loading was cancelled due to an error in loading a previous table.

TABLE4

The loading was cancelled due to an error in loading a previous table.

TABLE5

The loading was cancelled due to an error in loading a previous table.

TABLE6

The loading was cancelled due to an error in loading a previous table.

TABLE7

The loading was cancelled due to an error in loading a previous table.

TABLE8

The loading was cancelled due to an error in loading a previous table.

Moreover, when I open "Transform Data" I don't see errors:

[Syndicate_Admin]

That happens because some user is accessing your database exclusively, this generates blocking of queries. Solution, they must execute the query/update when there is no use by users with that level, and that blocks all transactions with minor privileges. Another would be to change the roles (profile) you use to connect to that database.

[PBIBeginner2022]

Hi @Syndicate_Admin,

Thanks for your answer.

I only import data from database Access,. I think the database is not connected to Power BI for me because we don't use user ID and password to use or to connect to the database. Do you know how change the roles (profile) ?

[PBIBeginner2022]

Hi @Syndicate_Admin,

Thanks for your answer.

I only import data from database Access,. I think the database is not connected to Power BI for me because we don't use user ID and password to use or to connect the database. Do you know how change the roles (profile) ?