If you choose “ Import“, the data from BigQuery will be copied to Power BI. Load data from BigQuery to Power BI – Import mode
DirectQuery – to set up a live connection to this datasetĬheck out each option’s details to choose the best one for your needs. Import – to bring a copy of the selected dataset into Power BI. The last step of the Power BI BigQuery connector setup is to click “ Load” and choose an importing option:. A Navigator window will appear in which you need to choose a BigQuery Project, a dataset, and a table to load data from. Once signed in, you’ll see a respective message on the screen. This can be excessive if, for example, you are the owner of the entire project.įor the purpose of this setup, we’ve chosen the Organizational account way – clicked the “ Sign in” button and allowed Power BI Desktop to access our Google Account. In the case of an Organizational account, you are granting Power BI the same rights you have. In addition, you can always remove/revert keys for Service Account, so you are in more control of access with it. Note: When using Service Account, you can create a separate account exactly for Power BI with the needed restricted permissions. Service Account Login – specify your Service Account email address and JSON key file contents. Organizational account – click the “ Sign in” button and follow the usual flow. 
Now you need to connect BigQuery to Power BI.
In the open window, type “ bigquery” into the search bar or select the Database category on the left, then find and select Google BigQuery.On the Home ribbon in Power BI Desktop, click “ Get Data” and then “ More…“.Note: the flow described below is only available in Power BI Desktop. To wrap up: native Power BI BigQuery connector or ODBC? Power BI connect to BigQuery
0 kommentar(er)
