Forum Discussion
Bigquery connection error
It seems that the solution proposed by microsoft support works:
In PBI Desktop open the report and goto to "Transform data" -> "Advanced Editor".
2. Add command timeout value such as:
Source = GoogleBigQuery.Database([CommandTimeout=#duration(0, 0, 30, 0)]),
Anonymous , You might to import SSL certificate - https://powerbi.microsoft.com/en-us/blog/ssl-security-error-with-data-source/
One open issue - https://community.powerbi.com/t5/Issues/Problems-with-native-connection-Google-Big-Query/idi-p/1179424
Thanks a lot for your help! I also read the other thread with the same issues, but they did not find any solution. But it sounds very plausible that it is a problem with cerficates. However, I cannot find anywhere in PowerBI Desktop where you can install certificates - the link was about sql server. Can you help me to where the connection certificates are actually stored? Thanks a lot....