Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
503 questions
1 answer
One of the answers was accepted by the question author.
Azure Data Explorer Web UI support for Personal Account
The following message is encountered when we shared out Azure Data Explorer dashboard to a personal Microsoft account. You are currently signed in with a personal Microsoft account, which is not currently supported in Azure Data Explorer Dashboards.…
asked 2022-03-02T03:59:25.23+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 53%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECE%3C/text%3E%3C/svg%3E)
Cheu Eng Yeow
71
Reputation points
accepted 2022-03-16T12:46:29.297+00:00
Cheu Eng Yeow
71
Reputation points
1 answer
One of the answers was accepted by the question author.
ADX - "Blob already received" in ingestion from event grid
Hi there, I have an ADX ingestion pipeline set up that populates a single table from two event grids sources. This is specified as suboptimal in docs (https://video2.skills-academy.com/en-us/azure/data-explorer/error-codes#category-blobalreadyreceived)…
asked 2022-03-14T15:32:02.993+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 14.000000000000002%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECS%3C/text%3E%3C/svg%3E)
Carlo Suriano
26
Reputation points
commented 2022-03-15T09:59:46.61+00:00
Carlo Suriano
26
Reputation points
1 answer
One of the answers was accepted by the question author.
IoT Central Data Export Destination Error
Hi, I was creating a destination for my data export on IoT Central through Data Explorer, however, I cannot get past this error. May I know what are the possible solutions to resolve the error?
asked 2022-02-22T03:32:33.093+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 14.000000000000002%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJG%3C/text%3E%3C/svg%3E)
Jonathan GOH
46
Reputation points
accepted 2022-03-14T07:54:23.723+00:00
Jonathan GOH
46
Reputation points
1 answer
Create a function which uses a materialized view
From one of my tables in my database I have created a materialized view which is mostly just an aggregated version of that table. Now I want to create a function that's able to use that materialized view, and perform some query on this. Creating this…
asked 2022-02-15T16:38:05.693+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 57.99999999999999%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SV
1
Reputation point
answered 2022-03-01T18:29:50.177+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 42%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Aman Sharma
1
Reputation point
1 answer
azure data factory copy activity Uri string is too long
I try to load a JSON file from Azure storage into Azure data explorer via Azure data factory. The file is in 'one-line', 'nested' JSON format. (about 5~10 MB) {"value":[{"col1":1, "col2":2},{"col1":11,…
asked 2022-02-17T03:18:12.76+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 75%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHS%3C/text%3E%3C/svg%3E)
Han Shih 施學翰
146
Reputation points
answered 2022-02-24T07:13:00.317+00:00
Han Shih 施學翰
146
Reputation points
1 answer
RowLevelSecurity on External Table
Can RowLevelSecurity policy apply to external table?
asked 2022-02-17T06:13:02.397+00:00
Cheu Eng Yeow
71
Reputation points
commented 2022-02-22T18:26:28.003+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,437
Reputation points Microsoft Employee
1 answer
Datamodel graphic in context of PurView / Data Catalog
I govern conceptional, logical and physical models in Azure Data Catalog / PurView. How can I get an grahical overview of a selection of related entities? Is there a tool available providing some functionality to arrange entities and relationsships? …
asked 2022-02-01T14:35:48.18+00:00
Heijo Hewel
21
Reputation points
commented 2022-02-18T19:35:28.103+00:00
KranthiPakala-MSFT
46,437
Reputation points Microsoft Employee
1 answer
Follow up question for https://docs.microsoft.com/en-us/answers/questions/692580/azure-data-explorer-table-access-policies.html
Could you also confirm if the below steps are appropriate. If I create a follower database. Will that incur to extra cost towards data being transferred to new DB ? Also does it mean a new cluster would also be formed ( as per ARM template). Or new…
asked 2022-01-30T16:10:17.733+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(118.4, 96%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Soumya Banerjee
126
Reputation points
commented 2022-02-17T09:22:54.657+00:00
ShaikMaheer-MSFT
38,321
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
DataSet does not return Data
Hi! I want to get data from an Access Database through a DataSet but all the tables appear to be empty. using(var x = new DataSet1()) { Console.WriteLine("Am intrat"); var l = x.Angajati_Detalii.FirstOrDefault(); …
Azure Open Datasets
Azure Open Datasets
An Azure service that provides curated open data for machine learning workflows.
25 questions
Azure Data Explorer
Azure Data Explorer
An Azure data analytics service for real-time analysis on large volumes of data streaming from sources including applications, websites, and internet of things devices.
503 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,584 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
849 questions
asked 2022-02-14T23:02:42.53+00:00
Radu Flesar
26
Reputation points
accepted 2022-02-15T22:25:48.773+00:00
Radu Flesar
26
Reputation points
1 answer
Bool Data Type issue in Kusto
Hi, I have a table called "ActivityStatus" and it has one column i.e. "Status" and its datatype is bool in Azure Data Explorer database. when i am inserting the data in it its working fine. .ingest inline into table…
asked 2022-02-04T07:26:22.533+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 12%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
ADX
156
Reputation points
commented 2022-02-15T01:32:03.397+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,376
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Why does Kusto | render timepivot bin to a single data point?
I am having trouble figuring out exactly how the timepivot from Kusto.Explorer splits horizontally the data slices. Created a demo query to illustrate the question: range dt from startofday(ago(25d)) to startofday(ago(1d)) step 1d | extend fx…
asked 2022-01-20T10:53:52.613+00:00
Kovács, Ferenc
61
Reputation points
commented 2022-02-11T07:20:52.45+00:00
Kovács, Ferenc
61
Reputation points
1 answer
One of the answers was accepted by the question author.
Bulk records to download from azure data explorer
Hi, I want to download/exporttoCSV logs/records from azure data explorer for past 3 months for one particular table for firewall. The criteria is pretty wide because of which the number of records for just 1 day is around 1Million for the required…
asked 2022-01-21T09:46:25.063+00:00
Soumya Banerjee
126
Reputation points
accepted 2022-02-01T18:15:49.503+00:00
Soumya Banerjee
126
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Data Explorer , Table access policies
Hi, 1) I have a database in adx which has multiple tables. I need to give access to only a FEW TABLES to the network team (part of the azure AD) and they should not be able to view or query the other tables in the database in ADX. How do I achieve…
asked 2022-01-12T15:46:44.02+00:00
Soumya Banerjee
126
Reputation points
commented 2022-01-29T07:57:05.597+00:00
Soumya Banerjee
126
Reputation points
1 answer
One of the answers was accepted by the question author.
Regex trim help in Azure Data Explorer
Hello, I have a Azure Data Explorer query that returns ID as part of it. The part of the query is like that: id = any_id, Since I'm using this ID as a placeholder in an automation process, I nee to strip the ID from anything but numbers…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 60%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
carbon black and sentinel
How do I receive carbon black logs into sentinel without AWS S3 bucket . Is it possible ? I want to send data from carbon black to adx for longer retention. We will separately send alerts from carbon black to another soar platform. But just for long…
asked 2022-01-27T09:23:09.107+00:00
Soumya Banerjee
126
Reputation points
commented 2022-01-28T18:04:13.51+00:00
JamesTran-MSFT
36,531
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Pivoting Data
Hi, I have my source data in a table called like "Test". and i want data like in the below format Parameter Name,LHPre-Turn,LHPost-Turn,RHPre-Turn,RHPost-Turn,Wheelset,EventUTCDateTime …
5 answers
I sucesfully had install SQL Server 18.10 But I don't see the object explorer in View Menu.
I have tried many option to make this visible but i don't see until now.
asked 2022-01-22T16:31:49.617+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 50%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
Hector Martinez
1
Reputation point
answered 2022-01-27T13:59:47.403+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
Tom Phillips
17,721
Reputation points
1 answer
One of the answers was accepted by the question author.
Detection of extra money by data explore from subcription
I have selected the virtual machine to be Eav4/Easv4 Series but it is also consuming Dv2/DSv2 Series, why ? It leads to consuming extra money please let me know how to avoid this
asked 2022-01-17T06:16:29.987+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 39%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
naaz kakria
41
Reputation points
commented 2022-01-24T20:06:32.003+00:00
HimanshuSinha-msft
19,376
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
The function 'sql_request' expects 2 arguments.
I am running the sample 'sql_request' from the docs which passes in a third @Anonymous to this plugin, but I am getting this error of only 2 params supported, both on KustoWebUi and in Kusto.Explorer. …
asked 2022-01-18T10:10:10.707+00:00
Kovács, Ferenc
61
Reputation points
accepted 2022-01-20T10:41:53.327+00:00
Kovács, Ferenc
61
Reputation points
1 answer
Data Explorer Pools : Data Flow - Invalid token (empty value)
Hi team, We are trying to integrate "Data Explorer Pools" data in Synapse workspace especially through Mapping Data Flow. Where i can connect and read data from using linked service (Azure Data Explorer) with a help of integrated dataset on…
asked 2022-01-10T09:24:03.43+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(169.60000000000002, 15%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Mahasubramanian Maharajan
1
Reputation point
commented 2022-01-19T18:47:16.55+00:00
KranthiPakala-MSFT
46,437
Reputation points Microsoft Employee