Last week I was playing with the very cool Rest Getting Started Sample (written in C#). I morphed it into a big loop that deleted all the rows in the dataset, and sent a row with a random value from 1-10. The reason I did this was to try out the new Flow integration with Alerts so I could demo sending emails to groups of people as a result of an alert.
I tweeted about this demo, and had a bunch of private requests from people hoping for a sample of updating data in Power BI directly from PowerApps. This blog post will show you how to insert data into a Power BI dataset from Microsoft Flow.
Just like the Getting Started Sample, we need to start by registering your application for Oauth access to PowerBI. While you can do this in the Azure Portal, it is much easier in the Power BI Dev Portal.
2. Set the trigger to Recurrence, and Actions to the custom API name you gave it above.
3. Sign into Power BI to set the properties of the custom API.
(If you don’t get this sign in dialog you probably registered the application incorrectly in step 1.)
4. Set the properties of the Action.
If everything was done correctly, the Dataset and Table name should auto-populate to drop-down menus so you can see all the datasets and tables. Note that the dataset you are updating MUST HAVE BEEN CREATED WITH THE REST APIs INITIALLY! If this limitation is something you would like changed please vote on this idea: