Using PowerApps Visual in Power BI to interact with data 📈 (2019)

In this video we will use the PowerApps visual in Power BI to update data in SQL while auto refreshing the Power BI report instantaneously. The Power BI report is using direct query to not rely on scheduled refreshes\imports.

The PowerApp will allow data to be:
Browsed
Created
Updated

[johng]

Thanks in a million! Very well explained. This is the nth time that I am watching this again. Great content. Awesome. I couldn't find this explanation--simply put anywhere else. “Great teachers are hard to find”. Grade: A++ 💥

[swazza]

This video describes my use case for PowerApps almost perfectly. Thank you very much.

[ClaudeNova]

Dave, your vids are brilliant! Please keep making them.

[danielabenhaim]

Hi Dave - really appreciate the video. Challenge I had in my example was just using Excel file on One Drive and using web connector. It works partially but the CRUD parts of PowerApps are somewhat a hit and miss..I also later on discovered an 8 Refresh per day on a dataset which could explain some of my complications. Irrelevant -- wanted to thank you for your time to put such a helpful video together.

[amandab]

This was very helpful, thank you for taking the time to create and share.

[jobhorvers]

Hello Dave! Thank you for your clear video! I have a question: as you already mentioned it should be possible to switch to a tablet view. Can you maybe descripe how to fix this since my app is forsing me into a phone view. Thanks for your help!

[stevealicea]

Dave... thank you for this video. Can you go through the steps to change to tablet instead of phone when clicking on the PowerApps icon?

[andrewspalding]

Hi Dave, A great video; clear instructions which all worked like a dream until I tred to share the Power BI Report with other people. I found that when the report was pinned to a Dashboard and shared, the PowerApp was no longer able to write back to the database. I have no problem reading data but can not update values from the Report in the Dashboard. I do not get any error message from the App running from the Report in the Dashboard, but I can see that the values are not being updated. Do you know if there are any known behaviour differences between PowerApp embedded in Reports verses PowerApps embedded in Reports pinned to a Dashboard? Andrew

[mshparber]

11:45 how is it connecting the primary keys?

[romulooliari]

Hi Dave, do you know that there are any limitations when using the Sharepoint data source?

When applying the value of the Gallery (eg Gallery1.Selected) to the Item field in the EditForm, a red X appears, and when examining the error it appears: "Invalid formula. Expected value compatible with "DataSource ". In my case the DataSource actual is a Sharepoint Online list.

[sumitnikh]

Hi Dave, Thanks for the great video. Just want to understand does that power app data changes update the data in Sql database aswell? if I am using sql database. Thanks

[michaeldeabreu]

Hi Dave - Another great video. I have around 5 production apps setup like this and one thing that frustrates me is you cannot create a "Tablet" app only mobile. Is there a work around to have Tablet that includes the "Refresh" option after data is committed?

[marcmason]

Hi Dave,

Thank you for posting this tutorial! I am having trouble following the steps and hoping that you can help me.

When I click on "New App" on the PowerApps visual in Power BI, when Power Apps open in browser it says "this form isn't connected to any data yet". I have tried to connect it to Power BI but I am not having any luck.

Any ideas?

[valentinloghin]

Nice video !! The database sql it is on prem ?

[Siberian_valenok]

Hi Dave, thanks a lot for the video. One thing I'm struggling to understand is this - why would I go through all this hassle, if I can simply update my original Excel file and update a PBI report?

[Mawerik]

Thanks for the video, very interesting and useful! But what if I want to write over a SharePoint List and not a SQL Server? I don't need the live data refresh but I need the App to be filtered by the PowerBi visuals... I seem to be able to do one thing at a time... If I can write successfully the visual doesn't get filtered; If I manage to get it filtered it will not be able to write...

[ArifKhan-jbqf]

Hi, I have created report in Power BI Desktop by using excel spreadsheets and publish on portal as well. But when follow your steps I won't able able to add the fields into Power Apps even systems shows the connectivity of Power BI, even thou I can't add fields as you did like drag and drop. Please allow me to know how would I can do that if data source of Power BI report is Excel sheets.

[pulkitverma]

I am new to Power BI Apps. I have one question. When we enter the data to Power BI Apps...Will that be reflected in database as well?

[shailajaakula]

Hi Dave.. I tried following the video .. but The edit box doesn’t allow me to add new values when i click on Edit Icon nothing changes. Control type for fields is only”View”. I don’t see “Edit” in control type. Any insight on this please?

[bartvanmeulenbroek]

Hey Dave, great tutorial and I've managed to integrate very well. What I can't figure out: once I've created the app and all is working, how to add fields in a later stage? In my example, I've added two extra fields to the visual in PBI, refreshed and published the report. When I then edit the Powerapps, these extra two fields don't appear in the PowerBIIntegration.Data set of fields. Thanks to advise