{"id":3337,"date":"2021-05-12T11:06:11","date_gmt":"2021-05-12T18:06:11","guid":{"rendered":"https:\/\/SUMMALAI.COM\/?p=3337"},"modified":"2021-05-12T11:06:13","modified_gmt":"2021-05-12T18:06:13","slug":"how-to-connect-to-a-google-bigquery-database-in-power-bi-desktop","status":"publish","type":"post","link":"https:\/\/SUMMALAI.COM\/?p=3337","title":{"rendered":"How to Connect to a Google BigQuery Database in Power BI Desktop"},"content":{"rendered":"\n<p>In Power BI Desktop, you can connect to a Google&nbsp;<strong>BigQuery<\/strong>&nbsp;database and use the underlying data just like any other data source in Power BI Desktop.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"connect-to-google-bigquery\">Connect to Google BigQuery<\/h2>\n\n\n\n<p>To connect to a Google&nbsp;<strong>BigQuery<\/strong>&nbsp;database select&nbsp;<strong>Get Data<\/strong>&nbsp;from the&nbsp;<strong>Home<\/strong>&nbsp;ribbon in Power BI Desktop. Select&nbsp;<strong>Database<\/strong>&nbsp;from the categories on the left, and you see&nbsp;<strong>Google BigQuery<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/media\/desktop-connect-bigquery\/connect_bigquery_01.png\" alt=\"Get Data dialog for Google BigQuery\"\/><\/figure>\n\n\n\n<p>In the&nbsp;<strong>Google BigQuery<\/strong>&nbsp;window that appears, sign in to your Google BigQuery account and select&nbsp;<strong>Connect<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/media\/desktop-connect-bigquery\/connect_bigquery_02.png\" alt=\"Sign in to Google BigQuery\"\/><\/figure>\n\n\n\n<p>When you&#8217;re signed in, you see the following window indicated you&#8217;ve been authenticated.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/media\/desktop-connect-bigquery\/connect_bigquery_02b.png\" alt=\"Signed in to Google\"\/><\/figure>\n\n\n\n<p>Once you successfully connect, a&nbsp;<strong>Navigator<\/strong>&nbsp;window appears and displays the data available on the server, from which you can select one or multiple elements to import and use in&nbsp;<strong>Power BI Desktop<\/strong>.<\/p>\n\n\n\n<figure class=\"wp-block-image\"><img decoding=\"async\" src=\"https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/media\/desktop-connect-bigquery\/connect_bigquery_03.png\" alt=\"Data from Google BigQuery\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"considerations-and-limitations\">Considerations and Limitations<\/h2>\n\n\n\n<p>There are a few limits and considerations to keep in mind with the Google&nbsp;<strong>BigQuery<\/strong>&nbsp;connector:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>The Google BigQuery connector is available in Power BI Desktop and in the Power BI service. In the Power BI service, the connector can be accessed using the Cloud-to-Cloud connection from Power BI to Google BigQuery.<\/li><li>You can use Power BI with the Google BigQuery&nbsp;<strong>Billing Project<\/strong>. By default, Power BI uses the first project from the list returned for the user.To customize the behavior of the Billing Project when you use it with Power BI, specify the following option in the underlying M in the Source step, which can be customized by using&nbsp;<strong>Power Query Editor<\/strong>&nbsp;in Power BI Desktop:Copy<code>Source = GoogleBigQuery.Database([BillingProject=\"Include-Billing-Project-Id-Here\"]) <\/code><a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/reference\/storage\">Google BigQuery Storage API<\/a>&nbsp;is enabled by default and is controlled by the optional boolean argument called &#8220;UseStorageApi&#8221;. Some customers might encounter issues with this feature if they use granular permissions. In this scenario, you might see the following error message:<code>ERROR [HY000] [Microsoft][BigQuery] (131) Unable to authenticate with Google BigQuery Storage API. Check your account permissions<\/code>You can resolve this issue by adjusting the user permissions for Storage API. Assign these Storage API permissions:<ul><li><code>bigquery.readsessions.create<\/code>&nbsp;&#8211; Creates a new read session via the BigQuery Storage API.<\/li><li><code>bigquery.readsessions.getData<\/code>&nbsp;&#8211; Reads data from a read session via the BigQuery Storage API.<\/li><li><code>bigquery.readsessions.update<\/code>&nbsp;&#8211; Updates a read session via the BigQuery Storage API.<\/li><\/ul>These permissions typically are provided in the BigQuery.User role. For more information, see&nbsp;<a href=\"https:\/\/cloud.google.com\/bigquery\/docs\/access-control\">Google BigQuery Predefined roles and permissions<\/a>.Beginning with the April 2021 release of Power BI, if you do not have adequate permissions, you will see zero rows returned from queries. Make sure the specific permissions described previously are set properly on the account being used, to enabling refreshing a report or retrieving data from any tables.If the above steps do not resolve the problem or if you want to disable the support for Storage API, change your query to the following:Copy<code>Source = GoogleBigQuery.Database([UseStorageApi=false]) <\/code>Or if you are already using a billing project, change the query to the following:Copy<code>Source = GoogleBigQuery.Database([BillingProject=\"Include-Billing-Project-Id-Here\", UseStorageApi=false<\/code><\/li><\/ul>\n\n\n\n<p>Ref: https:\/\/docs.microsoft.com\/en-us\/power-bi\/connect-data\/desktop-connect-bigquery<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Power BI Desktop, you can connect to a Google&nbsp;BigQuery&nbsp;database and use the underlying data just like any other data source in Power BI Desktop. Connect to Google BigQuery To connect to a Google&nbsp;BigQuery&nbsp;database select&nbsp;Get Data&nbsp;from the&nbsp;Home&nbsp;ribbon in Power BI Desktop. Select&nbsp;Database&nbsp;from the categories on the left, and you see&nbsp;Google BigQuery. In the&nbsp;Google BigQuery&nbsp;window that <a class=\"read-more\" href=\"https:\/\/SUMMALAI.COM\/?p=3337\">Read More<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[585,10,621],"tags":[],"class_list":["post-3337","post","type-post","status-publish","format-standard","hentry","category-google-cloud","category-microsoft","category-power-bi"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3337","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3337"}],"version-history":[{"count":1,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3337\/revisions"}],"predecessor-version":[{"id":3338,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=\/wp\/v2\/posts\/3337\/revisions\/3338"}],"wp:attachment":[{"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3337"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3337"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/SUMMALAI.COM\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3337"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}