AI/BI Dashboards

[jonh]

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

[TheShua · Accepted solution]

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.

[jonh]

Hello,

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

[jonh]

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.

[TheShua]

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.

[jonh]

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.

[TheShua]

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