Dear community I am following this tutorial https://learn.microsoft.com/en-us/azure/data-explorer/azure-data-explorer-dashboards#share-dashboards and trying to shae a dashbaord created in Azure Data Explorer, however, when adding members, either with view or edit rights, the former cannot open the shared dashboard, receiving the error: "Error loading dashboard "xyz". You are not authorized to view dashboard". Is there anytihng in addition to what explained in the tutorial that is needed? Note that I am using the free Azure Data Explorer cluster. Many thanks in advance. Best.

@Matteo Traina - Thanks for the question and using MS Q&A platform. It is possible that the issue you are experiencing is related to permissions. When you share a dashboard in Azure Data Explorer, you need to ensure that the users you are sharing it with have the appropriate permissions to view or edit the dashboard. To troubleshoot this issue, I would recommend the following steps: Check the permissions of the users you are sharing the dashboard with. Ensure that they have been granted the appropriate permissions to view or edit the dashboard. You can do this by navigating to the Azure portal, selecting your Azure Data Explorer cluster, and selecting the "Access control (IAM)" tab. Check the permissions of the dashboard itself. Ensure that the dashboard has been shared with the appropriate users and that they have been granted the appropriate permissions to view or edit the dashboard. You can do this by navigating to the Azure portal, selecting your Azure Data Explorer cluster, and selecting the "Dashboards" tab. Ensure you have adequate permissions. If you don't, you'll get a response of unauthorized . For more information about permissions, see Manage database permissions . If necessary, work with your cluster administrator so they can add you to the appropriate role. If you are still experiencing issues after following these steps, please provide more information about your Azure Data Explorer cluster and dashboard configuration so that we can further troubleshoot the issue. Hope this helps. Do let us know if you any further queries. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Azure Data Explorer - cannot share dashboard

Accepted answer

PRADEEPCHEEKATLA 90,506 Reputation points

2024-03-11T04:54:57.2633333+00:00
@Matteo Traina - Thanks for the question and using MS Q&A platform.

It is possible that the issue you are experiencing is related to permissions. When you share a dashboard in Azure Data Explorer, you need to ensure that the users you are sharing it with have the appropriate permissions to view or edit the dashboard.

To troubleshoot this issue, I would recommend the following steps:

Check the permissions of the users you are sharing the dashboard with. Ensure that they have been granted the appropriate permissions to view or edit the dashboard. You can do this by navigating to the Azure portal, selecting your Azure Data Explorer cluster, and selecting the "Access control (IAM)" tab.

Check the permissions of the dashboard itself. Ensure that the dashboard has been shared with the appropriate users and that they have been granted the appropriate permissions to view or edit the dashboard. You can do this by navigating to the Azure portal, selecting your Azure Data Explorer cluster, and selecting the "Dashboards" tab.

Ensure you have adequate permissions. If you don't, you'll get a response of unauthorized. For more information about permissions, see Manage database permissions. If necessary, work with your cluster administrator so they can add you to the appropriate role.

If you are still experiencing issues after following these steps, please provide more information about your Azure Data Explorer cluster and dashboard configuration so that we can further troubleshoot the issue.

Hope this helps. Do let us know if you any further queries.

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Please sign in to rate this answer.
Matteo Traina 40 Reputation points

2024-03-11T17:26:59.0866667+00:00

Dear PRADEEPCHEEKATLA

Thanks for your reply: regarding your suggestion, only the second one is applicable, so permission on the dashboard and I confirm those are set, at least from my understanding, correctly.

However the permission is set of a user marked as name#EXT#email if this makes any difference.

Bear in mind I am using the free cluster, so from the portal I do not see this but I open it separately.

Any other suggestion is appreciated.

Thank you.

PRADEEPCHEEKATLA 90,506 Reputation points

2024-03-12T04:59:51.37+00:00

@Matteo Traina - Could you please share the screenshot of the permission you had on the cluster and the database?

Matteo Traina 40 Reputation points

2024-03-13T18:39:21.2866667+00:00

