Forum Discussion
BigQuery Authentication Error in a "List.Transform" Step in Power Query
Solution SageIt 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.
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
