BigQuery Authentication Error in a "List.Transform" Step in Power Query

[alaguilare]

Hi all!

I'm getting an authentication error after an step in which I create a List with "List.Transform" that depends on other columns. 

The situation is strange because I can work (and update) in the query until this step, but after it, it is not able to authenticate anymore. 

Any ideas why it is happening? 

Screenshot of the last step that it works:

Screenshot of the error an it's formula: 

Thanks in advance!!

[MAwwad]

It looks like the error message is indicating an issue with authentication, which may be related to the credentials used to access the BigQuery data.

One suggestion would be to double-check that the credentials being used are correct and have the necessary permissions to access the data. Additionally, it may be helpful to check if there are any known issues or updates related to the BigQuery connector in Power Query.

Another potential solution could be to try refreshing the credentials or reconnecting to the data source. This can be done by clicking on "Data source settings" in the Power Query Editor and then selecting the data source in question. From there, you can try to refresh the credentials or reconnect to the data source.

If none of these solutions work, it may be helpful to provide more information on the specific authentication error being encountered, as well as any additional error messages or details that could help pinpoint the issue.

[alaguilare]

Thanks for your answer DataSlayer! However none of this works.
I've double check credentials, deleted the data source settings and re-configurate everything again. 

There is no additional information about the error. 

As written initially, the strange thing for me is that it does work until certain step, but then it just stops working in the "List.Transform" step. 

[MAwwad]

Dont forget to accept this as a solution in order to help others as well