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....
Hi Anonymous ,
Try to use "Google BigQuery" connector.
Connect to a Google BigQuery database in Power BI Desktop
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
no
