Select your Google account and approve connecting.Īlthough the sign in dialog box says you'll continue to Power BI Desktop once you've signed in, you'll be sent to your online app instead. Then select Sign in.Ī Sign in with Google dialog appears. If you're using on-premises data, select an on-premises data gateway. In the Google BigQuery Database dialog, you may need to either create a new connection or select an existing connection. In the Get Data experience, select the Database category, and then select Google BigQuery. To connect to Google BigQuery from Power Query Online, take the following steps: Then select either Transform Data to transform the data in Power Query or Load to load the data in Power BI Desktop.Ĭonnect to Google BigQuery data from Power Query Online Once you successfully connect, a Navigator window appears and displays the data available on the server. Once signed in, select Connect to continue. Select your Google account and approve connecting to Power BI Desktop. Then select Connect.Ī Sign in with Google dialog appears. In this case, select Service Account Login and enter your service account email and your service account JSON key file contents. You can also sign in using a Google service account. In this example, you'll use the organizational account to sign in. The Google BigQuery connector supports connecting through an organizational account or a service account sign-in. More information: Connect using advanced options If you want to use any advance options, select Advanced options. In the Get Data experience, search for and select Google BigQuery. To connect to Google BigQuery from Power Query Desktop, take the following steps: Capabilities supportedĬonnect to Google BigQuery data from Power Query Desktop You'll need a Google account or a Google service account to sign in to Google BigQuery. Due to this change, you will need to update your Power BI Desktop version to June 2021 to support signing in to Google. Effective July 2021, Google will discontinue support for sign-ins to Google accounts from embedded browser frameworks.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |