Stack Overflow
Stack Overflow

Questions tagged [looker-studio]

1796 questions
6
votes
1 answer

BigQuery error: Access Denied: BigQuery BigQuery: Permission denied while getting Drive credentials

I am trying to connect a Data Studio report to a table and to a view from BigQuery. In BigQuery the table receives the data from a GoogleSheet that is located in my Drive, the view is querying this same table but adds some new fields. When I try to…
Harvey
  • 213
  • 1
  • 3
  • 12
6
votes
2 answers

View report using an access token

I'm building a web application that embeds a data studio report. The challenge I'm running into is that I would like to allow access to the report only from inside the web application. For this, what I have in mind is not to share the report and…
Morfinismo
  • 4,985
  • 4
  • 19
  • 36
6
votes
1 answer

Use the first and last day of Data Studio Date Range in calculation

Example Table: Date, CustomerID 2020-01-01,a 2020-01-01,b 2020-01-01,c 2020-01-02,a [...] 2020-01-31,a 2020-01-31,b 2020-01-31,c 2020-01-31,d 2020-02-01,a 2020-02-01,b [...] Let's say I have a date range set on 2020-01-01 - 2020-01-31. Id like to…
David Beck
  • 975
  • 8
  • 12
6
votes
1 answer

How to connect google data studio to postgres serverless on AWS using ssh tunnel?

I have my database on AWS serverless and I can only connect to it outside the VPC via ssh tunnel, I need to connect from Google Data Studio, does anyone have any solution?
Jhonatan Acelas Arevalo
  • 510
  • 6
  • 11
6
votes
1 answer

How do I set up a Google Analytics Custom Dimension as a dimension filter in Data Studio report?

Background I've created a Data Studio report that looks to a Google Analytics property. In this Google Analytics property I've created custom dimensions which are being populated as I need. I want to set up a dimension filter on the report in Data…
Neil
  • 601
  • 4
  • 20
6
votes
2 answers

Can we create Data Studio reports using Python?

I am trying to automate the process of getting data from Big Query tables and creating a report in Data studio. Is there any python code, APIs or some other method which will be able to address this issue. Thanks in advance.
Dhanush Thirugnana
  • 69
  • 1
  • 1
  • 2
6
votes
3 answers

Inaccurate COUNT DISTINCT Aggregation with Date dimension in Google Data Studio

When I aggregate values in Google Data Studio with a date dimension on a PostgreSQL Connector, I see buggy behaviour. The symptom is that performing COUNT(DISTINCT) returns the same value as COUNT(): My theory is that it has something to do with…
Paulo
  • 416
  • 4
  • 11
6
votes
1 answer

date format issue with google data studio (postgres)

I'm using Postgres connector from a cloud based server to Google Data Studio, to pull in all my Zoho CRM data so that I can build some dashboards in Google Data Studio. Problem is, for some odd reason it's refusing to accept some of my date fields,…
nocoder89
  • 61
  • 3
6
votes
2 answers

How to connect Google Data Studio to AWS Athena?

I need to connect Google Data Studio to AWS Athena. One way to do that is with a the JDBC URL connection option. I used the following parameters in the Database Authentication form and I got the error shown…
Sam
  • 11,799
  • 9
  • 49
  • 68
6
votes
1 answer

Data Studio Community Connector error: The number of columns in the data does not match the number in the schema.

When I try to explore my data source fetched by a custom connector, I encounter a System error: 593d1fe0. The number of columns received in the data returned from the community connector does not match the number of columns requested by Data…
Frédéric P.
  • 91
  • 4
6
votes
4 answers

Connect Google Data Studio to Local Mysql Server

I have started using Google's Data Studio I found it very easy to turn the Excel data into Intuitive Business Dashboards with little or no coding skills. But I have a problem here, whenever I try to connect to Mysql DB (running on my local system)…
MAX
  • 1,562
  • 4
  • 17
  • 25
6
votes
1 answer

COUNTIFS function in Google Data studio

I have 2 columns called continent and completion and i would like to calculate completion % for each continent based on below data. This was defined in excel using COUNTIFS() function Can we achieve this In data studio?? Completion % formula is…
user9203730
6
votes
3 answers

How do I create a "Users by time of day" heatmap in Google Data Studio?

I want to create a heatmap in Google Datastudio similar to the "Users by time of day" heatmap in Google Analytics. This is how it looks in Google Analytics. THE FIRST PROBLEM is that when I have my columns as the days of the week, it sorts on…
SnowboardBruin
  • 3,645
  • 8
  • 36
  • 59
6
votes
2 answers

Connection from google data studio to google cloud sql postgres with SSL

I've created one instance on Google Cloud with PostgreSql and I've connected the data studio with this database adding all the addresses specified in white list specified at link…
Michele Ferrari
  • 63
  • 1
  • 4
6
votes
3 answers

How can I sort a table in Datastudio by multiple columns?

I have a report in Datastudio that consists of multiple columns. I'd like to sort the rows based on multiple columns. Is it possible to do this?
Jeremy Lewi
  • 6,386
  • 6
  • 22
  • 37
1 2
3
…
99 100