Forum Discussion

JH-Fabrico's avatar
JH-Fabrico
New Member
1 year ago
Solved

Error when trying to create a dashboard in Fabric with data contained in a table of a KQL database

Hello. I tried to create a dashboard in Fabric by the instructions in the "Create a real-time dashboard" section of this page:    mslearn-fabric   However, I got the following error message:   ...
data engineering
  • v-veshwara-msft's avatar
    v-veshwara-msft
    1 year ago

    Hi JH-Fabrico ,
    Thank you for the update. It’s great to hear that you were able to create a real-time dashboard successfully.

    I followed the same steps using the same dataset and was able to add a tile from a queryset successfully without encountering any errors. I have attached screenshots for reference.
    1. Add a tile


    2. KQL Query








    3. Run the Query 


    4. After Applying changes 

     

    Since the issue persists on your end, please try the following:

    1. Run the same query in a separate KQL editor to check for any errors.
    2. Clear your browser cache or try a different browser/incognito mode.
    3. Ensure there are no network restrictions that might be affecting the query execution.

    If the issue continues, could you share the exact query you used and any additional error details. This will help us investigate further.
    Hope this helps.

    Please mark the helpful reply as Accept as Solution to help others find easily and a Kudos would be appreciated.

    Best Regards,
    Vinay

v-veshwara-msft's avatar
v-veshwara-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi JH-Fabrico ,

Thank you for reaching out regarding the error you encountered while creating a real-time dashboard.

The error message "Failed to fetch data source schema. Unknown error" generally points to issues with the data source or configuration. Please consider the following:

  1. Ensure that the connection to your data source is properly configured. Double-check the credentials and connection string to ensure they are correct, and confirm that the data source is accessible.
    Could you also confirm if you're using the same sample data source provided in the documentation or a different one?

  2.  Confirm that you have the necessary permissions to access the schema of the data source. If you're working in a shared environment or with a managed dataset, please ensure that you have the appropriate access rights.

  3. Make sure the schema of the data source is correctly defined and available for use in your workspace. If you're using a real-time data source, confirm that it supports the necessary streaming capabilities.

For users to create real-time dashboards, it’s important that the relevant settings are enabled at the tenant level. Please ensure the following:
      The real-time data feature must be enabled in your tenant settings. If you have admin access, navigate to the Admin Portal and enable the Users can create Real-Time Dashboards.


Please refer these links for additional details:

Create a Real-Time Dashboard - Microsoft Fabric | Microsoft Learn

Real-Time Dashboard permissions (preview) - Microsoft Fabric | Microsoft Learn

 

Once these settings are correctly configured, you should be able to create and manage real-time dashboards.

If you continue to experience issues, please share any additional details or error logs to assist further in troubleshooting.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

Regards,
Vinay.

AndersASorensen's avatar
AndersASorensen
Icon for Helper I rankHelper I
1 year ago

I have the same issue, and I cant find this setting in the admin portal under tenant settings