Forum Widgets
Latest Discussions
Parameter controls are not showing Display text
Hi, After a recent update to the Azure Data Explorer Web UI, the Parameter controls are not displaying correctly. The Display Text for parameters is not shown by default; instead, the raw Value is displayed until the control is clicked, at which point the correct Display Text appears. Could you please investigate this issue and provide guidance on a resolution? Thank you,
KQL Query output limit of 5 lakh rows
Hi , i have a kusto table which has more than 5 lakh rows and i want to pull that into power bi. When i run the kql query it gives error due to the 5 lakh row limit but when i use set notruncation before the query then i do not get this row limit error on power bi desktop but get this error in power bi service after applying incremental refresh on that table. My question is that will set notruncation always work and i will not face any error further for millions of rows and is this the only limit or there are other limits on ADE due to which i may face error due to huge volume of data or i should export the data from kusto table to azure blob storage and pull the data from blob storage to power bi. Which will be the best way to do it?
ADX data receiving stop after sometime
I have very strange problem. I have IOT application where device send data to IOT hub, then it routed to event hub. There is function with trigger as azure function ,this function insert data in to ADX . I trace the event from device to event hub. I can see all data I can also see function get trigger ,no error.But in ADX empty record, no data from event. Just date field which add explicitly. Note- Again after some time I can see data in ADX (no change in ADX not even restart any service). Can any body have clue what exactly could be issue?
External Table in ADX
Hi, I'm trying to create an external table in ADX which uses a Synapse Analytics (SA) database view (called undelivered). The undelivered view itself is query data from a Cosmos analytical store I've create a user defined idenity Added the identiy to the ADX cluster, SA and Cosmos Updated the ADX database: .alter-merge cluster policy managed_identity[ { "ObjectId": "a3d7ddcd-d625-4715-be6f-c099c56e1567", "AllowedUsages": "ExternalTable" } ] Created the database users in SA -- Create a database user for the ADX Managed Identity CREATE USER [adx-synapse-identity] FROM EXTERNAL PROVIDER; -- Grant read permissions ALTER ROLE db_datareader ADD MEMBER [adx-synapse-identity]; GRANT SELECT ON OBJECT::undelivered TO [adx-synapse-identity]; From within SA I can "SELECT * FROM undelivered" and the correct information is returned But when I come to create the external table in ADX: .create-or-alter external table MyExternalTable ( Status: string ) kind=sql table=undelivered ( h@'Server=tcp:synapse-xxxxx.sql.azuresynapse.net,1433;Database="Registration";ManagedIdentityClientId=<key>;Authentication=Active Directory Managed Identity;' ) with ( managed_identity = "<key>" ) I get the error: Managed Identity 'system' is not allowed by the managed_identity policy for usage: ExternalTable So even with me specifying the managed identity I want to use it is still trying to use the system one. How can I get the external table created with the correct managed identity? Any questions please just ask ThanksIssue with mysql_request Plugin on Dashboard
Today, while using the Azure Data Explorer dashboard, we noticed that the mysql_request plugin is no longer functioning as expected. Specifically, we are encountering the following error message: evaluate mysql_request(): the following error(s) occurred while evaluating the output schema: The 'mysql_request' plugin cannot be used as the request property request_readonly_hardline is set. Interestingly, the plugin works perfectly fine within the Query tab. However, when called from the dashboard, it fails to execute. This issue was not present yesterday, as it was working seamlessly at that time. Looking further, I realize that in Query Tab, the ADX UI send with "Options":{ "request_readonly_hardline": false } And the request from Dashboard such as Table, Chart. It send with request_readonly_hardline: true Is this on purpose? Thanks
Kusto ADX plugin for Azure Devops (dashboards)
The existing kusto plugin that we are using in our Azure DevOps (Kusto and Application Insights Widget - Visual Studio Marketplace) is broken and there is no ETA on a fix. Would be great if one of you could point me to a work around/a different plugin that we could use to access kusto data from the devops dashboards.
[New post] Microsoft Fabric real-time analytics exploration: Home Assistant integration
Now, your Home Assistant can send telemetry to Microsoft Fabric using the EventStream Custom App source acting as an Azure Event Hub. Then, use KQL to render historical charts. Christmas time seems to be the most wonderful time of the year for IoT Developers. The combination of both having some spare time and getting geeky gifts (or buying them for yourself) makes it the perfect moment to do some home automation. So, let's have some fun! Check out the full story of https://sandervandevelde.wordpress.com/2023/12/20/microsoft-fabric-real-time-analytics-exploration-home-assistant-integration-christmas-edition/ about Real-Time Analytics in 10+ parts. https://www.linkedin.com/feed/hashtag/?keywords=mvpbuzz&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A7143383503651446785[New post] Microsoft Fabric real-time analytics exploration: Managed Grafana integration
The goal for today is to render real-time ingested Eventstream IoT data available in a Managed Grafana instance. https://sandervandevelde.wordpress.com/2023/12/05/microsoft-fabric-real-time-analytics-exploration-managed-grafana-integration/[New post] Microsoft Fabric real-time analytics exploration: Eventstream Custom apps integration
Learn how customs apps can be integrated in Microsoft Fabric using EventHub-compatible public endpoints living in Fabric Eventstream, both for ingress and egress. These are part eight and nine in a series of posts about Fabric for IoT Engineers. Check out Ingress https://sandervandevelde.wordpress.com/2023/12/02/microsoft-fabric-real-time-analytics-exploration-eventstream-source-for-custom-app-ingress/%20 and Egress https://sandervandevelde.wordpress.com/2023/12/02/microsoft-fabric-real-time-analytics-exploration-eventstream-destination-for-custom-app-egress/#mvpbuzz
