https://community.databricks.com/t5/data-engineering/visualizations-failing-to-show/m-p/65670#M32890 <P>To be clear: the data is correct in the table. It's also correctly displayed if I click "edit visualization." It's only the re-run visualization in the notebook / dashboard that is empty when I update a widget to use a different value.</P><P>The code looks something like:</P><LI-CODE lang="python">location = dbutils.widgets.get("locations") ids = spark.read.table("production.gold.devices").select("id").where(f"location = '{location}'").distinct().toPandas()['id'] dbutils.widgets.dropdown('device_ids', values=ids, default='', label='Device IDs') # ... Another cell device_id = dbutils.widgets.get('device_ids') spark.read.table("production.gold.data").where(f"location = '{location}' AND device_id = '{device_id}' AND create_time &gt; now() - INTERVAL 30 DAYS") # PowerBI Linear graph visualization</LI-CODE><P>&nbsp;</P> Fri, 05 Apr 2024 21:04:19 GMT Erik_L 2024-04-05T21:04:19Z https://community.databricks.com/t5/data-engineering/visualizations-failing-to-show/m-p/65637#M32872 <P>I have a SQL query that generates a table. I created a visualization from that table with the UI. I then have a widget that updates a value used in the query and re-runs the SQL, but then the visualization shows nothing, that there is "1 row," but if I select the table it shows all the rows and if I click "edit visualization" it shows the correct visualization. What's wrong with visualizations?</P><P>&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Screenshot from 2024-04-05 10-23-03.png" style="width: 999px;"><img src="https://community.databricks.com/t5/image/serverpage/image-id/6940i2D96BA035E8D63FA/image-size/large/is-moderation-mode/true?v=v2&amp;px=999" role="button" title="Screenshot from 2024-04-05 10-23-03.png" alt="Screenshot from 2024-04-05 10-23-03.png" /></span></P> Fri, 05 Apr 2024 17:29:47 GMT https://community.databricks.com/t5/data-engineering/visualizations-failing-to-show/m-p/65637#M32872 Erik_L 2024-04-05T17:29:47Z https://community.databricks.com/t5/data-engineering/visualizations-failing-to-show/m-p/65670#M32890 <P>To be clear: the data is correct in the table. It's also correctly displayed if I click "edit visualization." It's only the re-run visualization in the notebook / dashboard that is empty when I update a widget to use a different value.</P><P>The code looks something like:</P><LI-CODE lang="python">location = dbutils.widgets.get("locations") ids = spark.read.table("production.gold.devices").select("id").where(f"location = '{location}'").distinct().toPandas()['id'] dbutils.widgets.dropdown('device_ids', values=ids, default='', label='Device IDs') # ... Another cell device_id = dbutils.widgets.get('device_ids') spark.read.table("production.gold.data").where(f"location = '{location}' AND device_id = '{device_id}' AND create_time &gt; now() - INTERVAL 30 DAYS") # PowerBI Linear graph visualization</LI-CODE><P>&nbsp;</P> Fri, 05 Apr 2024 21:04:19 GMT https://community.databricks.com/t5/data-engineering/visualizations-failing-to-show/m-p/65670#M32890 Erik_L 2024-04-05T21:04:19Z