topic AI/BI Dashboards in Warehousing & Analytics

AI/BI Dashboards

jonh — Thu, 20 Mar 2025 13:18:58 GMT

We need to build some BI dashboards for a client. We are having issues to find a way to Download a dataset behind a chart. Ideally the dataset subset after appliying a set of filters. The documentation says here that the full dataset could also be downloaded but the Download options are not in the menu, only up to Delete. Although this is not the best solution, but a starter to enable a selected group of users with Downloads, but how to make it work?

https://docs.databricks.com/aws/en/dashboards/datasets/

This the Kebab menu from a table chart

I also tried the option to Save the data subset into DBFS and share the link to download. However, the SQL in datasets cannot copy into the DBFS

Re: AI/BI Dashboards

Shua42 — Thu, 20 Mar 2025 20:24:32 GMT

Hey there Jonh,

Can you check to see if SQL results download is enabled? This can be accessed in the workspace admin settings through Settings > Workspace Admin > Security > Egress and Ingress. Enabling this if it wasn't already may resolve this issue.

Re: AI/BI Dashboards

jonh — Thu, 20 Mar 2025 22:29:28 GMT

Hello,

Thank you very much, this sorted the issue with the downloads.

Re: AI/BI Dashboards

jonh — Thu, 20 Mar 2025 22:42:21 GMT

I have one more issue, I have some users with this access level:

But those users can run SQL operations from Notebooks in shared or personal compute resources. However, they cannot execute SQL queries behind the AI/BI Dashboards, this is the error:

The problem is solved when you promote the users into Admin users:

This is not ideal when you want to have users with view only access.

Re: AI/BI Dashboards

Shua42 — Thu, 20 Mar 2025 22:49:33 GMT

When you publish the dashboard, you can select 'embed credentials' so that users without direct access to the data can still view and render the visuals. Otherwise, you will need to grant access to the underlying tables to the users you want to have access to it.

Re: AI/BI Dashboards

jonh — Fri, 21 Mar 2025 00:49:50 GMT

Ok, We'll try that. However, the issue was reported by both Develpers and Guest users

Guests Group Entitlements

Developer Group Entitlements

Devs with SQL access wanted to develop a dashboard but their queries lacked permissions, hence they have to be promoted to Admins despite the above group entitlement profile.

Re: AI/BI Dashboards

Shua42 — Fri, 21 Mar 2025 13:21:46 GMT

I don't think promoting them to Admins is the best approach. You should be able to assign them to appropriate groups and set permissions to they data you want devs and guests to have query access to, respectively. Then, in terms of sharing the dashboard once published, there is more on how to manage permissions here: https://docs.databricks.com/aws/en/dashboards/admin/#user-and-group-management-for-dashboard-sharing