How to Create A Real Time Dataset on Power BI.com




About this tutorial:

Video duration: 17:6
Learn how to create a real time dataset and provide data input using Microsoft Forms and Microsoft Flow. Video was created by Reid Havens, Principal Consultant & Editor at PowerPivotPro.com and founder of Havens Consulting.

The custom code used in this video for the Get Response Details step is below. Copy the code between the quotes.
” first(triggerBody()?[‘value’])?[‘resourceData’][‘responseId’] “

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads

35 thoughts on “How to Create A Real Time Dataset on Power BI.com

    Ds Strel

    (November 17, 2019 - 3:08 pm)

    It nearly works for me 😀
    There is the problem, that i have conditioned questions, that only appear if you activate one or more buttons – one question above.

    When there's no value klicked an sent afterwards, the stream has an error:
    {

    "error": {

    "code": "InvalidRequest",

    "message": "Error parsing request for dataset sobe_wowvirtualserver|d88f2e92-3b0b-416e-9c6e-52bae5b16846: Conversion error on column '<pi>Zufriedenheit_Sonderleuchte</pi>': <pi>Input string was not in a correct format.</pi>"

    }

    }

    Is there a point where i can place default values?
    The question that runs on error is a: "How would you rate that" – Star-question, defined as number in the dataset.

    Thanks in advance!

    Paul Westgate

    (November 17, 2019 - 3:08 pm)

    Thank you for your video! I managed to connected my form/data (in Power BI Desktop), but with multiple answer data it sees each response as a piece of data, not sure how to seperate it. E.g. what are your favorite colors? Blue, Red, Yellow, Orange – when someone selects multiple answers the entry looks like ["Blue","Yellow","Orange"] whereas I would like to separate the answers. Any ideas how to do that? Thanks!

    Jacob Powell

    (November 17, 2019 - 3:08 pm)

    What if i have more than one text option on my forms questions?

    D C

    (November 17, 2019 - 3:08 pm)

    Will this also pull existing data that is already on the MS form? If not how do we add that onto the MS flow path.

    Bien Paolo Liao

    (November 17, 2019 - 3:08 pm)

    You are a mutant!.. Thank you for sharing to community. This opens up a lot.

    Raynold Vaghela

    (November 17, 2019 - 3:08 pm)

    How can we connect excel data to power BI and is it real time data ?

    Vipul Toshniwal

    (November 17, 2019 - 3:08 pm)

    I am not able to get the dataset option like you do. What to do?

    braden myers

    (November 17, 2019 - 3:08 pm)

    How are you able to connect the questions and get data into PowerBi for the other questions you have on your form? (ie the tree mapping, the answers with ratings, etc.). I have the current form I created setup and flow works good.

    Avram Slovic

    (November 17, 2019 - 3:08 pm)

    Will this work on PowerBI Online? I cant figure out how to upload the data into PowerBI once I created the flow. The Get Data option/Services only takes me to an App page…it does't give me option to load this dataset

    Gaurav Ganve

    (November 17, 2019 - 3:08 pm)

    When I click on add rows to dataset in power bi under workspace I can see different workspaces that I have. But when I choose my workspace I cannot see dataset which is there under my workspace. Same applies to tables. Can't see datasets or tables, any clues ??

    Ram

    (November 17, 2019 - 3:08 pm)

    Can you please help me with this error …' Failed with error: 'Please check your account info and/or permissions and try again.'. Please sign in again'. I am getting this error when i connect with microsoft forms in my flow.. thanks

    Joe Bonasia

    (November 17, 2019 - 3:08 pm)

    Can you make real time dashboards by adding whole files and refreshing the dashboard instead of entering data by forms??

    Andreas Appel

    (November 17, 2019 - 3:08 pm)

    Can this operation go the other way? Meaning If I'm removing an item, it's also being reflected in the statistics or is it only pushing data?

    Samir Kanani

    (November 17, 2019 - 3:08 pm)

    In the step where you click on "add to each" this option does not appear when following the video. The option for "more" does not seem to exist for me.

    Manar Yazji

    (November 17, 2019 - 3:08 pm)

    Thanks a lot
    how can get data from kobo toolbox to my dash board??

    Pedro Pavan

    (November 17, 2019 - 3:08 pm)

    Excellent, thanks for the video. I have a problem, if you cold help me, I would apreciate. I did exactly the same steps as you, and its working when someone makes the former, but my microsoft forms is an old one and there is some past informations that I cant put together. Is there something I could try?

    Gonzalo Rengifo

    (November 17, 2019 - 3:08 pm)

    Excellent! I just sent my first survey using your teachings on this video. Thanks a bunch Reid!

    Kristóf Toldi

    (November 17, 2019 - 3:08 pm)

    Hi, I did the same steps but the Dynamic content window does not pop up.. but I do not have the option to get more option while creating new step (I mean condition and more)

    handpuppe

    (November 17, 2019 - 3:08 pm)

    Can you make an update please? Now it is payload only and not the Tabe entry.

    Maulik

    (November 17, 2019 - 3:08 pm)

    awesome video, can we get live update in dashboard using azure sql database ? if yes how ? i have already tried direct query but it take 15min intervals to update.

    eu

    (November 17, 2019 - 3:08 pm)

    Man, you video is Amazing! Thanks A lot
    Very Simple
    Amazing edition
    Good Job! Thanks!!!
    I'm from brazil so i have a brazilian expression
    Bom pá caralho!

    SD Delattre

    (November 17, 2019 - 3:08 pm)

    Hi @powerPivotPro, I am stucked at 8:55. When I click New step, it simply create a new step. I dont see options like you have on your video: Add an action, Add a condition, … Add an apply to each.

    Gamer Manliness

    (November 17, 2019 - 3:08 pm)

    Awsome

    Shashi Kant

    (November 17, 2019 - 3:08 pm)

    Thank you!! Is it possible to edit the data saved through form?

    King Slayer

    (November 17, 2019 - 3:08 pm)

    Can you please help! Report visuals are not refreshing even when i hit refresh. But when I create dashboard tiles directly from stream data , its refreshing. Why is my report not refreshing?

    Krupa Sukumar B

    (November 17, 2019 - 3:08 pm)

    Awesome Tutorial. Can we do the same with an Oracle View or can you suggest me a best work around?

    ambhika k

    (November 17, 2019 - 3:08 pm)

    Hi.. Can you please explain on how to connect a live telephone directory database to Power BI with the goal of creating a live stream dashboard.

    Purbi Adak

    (November 17, 2019 - 3:08 pm)

    Thanks this was useful , Few queries: 1. Is it possible to delete an entry made in forms, and then have the correct data flowing to Power Bi. 2. When you published the dashboard – will it be real time data for others as well to whom it gets published 3. The date format in Streaming data set has time along with date like 1200 hrs. Is there a way we can only see the date?

    Andrew Horman

    (November 17, 2019 - 3:08 pm)

    Awesome tutorial…thank you so much

    Filip van den Heuvel

    (November 17, 2019 - 3:08 pm)

    I used this at the start of a Power BI training session (QR code on screen). One closed question about how familiar they were with Power BI and one open question about their expectations. Clients were positively amazed with their results live on screen! And for me as trainer, I was able to focus on these outcomes/expectations. Thanks!
    Any idea how to delete the data without deleting the MS Flow itself (so that I can reuse it with zero data)? Apparatly switching on/off the Historic data analysis didn’t work).

    Filip van den Heuvel

    (November 17, 2019 - 3:08 pm)

    Awesome MS Form Flow Power BI combination! Just one question: What if you have more than 3 MS Form questions? Can you simple add these questions in the MS Flow Number / text / date fields (10:11min)? Appartenly it doesn't work completely yet in my Power BI Desktop. I only see the answers to the question that I first added in any of the MS Flow Number/ text / date fields. Any ideas?

    Sai Kumar

    (November 17, 2019 - 3:08 pm)

    Hi …can you please explain a video powerbi report with ssas multidimensional model with live connection and do row level security for that?

    Sal A

    (November 17, 2019 - 3:08 pm)

    Great video – just slow down a bit, especially when you're navigating and clicking around.

    PowerPivotPro

    (November 17, 2019 - 3:08 pm)

    I forgot to call it out in the video. But here's the custom code needed for the Get Response Details Step. Copy the code here inside of the quotes.
    " first(triggerBody()?['value'])?['resourceData']['responseId'] "

    Kenny McMillan

    (November 17, 2019 - 3:08 pm)

    Excellent ! What office subscription do you need for access to Forms and Flow ?

Leave a Reply

Your email address will not be published. Required fields are marked *