Here's your Data + AI Summit 2024 - Warehousing & Analytics recap as you use intelligent data warehousing to improve performance and increase your organization’s productivity with analytics, dashboards and insights. Keynote: Data Warehouse presente...
Excel suddenly started automatically formatting data (convert everything to text) when loading from the new Azure Databricks Excel plug-in. I can still see my default formatting in the Databricks sideload. Just wondering if this behaviour was caused...
Hi @Hubert-Dudek I am getting following error: METRIC_VIEW_WINDOW_FUNCTION_NOT _SUPPORTED The metric view is not allowed to use window function (...) With the following definition:- name: Sales net Total- expr: SUM(MEASURE(`Sales net`)) OVER())Howeve...
Hi @wrosa, The error you are seeing (METRIC_VIEW_WINDOW_FUNCTION_NOT_SUPPORTED) is expected behavior. Metric views do not allow raw SQL window functions like SUM(...) OVER() directly in a measure's expr definition. This is by design because metric vi...
Hi, I try to embed my dashboard in Databricks Notebook as some_html = """ <iframe src="...." width="100%" height="600" frameborder="0"> </iframe> """ displayHTML(some_html) then I get an error of the form: This dashboard is unavailablePlease...
Hi @vvanag, What you’re trying to do is understandable, but I wouldn’t recommend embedding an AI/BI dashboard back into a Databricks notebook with displayHTML and a raw iframe. The documented embedding path for AI/BI Dashboards is to embed them in an...
The below code works fine in Colab/VSCodium/JupyterNotebookimport ipywidgets as widgets from IPython.display import display, HTML output = widgets.Output() with output: display(HTML(some_html)) outputBut it does not work in Databrickstestme.ht...
Hi @vvanag, What you’re seeing is expected to some extent in Databricks Notebooks. Databricks supports ipywidgets, but it doesn’t guarantee full Jupyter or Colab parity, and there are a few documented limitations on how widgets render and behave in n...
Hi, i have an error with the excel pluging.It was working fine until today. I can login and browse the catalog but I get an error when trying to query any data. It seems like its sending in a blank warehouse id. I have choosen a warehouse and its run...
The blank warehouseId in the request payload is the confirmed root cause. This means the Excel connector is successfully displaying your warehouse selection in the UI but failing to bind it to the query execution context. This is a known regression p...
I created an iceberg table within databricks and shared it via delta sharing with tokenThen I use curl command to access it with iceberg endpoint like this:curl -X GET \-H "Authorization: Bearer ***"\-H "Accept: application/json" \"https://ohio.cloud...
Thank you @rdokala , @aleksandra_ch BTW, can I share managed uniformed delta table to external Iceberg clients? I tried this but get the same error, my friend tried, seems fine. I don't know what's the difference.Best regards,Li
I was wondering if anyone has been able to display totals in a Table/Pivot visualization? Similar to what is possible in other BI tools?If I have a table with a bunch of rows and one of the columns is Total Cost, I want to be able to show a Total at ...
Hi,Is there a way to add a grand total to a table visualisation in a Databricks dashboard, based on the latest updates?In a pivot table, I can add a grand total row; however, the issue is that doing so compromises the sorting functionality.
Hi,We're building an automated data quality testing framework for AI/BI (Lakeview) dashboards. Our goal is to validate that dashboard widgets display correct data without using UI automation (Selenium/Playwright don't work reliably due to React dynam...
Thanks for u detailed answer on the dashboard validation testing. Hi,We also need to perform performance testing and concurrency testing of AI/BI (Lakeview) dashboards at the browser level — measuring actual page load times, time-to-interactive, and ...
I have a job where I am refreshing my power bi semantic model, now my commpany change the workspace from Premium to Fabric, I am receiving this error message:Run failed with error message System error occurred during execution of task Power BI Task: ...
Hi @carlos_tasayco , According to docs:“Any workspace migrated from a PPU environment to a non-PPU environment (such as Premium or shared environments) must have its datasets refreshed before use. Reports opened after such migrations without being re...
Hi team, My work involves building dashboards that provide key insights to stakeholders. I am currently using the AI/BI dashboard functionality and seemed to have hit a limitation that I'm hoping someone can help me work around. One of the visualizat...
Hi,The text color on all my dashboards widgets are changing automatically resulting in users not being able to see the text at all. is there a current bug around this, and when will it be resolved?
You can enforce custom colors instead of default Auto Colors for Font Color, Background & Border. You can set them manually (set colors based on users request) instead of leaving it to Auto at the widget & dashboard level. You can publish to push the...
So we got the Lakeflow Connect set up with Jira working and so far so good. But when running the ETL pipeline to inject Jira data into Databricks, there's one table (isssue_with_deletes) fails due to the following error (partially shown). We have f...
Great question — and your confusion is completely understandable. Let me clarify exactly what's happening here.Root CauseYour diagnosis is correct. Issue deletes are only tracked if the authenticating user (i.e., the Jira account used during the OAut...
Hi community, As the title says, I have been checking the documentation, but I could not find clear references to my question.I am working in a project, and I need to change all the plots fonts to match a specific brand. All plots are generated with ...
Manually updating each plot would definitely get messy at scale. Using global font configuration seems like the cleaner approach for maintaining consistent branding across all visual outputs.
Hi all,I’m trying to implement CI/CD for Databricks AI/BI dashboards using Declarative Automation Bundles, following guidance published by Databricks.The documentation recommends exporting dashboards as .lvdash.json using databricks bundle generate, ...
hi @playnicekids , You've hit a known dev-UX gap. dataset_catalog and dataset_schema on the dashboard resource are the intended parameterization mechanism, but they only resolve at bundle deploy time, which is why workspace editing of an unqualified ...
I have an XML string in my table and I want to extract a full node from it using SQL functions, without needing to parse it in full i.e. from '<a><b><c>c1</c></b></a>' I want '<b><c>c1</c></b>' (preferably) or '<c>c1</c>'.What little I can find that ...
Thanks very much. I had over-simplified my example perhaps, and got stuck on the idea of using xml functions, particularly because I'm converting existing SQL from another DB, and wasn't being open-minded enough.The actual data has multiple instance...
