![]() Share it as “Edit – anyone with the link”.This method will always give you the latest version of the Google Sheet file before every query refresh. So the question is: How do you do that? How do you connect Google Sheets to Power Query with no middlemen? You can schedule the BigQuery Uploader to upload the data every hour at best or you can trigger to upload from Google Sheets to BigQuery manually in the worst case. The downside of this approach is that the data in BigQuery is not real time. Technically, you will upload your sheets to BigQuery (all locked under your accounts) and then you will connect to BigQuery from Power Query (Power BI) to get your data. Use ODBC connector for Excel or native BigQuery connector for Power BI to connect to your tables in BigQuery. ![]() Configure the BigQuery Uploader to upload your Google Sheet to BigQuery to the dataset which you created in step #5.Install BigQuery Uploader for Google Sheets for your Google Account.Make yourself BigQuery admin in the Google Cloud Project.If you absolutely need to keep your Google Sheet private, then this is the process: Let’s look at both options in more detail. Insecure option – you’ll have to make your Google Sheet public so anyone with the link can access it but the process is relatively easy.Secure option – you’ll be able to keep the Google Sheet private but the process is a bit cumbersome.You want to be using the reference sheet stored in Google Sheets since it is always the latest and the only correct version.You would like to use this reference sheet as data source in Power Query (Power BI).You store reference sheets via Google Sheets files where multiple people can work at the same time.Google Sheets have replaced Excel in a lot of companies so how do Google Sheets get along with Power Query (Power BI)? Actually pretty well.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |