Microsoft Fabric

https://learn.microsoft.com/en-us/fabric/
Admin
Microsoft Fabric is a unified platform designed to meet an organization's data and analytics needs,...
Tokens:5,346,857
Snippets:45,764
Trust Score:10
Update:3 days ago
Show doc for...
Tokens:
Raw
### Install frontend dependencies and start the service

Source: https://learn.microsoft.com/en-us/fabric/workload-development-kit/quickstart-sample

Run these commands in the Frontend folder to install required packages and launch the development server.

```bash
npm install
```

```bash
npm start
```

--------------------------------

### startOfMonth function example

Source: https://learn.microsoft.com/en-us/fabric/data-factory/expression-language

Example showing how to get the start of the month for a specific timestamp.

```text
startOfMonth('2018-03-15T13:30:30Z')
```

--------------------------------

### startOfHour function example

Source: https://learn.microsoft.com/en-us/fabric/data-factory/expression-language

Example showing how to get the start of the hour for a specific timestamp.

```text
startOfHour('2018-03-15T13:30:30Z')
```

--------------------------------

### Build the sample application

Source: https://learn.microsoft.com/en-us/fabric/real-time-intelligence/get-data-serilog

Build the application from the root folder of the cloned repository.

```bash
dotnet build src
```

--------------------------------

### Initialize project with uv

Source: https://learn.microsoft.com/en-us/fabric/database/sql/connect-jupyter-notebook

Create a new project directory and initialize it using uv.

```bash
uv init jupyter-notebook-qs
cd jupyter-notebook-qs
```

--------------------------------

### startOfDay function example

Source: https://learn.microsoft.com/en-us/fabric/data-factory/expression-language

Example showing how to get the start of the day for a specific timestamp.

```text
startOfDay('2018-03-15T13:30:30Z')
```

--------------------------------

### Prepare directories for software installation

Source: https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/stream-oracle-data-to-eventstream

Create individual folders for Kafka, Java, and Oracle GoldenGate, then move the packages into them.

```bash
$ sudo su – oracle
$ mkdir kafka java oggbd
$ mv 214000_ggs_Linux_x64_BigData_64bit.zip oggbd/
$ mv jdk-8u202-linux-x64.tar.gz java/
$ mv kafka_2.13-3.9.0.tgz kafka
```

--------------------------------

### Get the size of a table with GUIDs

Source: https://learn.microsoft.com/en-us/fabric/onelake/how-to-get-item-size

Example of calculating the size of a table using GUIDs for the workspace and item path, which is necessary if names contain unsupported characters.

```PowerShell
$ctx = New-AzStorageContext -StorageAccountName 'onelake' -UseConnectedAccount -endpoint 'fabric.microsoft.com'
$workspaceName = 'aaaaaaaa-0000-1111-2222-bbbbbbbbbbbb'
$itemPath = 'bbbbbbbb-1111-2222-3333-cccccccccccc/Tables/table1'
$colitems = Get-AzDataLakeGen2ChildItem -Context $ctx -FileSystem $workspaceName -Path $itemPath -Recurse -FetchProperty | Measure-Object -property Length -sum
"Total file size: " + ($colitems.sum / 1GB) + " GB"
```

--------------------------------

### Build the sample application

Source: https://learn.microsoft.com/en-us/fabric/real-time-intelligence/get-data-nlog-sink

Navigate to the sample directory and build the application using dotnet.

```powershell
cd .\NLog.Azure.Kusto.Samples\
dotnet build
```

--------------------------------

### guid function example with 'P' format

Source: https://learn.microsoft.com/en-us/fabric/data-factory/expression-language

Example of guid with format 'P', which encloses the GUID in parentheses. Returns a string like '(c2ecc88d-88c8-4096-912c-d6f2e2b138ce)'.

```expression
guid('P')
```

--------------------------------

### Run the sample application

Source: https://learn.microsoft.com/en-us/fabric/real-time-intelligence/get-data-serilog

Execute the application from the samples folder.

```bash
dotnet build run
```

--------------------------------

### MSFT.REGEXP_COUNT example

Source: https://learn.microsoft.com/en-us/fabric/graph/gql-expressions

Counts matches of a pattern in a string starting at a specified position. The example starts at position 3, so only digits 3 and 4 are counted, returning 2.

```gql
RETURN MSFT.REGEXP_COUNT('1a2a3a4', '[0-9]', 3) AS match_count

```

--------------------------------

### rand function example

Source: https://learn.microsoft.com/en-us/fabric/data-factory/expression-language

Example of getting a random integer from a specified range.

```text
rand(1, 5)
```

--------------------------------

### Run the sample application with Maven

Source: https://learn.microsoft.com/en-us/fabric/real-time-intelligence/get-data-log4j2

Navigate to the samples folder and execute this command to run the sample application.

```bash
mvn compile exec:java -Dexec.mainClass="org.example.KustoLog4JSampleApp"
```

--------------------------------

### min function example

Source: https://learn.microsoft.com/en-us/fabric/data-factory/expression-language

Examples getting the lowest value from a set or array.

```text
min(1, 2, 3)
min(createArray(1, 2, 3))
```

--------------------------------

### Start the GraphQL MCP server

Source: https://learn.microsoft.com/en-us/fabric/data-engineering/api-graphql-local-model-context-protocol

Launch the server and verify the startup output.

```bash
node FabricGraphQL_MCP.js
```

```text
Microsoft Fabric GraphQL MCP server listening on port 3000
API URL: https://your-fabric-endpoint/graphql
Scope: https://api.fabric.microsoft.com/.default
```

--------------------------------

### max function example

Source: https://learn.microsoft.com/en-us/fabric/data-factory/expression-language

Examples getting the highest value from a set or array.

```text
max(1, 2, 3)
max(createArray(1, 2, 3))
```

--------------------------------

### Open the project folder

Source: https://learn.microsoft.com/en-us/fabric/apps/data-apps-template

Navigates into the newly created project directory.

```bash
cd <app-name>
```

--------------------------------

### range function example

Source: https://learn.microsoft.com/en-us/fabric/data-factory/expression-language

Example of creating an integer array starting from a specific index.

```text
range(1, 4)
```

--------------------------------

### Initialize project and install dependencies

Source: https://learn.microsoft.com/en-us/fabric/real-time-intelligence/event-streams/generate-building-operations-sample-events

Run these commands in your project folder to initialize the Node.js environment and install the Azure Event Hubs client library.

```bash
npm init -y
npm install @azure/event-hubs
```
Tokens:
Raw