Looker Report Erroring Out Using Filters & BQ Source

[jostkyle]

Hi all,

We are running into an issue with our Looker Studio report. We are using BQ as the sole data source. 

We are using "percent of max" in our reporting for the metrics and have a dropdown filter where the user can choose a landing page. We are erroring out in our report when a user chooses a landing page that contains "imaging" (e.g. www.yourdomain.com/imaging/locations/). I believe that the issue is coming from somewhere in BQ do to the error message we are receiving - "This data source was improperly configured", but I have also read about issues using Percent of Max.  

Anyone seen something similar? Ideas on how to resolve the issue?

Thank you in advance. Screenshots below.

Using Percent of Maxexample URL that will break reports when filterederror message & report when filtered

[Aris_O]

Hi @jostkyle, 

Welcome to Google Cloud Community.

Here are some checking you may try to perform to resolve the error you have encountered:

• Verify your data source's configuration in Looker Studio to make sure it is set up correctly and has all the required permissions.
  
  
• Verify if the problem persists, test your report using a more straightforward calculation, such as a straight percentage or a simple average.
  
  
• Verify whether the problem is unique to Looker Studio, consider running the same report using a different data source or visualization program, such as Google Data Studio.
  
  Hope this would help you.