Error Creating Shortcut access to External Kusto Db using Eventhouse

[adsadasa]

Hello, I am facing a issue where I am not able to create a Eventhouse shortcut to an external Kusto Cluster inspite of having admin access to the Kusto cluster. I am trying to create it in my workspace so there is no Fabric workspace access issue. The error message states that contributor or above access to the Kusto Cluster is needed. As mentioned, I already have admin access.

[adsadasa]

Yes, I followed this link and tried both using invitation and by directly adding the cluster Url.

I was told that it is currently not possible to change the region of a trial subscription as it is tied to the tenant's region. 

[v-tsaipranay · Accepted solution]

Hello @adsadasa ,

Thank you for your update and for clarifying your progress. It’s great to hear that adding Kusto Contributor access resolved part of the issue with recognizing the source cluster.

Since you have confirmed that you followed the steps in the documentation and still encountered the region incompatibility issue, it appears that the problem is due to the limitation of the trial subscription. Trial subscriptions are tied to the tenant’s region, and you cannot change the region of the trial workspace.

To resolve this issue, here are a few steps you might consider:

• If possible, consider upgrading to a paid subscription, which allows you to select the region for your workspace. This will enable you to match the region of your Kusto cluster and Eventhouse shortcut.
• If upgrading isn’t feasible, you may need to create a new workspace in a region that matches your Kusto cluster. Note that this option might require a paid subscription.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you. 

[v-tsaipranay]

Hi @adsadasa ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-tsaipranay]

Hi @adsadasa ,

I wanted to follow up on our previous suggestions regarding the issue you mentioned. We would love to hear back from you to ensure we can assist you further.

If my response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.

Thank you.

[v-tsaipranay]

Hi @adsadasa ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[adsadasa]

Thank you for the resolution options provided. I was able to make some progress by adding the Kusto Contributor access in addition to admin acces to the Source cluster. Using invitation token method, the Eventhouse shortcut is now able to recognize the source cluster but there is now an error stating the the source kusto cluster and the Eventhouse shortcut in Fabric are in different cloud regions causing an incompatibility issue as shown below. Can you please share some steps on how to change the trial version workspace to 'US West' instead of 'US West Central'. 

[v-tsaipranay]

Hello @adsadasa ,

Thank you for your patience and for attempting to implement the steps I provided earlier.

Could you please confirm that you have followed the steps outlined in the link below and are still encountering the error:

https://learn.microsoft.com/en-us/fabric/real-time-intelligence/database-shortcut?tabs=workspace#pre...

Thankyou.

[v-tsaipranay]

Hi @adsadasa ,
Thank you for reaching out to Microsoft fabric community forum regarding the issue you are experiencing with creating a shortcut to an external Kusto Cluster in Eventhouse.

You mentioned that although you have admin access to the Kusto Cluster, you are getting an error. This may be due to, although you have admin access, the system might not recognize it as sufficient for creating shortcuts. Certain operations may require explicit contributor-level permissions. It may be necessary to review and adjust the permission settings for your account on the Kusto Cluster.

Please consider the following steps to address this issue :

• Verify that your account is assigned as a contributor or holds a higher-level role on the Kusto Cluster. Be aware that permissions at different levels (workspace vs. cluster) can sometimes cause confusion.
• Verify if there are any item-level access controls that could limit your ability to create shortcuts. You may need to modify these settings or consult with an administrator responsible for managing these access controls.
• If you have access to the Eventhouse service settings, check if there are any additional permissions or configurations needed within Eventhouse for accessing external Kusto clusters.
• Ensure that there are no network policies or firewalls that might be restricting access to the Kusto cluster from Eventhouse.

Please refer the following link for more detail information:

https://learn.microsoft.com/en-us/fabric/real-time-intelligence/database-shortcut?tabs=workspace#cre...

If the issue persists after verifying your permissions and reviewing documentation, I suggest you raise a support ticket so they can assist in addressing the issue, please refer below link on how to raise a contact support or support ticket.

https://learn.microsoft.com/en-us/power-bi/support/create-support-ticket

I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

Thank you. 

[v-tsaipranay]

Hi @adsadasa ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.