Computer Play Button

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

Hello P3 Nation! Today’s “post” is actually going to be a video link. Sometimes there are certain subjects, concepts, or post ideas that just don’t translate well to the written word, and especially to screenshots. So this post will be in moving picture form! We’ve posted it to our YouTube Channel which you can go to here. Bedside’s today’s video, we have TONS of content on that channel so please take a look at our other awesome videos as well.

Today’s topic covers how to create a real-time dataset in the Power BI Service. You’ll learn how to use Microsoft Forms, Microsoft Flow, and Streaming Datasets to create a way to collect data THEN have that data written to a Power BI Dataset in REAL-TIME! The best part is that you WON’T have to write (almost) any code to do this, just a series of inputs and mouse-clicks!. I’ve included below the one bit of code you’ll need during the Microsoft Flow steps. Otherwise, enjoy the video!

first(triggerBody()?[‘value’])?[‘resourceData’][‘responseId’]

 

  Subscribe to PowerPivotPro!
X

Subscribe

Reid Havens

Reid Havens is the Founder & CEO of Havens Consulting Inc. He has a formal background in technology and organizational management, having obtained separate degrees in Organizational Development & Business Analytics. Reid has experience working with Fortune 500 companies such as Microsoft as well as with Non-Profit Organizations. He is also the Executive Editor, contributing author, and Principal Consultant at PowerPivotPro. Additionally he's an instructor at the University of Washington and other universities, teaching Business Intelligence, Reporting, & Data Visualization. 

This Post Has 17 Comments

  1. Great example and the video demo was excellent! Can think of several use-cases I could apply this to almost immediately. Thanks!

    1. Right? They’re so close. It’s still in preview so my hope is that when it’s completed they’ll not require you to put any custom code in. Fingers crossed!

  2. Reid, awesome video! I spent time yesterday following along, creating and learning. I was able to create a working model and I’m pretty sure we’ll be using this technology in the future here at our company. Thank you for sharing this great video and how to create a survey, and link it to Power BI for a Real Time data set. Keep sharing these great video’s and help the Power BI community grow in skill.

  3. Hello, I have an issue when doing the MS FLOW steps : when creating the action step , I can select the Form but then when clicking in the field for the ResponseId, I get a empty screen….And stuck there…no option to go back without losing all setup in the flow. Any idea ?

    1. Hi Kurt, is that MS Form attached to an excel file sitting in your onedrive, or was that Form created directly in the forms menu? Only forms created there can work with Flow -> PBI Live Dataset.

      1. The form was created directly in the forms menu. I do not think that the issue is linked to powerbi connection because the blank screen I get when trying to enter the Response ID.

        1. Strange…just tried this again today and now it works …I followed the same steps, did not change anything to the Form.

  4. Hi Reid, that was awesome! Thank you! Just wanted to point something out regarding your code since it took me some time to figure it out. This part of the code [‘value’])?[‘resourceData’][‘responseId’] is written with commas instead of ‘ and copy/paste gives invalid expression. Thanks again!

  5. Hi Reid – this looks pretty awesome. How much data will it be able to store? I am thinking about having people entering information about job sites that they go to and that can be a lot of entries on this once it gets going

  6. This is was a real interesting demo. I worked through it with a SharePoint list instead of an MS Form–I found it to be a bit easier. One of the biggest drawbacks is there doesn’t appear to be a way to update or delete items in the streaming dataset.

Leave a Comment or Question