Stack Overflow
Stack Overflow

Questions tagged [looker-studio]

1796 questions
5
votes
2 answers

How to securely embed a private Google Data studio report without a user needing a Google account

Is there any way to embed a private report (i.e. Link-Sharing set to OFF) in a site where the user does not have to be signed in to a Google account which has view permissions on the report? I understand from this piece of documentation that a…
Harry
  • 197
  • 3
  • 16
5
votes
1 answer

Google DataStudio cannot take parameter from URL, but could I use Google Apps Script Google Data Studio data connector to pass the parameter value?

I have a Google DataStudio Reports, with an "account ids filter", for example I may have 100 client accounts. I want to share this report with these 100 accounts. But each account should only see their own report. But Google DataStudio does not take…
searain
  • 3,143
  • 6
  • 28
  • 60
5
votes
0 answers

What is the best way to connect MS SQL server with Google Data Studio?

I have a huge database on MS SQL Server and I need to connect it to Google Data Studio to export some data via SQL query. Can you suggest me something?
Alex
  • 798
  • 1
  • 8
  • 21
5
votes
2 answers

Google Data Studio export to PDF and scheduled email

I am looking for a way to automate the process of exporting Google Data Studio report pages in PDF, save them on cloud account (eg. OneDrive) and then email the saved PDF report on a monthly basis. This Chrome plug-in will only export the report in…
pestislav
  • 51
  • 1
  • 6
5
votes
2 answers

Google Datastudio: Apply Date Range Filter for Two Different Date Columns of Date Source

I have a requirement to have date range filter which can be used for two different date columns of the data source(One at a time either through radio button to choose at which column date range should apply). Is it possible to achieve this in Google…
Mayank
  • 337
  • 2
  • 9
  • 22
5
votes
3 answers

Data Studio connector making multiple calls to API when it should only be making 1

I'm finalizing a Data Studio connector and noticing some odd behavior with the number of API calls. Where I'm expecting to see a single API call, I'm seeing multiple calls. In my apps script I'm keeping a simple tally which increments by 1 every…
Ben Collins
  • 321
  • 1
  • 2
  • 9
5
votes
2 answers

How can I check if strings match?

I have a Google Sheet document that I only have read access to. It has a set of workers in it. One of the fields is for "job location", and another is for "house location". When these fields don't match, the worker is "remote". I'm trying to add a…
Gustav Bertram
  • 14,591
  • 3
  • 40
  • 65
5
votes
1 answer

Pagination when data source is supporting multi page requesting

Does Google Data Studio Community connector support pagination? I work with an external data service. The service returns data page by page. It requires start and next parameters and it requires 2 req/sec. Can I override a method like getData or…
contributorpw
  • 4,739
  • 5
  • 27
  • 50
5
votes
2 answers

Data Studio query error when using Big Query view that joins tables

I've created a view to join two tables in Big Query. When I use that view as a data source in Data Studio I get a configuration error. The query used to create the view looks like this: SELECT emp.name, emp.gender, emp.age, pay.salary FROM…
Doug Couvillion
  • 1,071
  • 10
  • 13
4
votes
1 answer

Count how many customers have ordered 3 or more times in Google Data Studio

I have a data source added in Google Data Studio which is similar to the following: Order ID Date Customer ID Total 36252 1/1/2021 12:25:00 6565 $64.00 16805 2/1/2020 13:55:00 694 $32.00 16802 2/1/2020…
userza_312
  • 41
  • 3
4
votes
2 answers

Google Data studio can't find the bigquery dataset after moving to a different location

I have changed the location of several datasets in bigquery. The final names have not been changed after the operation. I can query them in the bigquery UI but data studio is raising an error (BigQuery error: Not found: Dataset xxx:yyy) It seems…
David Morales de Frias
  • 43
  • 4
4
votes
1 answer

Google Data Studio: How to join dates if they don't join automatically?

I am trying to join Google analytics page views to a salesforce connected dataset of email campaigns via a blended data set. As you can see from the screenshot below I have date fields in both cases, but I see now pairing key icon. I assume…
AdamJones
  • 652
  • 1
  • 15
  • 38
4
votes
0 answers

Where is the data studio report saved?

I am using Data stduio. Where is the created data stduio report saved? Not the data source. Not even in Google Drive. It doesn't seem to be saved in GCP either. You can only find the report list at…
Liam
  • 41
  • 1
4
votes
2 answers

Pruning BigQuery partitions with Data studio

I've got an almost identical scenario to this question: How to choose the latest partition in BigQuery table? With one additional complication. I need the result to display in Data Studio. The setup I've got a series of data sets which appear at…
Dominic Woodman
  • 719
  • 2
  • 8
  • 18
4
votes
1 answer

User NOT prompted for API KEY with getAuthType() = KEY - GOOGLE DATA STUDIO COMMUNITY CONNECTOR

I've been up and down the Google Data Studio Community Connector docs, as well as many open source examples. I've watched the videos numerous times, and read thoroughly. https://developers.google.com/datastudio/connector/auth?hl=en My prototype…
Adam Stetzer
  • 41
  • 1
1 2 3
…
99 100