Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi guys,
I wanted to setup a simple stream analytics stream that I can capture (OutPut) in PowerBI.
There are instructions on how to set parts of it up, but not a complete end-to-end tutorial.
Does this require any type of coding in VS?
Thanks for your time and advice :).
Solved! Go to Solution.
Unfortunately I haven't found a steb by step for no coders ( I don't know Json or even use VS except SSDT )..
I had played around and searching for a couple of days to make work. I am sure this is not the best solution or even correct ( at least it works ) as also using the best avaliable azure resources for the data workflow.
But at least for a no coder like me it was the only option I manage to make it work and seemed easier to follow.
I am planning to write an analytical blog post but until I found some time and optimize the set up, this is a summary of what I did.
I used Azure Logic apps to send tweets to an event hub and then used an Stream Analytics job to read from event hub and send them to PowerBI.
Create a Logic app and use the default twitter connector as trigger ( plus the neccessary resource group, app plan etc. )
https://azure.microsoft.com/en-us/documentation/articles/app-service-logic-create-a-logic-app/
This link also has other link on how to create the twitter app in Twitter Dev
Create an event hub
https://azure.microsoft.com/en-us/documentation/articles/event-hubs-csharp-ephcs-getstarted/
I didn't use VS since I only add endpoints
Deploy the event hub connector from Github
https://github.com/logicappsio/EventHubAPI
Add Twitter & EventHubAPI to Logic app workflow
Set up Stream Analytics Job
https://azure.microsoft.com/en-us/documentation/articles/stream-analytics-get-started/
A quick post that has all combined and unfortunately I found it after tried many other things
Hope it can help you start from somewhere.
I am also hoping many have designed it better and easier..Looking forward to their opinion
Unfortunately I haven't found a steb by step for no coders ( I don't know Json or even use VS except SSDT )..
I had played around and searching for a couple of days to make work. I am sure this is not the best solution or even correct ( at least it works ) as also using the best avaliable azure resources for the data workflow.
But at least for a no coder like me it was the only option I manage to make it work and seemed easier to follow.
I am planning to write an analytical blog post but until I found some time and optimize the set up, this is a summary of what I did.
I used Azure Logic apps to send tweets to an event hub and then used an Stream Analytics job to read from event hub and send them to PowerBI.
Create a Logic app and use the default twitter connector as trigger ( plus the neccessary resource group, app plan etc. )
https://azure.microsoft.com/en-us/documentation/articles/app-service-logic-create-a-logic-app/
This link also has other link on how to create the twitter app in Twitter Dev
Create an event hub
https://azure.microsoft.com/en-us/documentation/articles/event-hubs-csharp-ephcs-getstarted/
I didn't use VS since I only add endpoints
Deploy the event hub connector from Github
https://github.com/logicappsio/EventHubAPI
Add Twitter & EventHubAPI to Logic app workflow
Set up Stream Analytics Job
https://azure.microsoft.com/en-us/documentation/articles/stream-analytics-get-started/
A quick post that has all combined and unfortunately I found it after tried many other things
Hope it can help you start from somewhere.
I am also hoping many have designed it better and easier..Looking forward to their opinion
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |