Connect Twitter to Power BI and Beyond with Logic Apps

Sign in to queue

Description

Follow this walk-through to set up your own real-time Power BI dashboard using Azure Logic Apps.  Enrich the data from Twitter with Azure Cognitive Service Text Analytics to understand the sentiment and key phrases, and take action on negative tweets (post to Microsoft Teams or Dynamics 365).

Embed

Download

Download this episode

The Discussion

  • User profile image
    JB2000

    Hi Jeff,

    I hit an error while creating the lab.

    Failed to save logic app TestTwitterSentiment. The template validation failed: 'The inputs of template action 'Add_rows_to_a_dataset' at line '1 and column '577' cannot reference action 'Detect_Sentiment'. Action 'Detect_Sentiment' must either be in 'runAfter' path or within a scope action on the 'runAfter' path of action 'Add_rows_to_a_dataset', or be a Trigger.'.

    Any ideas?

     

    Thanks,

    Josh

  • User profile image
    jeffhollan

    @JB2000: I know what the error is saying but I'm less clear how you were able to get into this state.  It's saying you are referencing an action that isn't in the dependency chain (for example, if you were accessing inputs from a step that runs after the current one) - but the designer should automatically be adding dependencies for you.  Feel free to send anymore details on the workflow or subscription ID and we can investigate (for instance, the code-view for the app) -- logicappsemail[at]microsoft[dot]com

  • User profile image
    miaoran

    Hi Jeff,

     

    I've got an issue, I am using "add rows to dataset" but i cannot see data add into powerbi streaming dataset. The step before PowerBI actions is Parse JSON. I can see 'Parse JSON' output is correct in execution log. But I can not see any input  into "add rows to dataset".

  • User profile image
    jeffhollan

    @miaoran can you verify you turned on "Enable Historic Analysis" - if not you can only view the streaming data but won't allow you to build any reports/charts.

  • User profile image
    David

    Function does work for me, is this valid JavaScript? Seems to be the use of the 'any' keyword.

    module.exports = function (context, req) {
    context.log('Webhook was triggered!');

    var phrases = data.phases;
    context.res = { any
    body: phrases.join(", ")
    }
    context.done(null, res);
    };

  • User profile image
    jeffhollan

    @David thanks - it looks like that screenshot capped the "helper text" that popped up - the ANY isn't actually a part of the function.  So the function above is good except just remove the "any" word

  • User profile image
    Warren

    Hi Jeff,
    When I am creating my Azure function I don't understand what I place in the Event Hub trigger dialogues i.e. Event Hub name and Event Hub connection.

  • User profile image
    Warren

    Sorry Jeff my mistake, I needed to select a Generic web hook.

  • User profile image
    Phindile

    Hi Jeff, I have done everything correct but ii can see the dat

  • User profile image
    jspibey

    Hi Jeff,

    This is great and I was able to get this up and running in literally 10 minutes. However, I'm unfamiliar with PowerBI and so I can't figure out how to summarise the data from the streaming dataset into averages/counts etc as you have on your demo. Seems like the dashboards and reports only want to show the most recent values rather than allowing you to aggregate them over time.

    Any resources you can point me at for that?

    Thanks

    James

Add Your 2 Cents