Set up External Data Feed with Azure Event Hubs and Power BI

In the Azure portal, create a resource group if you do not already have one.

In the resource group, create an Event Hubs resource. This creates an Event Hubs Namespace.

When the deployment is complete, go to the resource and create an Event Hub inside that Namespace.

Go to the Events Hub Instance > Settings > Shared access policies and create a policy.

Copy the Primary connection string. You will use it for the saslPassword setting when you configure Content Hub.

In Content Hub, configure the ExternalDataFeed > Export setting with the following:

{  
  "entityDefinitions": [
    "M.Asset",
    "M.Brand",
    "M.Geography",
    "M.Color",
    "M.Tag"  
  ]
} 

The Export setting defines which entity definitions send events.

Click Save.

Configure the ExternalDataFeed > Transport setting with the following:

{
  "kafka": {
    "enabled": true,
    "bootstrapServers": [
      "{event-hubs-namespace-hostname}:9093"
    ],
    "topic": "{event-hub-instance-name}",
    "clientId": "contenthub-external-data",
    "securityProtocol": "SaslSsl",
    "saslUsername": "$ConnectionString",
    "saslPassword": "{event-hub-instance-primary-connection-string}"
  }
}

Click Save.

Go to your Events Hub Instance > Data Explorer and check for incoming events.

In the resource group you created earlier, create a Stream Analytics job resource.

When the deployment is complete, go to the resource and then Job topology > Query.

On the Query page:

Add the following query, then test and save it, and start the Stream Analytics job.

SELECT 
    tenant, 
    eventType, 
    payload.id AS id, 
    payload.identifier AS identifier, 
    payload.modifiedOn AS modifiedOn 
INTO 
    [YourOutputName] 
FROM 
    [YourInputName] 

After a few minutes, a streaming dataset is created in your Power BI environment.