@PRADEEPCHEEKATLA I do not see how to retrieve this information: can you please confirm whether this is actually possible with the free cluster and if so, kindly guide me on how to do so?

Thank you.

PRADEEPCHEEKATLA 90,506 Reputation points

2024-03-14T05:02:44.0833333+00:00

@Matteo Traina - With ADX free cluster I'm able to view the dashboards created, could you please share more details on how you are accessing the dashboard and screenshot of the error message which you are experiencing?

Matteo Traina 40 Reputation points

2024-03-14T21:06:28.0866667+00:00

Hi @PRADEEPCHEEKATLA

I am able to see the dashboard, what I am not able to do is to share it with someone else: can you do that?

Thanks.

PRADEEPCHEEKATLA 90,506 Reputation points

2024-03-18T04:55:31.6333333+00:00

@Matteo Traina - To access the dashboard, a dashboard viewer needs the following:

Dashboard link for access

Dashboard permissions

Access to the underlying database in the Azure Data Explorer cluster

For more details, refer to ADX - share dashboards.

Matteo Traina 40 Reputation points

2024-03-19T15:12:47.88+00:00

Thank you PRADEEPCHEEKATLA-MSFT what is missing the the third point you mentioned: do you know how to provide access to the underlying database to an external user, with the free ADX cluster?

PRADEEPCHEEKATLA 90,506 Reputation points

2024-03-21T04:11:13.2166667+00:00

@Matteo Traina - Did you get a chance to check the referred document?

Matteo Traina 40 Reputation points

2024-03-21T11:19:10.6166667+00:00

PRADEEPCHEEKATLA-MSFT I did, but I am still missing the step to give DB permission in a free ADX cluster.

Matteo Traina 40 Reputation points

2024-03-21T11:23:06.8366667+00:00

PRADEEPCHEEKATLA-MSFT I did, I still do not know how to give access permission to a DB in a free ADX cluster.

I believe that is the crucial part, because you cannot go via Azure portal.

Is there a way to do so directly from the ADX web interface?

Thanks.

PRADEEPCHEEKATLA 90,506 Reputation points

2024-03-25T06:24:41.5133333+00:00

@Matteo Traina - Could you please share the screenshot of Azure Data Explorer - cannot share dashboard? As said earlier, you can share the sample dashboard from the free cluster as shown below:

And also, you can manage the permissions of the dashboard as shown below:

Hope this helps. Do let us know if you any further queries.

Matteo Traina 40 Reputation points

2024-03-30T22:31:36.3366667+00:00

Hi PRADEEPCHEEKATLA-MSFT I actually receive an error when trying to fetch the name of the users to be added, do you have any suggestion? Thanks.

Matteo Traina 40 Reputation points

2024-03-31T20:42:16.19+00:00

Hi PRADEEPCHEEKATLA-MSFT

Nevermind, today the tool is fetching the names, however I (think I) now understand the issue: I managed to share the dashboard with a user I created (first selection under "New user") but not ith an external user I invited (second selection).

Could you please confirm whether this is actually not possible, with ADX, so sharing a dashboard with an external user?

Thanks.

PRADEEPCHEEKATLA 90,506 Reputation points

2024-04-01T04:29:34.7133333+00:00

@Matteo Traina -

Unfortunately, Cross tenant sharing is not possible today with ADX dashboards, but as per the discussion with product team, it is in the roadmap, but we do not have an ETA at the moment.

As a workaround, you may achieve this by adding guest user accounts in you AAD and share the dashboards.

Here is an existing feature request logged by a different user. I would encourage you to please up-vote and comment on it to increase the priority of the request. Share Dashboards- Provide Cross Tenant Sharing of ADX Dashboard

Hope this will help. Please let us know if any further queries.

Matteo Traina 40 Reputation points

2024-04-01T07:31:24.3266667+00:00

Thank you PRADEEPCHEEKATLA-MSFT, I have followed your suggestion.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Azure Data Explorer - cannot share dashboard

0 additional answers

Your answer