How To Integrate A Power App Into Your Power BI Report

Рет қаралды 77,459

Күн бұрын

In this tutorial, Tim is going to demonstrate how you can incorporate a Power App directly into your Power BI report and make the two interact together.
**** Video Details ****
00:00 Introduction
00:43 Report example
02:45 Inefficiencies
03:09 The goal
05:53 Adding an app
06:22 Adding data in your app
11:28 Edit mode vs Add New Record
13:42 PowerBIIntegration.Data
15:18 Auto populate a new record
16:25 Multiple selected record
20:05 Publish app
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - www.enterprisedna.co/power-bi-...
FREE - 60 Page DAX Reference Guide Download - www.enterprisedna.co/dax-form...
Enterprise DNA Membership - www.enterprisedna.co/membership
Enterprise DNA Online - portal.enterprisedna.co/
Enterprise DNA Events - www.enterprisedna.co/enterpri...
#EnterpriseDNA #PowerBI #PowerBIDesktop #PowerBITutorial #PowerApp #PowerAppTutorial

Пікірлер: 58

@EnterpriseDNA Жыл бұрын

Check out our FREE courses: bit.ly/3N00AJw

@jasondavidsondata 5 күн бұрын

If it was possible to like something twice I would have! Great video, just what I was looking for. Thanks 🙂

@efficiencygeek 2 ай бұрын

Super thank you for this. I have the exact same use case where the PowerBI dataset has a 1 to zero relationship to the Comments table. I am using SQL Server on Azure, and this worked fine. The key concept that you showed, and not discussed extensively elsewhere is the conditional statement in the Form.DefaultMode which switches to Edit or New depending. This technique unblocked me on a problem that has taken a few solid days. Using the Rectangle to enable comments only when one row is selected is a nice touch, and shows polish. Thank you again. :-)

@paulgallagher2987 Жыл бұрын

This is awesome thanks Tim! I love when I watch a video like this and straight away, a use case for it comes to mind. I've never used PowerApps before but I'm definitely going to dive into it now. Thanks Again. :)

@jakepat6860 6 ай бұрын

Incredibly helpful video, made it simple and easy to follow. This was amazing thank you

@erinfield1943 9 күн бұрын

This is exactly what I need when my IT department lets me out of my Personal Productivity environment. Bookmarking this.

@guyinazo Жыл бұрын

Great tutorial video. I needed a refresher as I have a presentation tomorrow on Power BI / Power Apps integration. New subscriber here

@EnterpriseDNA Жыл бұрын

Hi @guyinazo , glad you found this video helpful! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!

@jithiljohn2961 4 ай бұрын

Can you please help, getting error for below code - No is not valid LookUp('Action Items Tracker for DCR - DEX',Title=First(PowerBIIntegration.Data).No)

@shreyasonawane8119 Жыл бұрын

omg i was struggling with this for so long u told in such a great way

@EnterpriseDNA Жыл бұрын

Hi Shreya, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

@shreyasonawane8119 Жыл бұрын

also can u tell me that how do i auto refresh the powerbi dataset i connected it with powerautomate but dint work

@AuroraS934 7 ай бұрын

@@shreyasonawane8119 Yes, you could use a Power Automate Flow that triggers when there is a change in the SharePoint list however I do not find this option user friendly as the refresh might take a while and user is NOT aware when it is finished. I would instruct the user to use "Refresh" button in PBI Service after all updates are done.

@efficiencygeek 2 ай бұрын

@@shreyasonawane8119 One thing to try - Call PowerBIIntegration.Refresh() in your Form.OnSuccess event. If the PowerBI Dataset is loaded via DirectQuery, the updates should appear on PowerBI as well. Other videos by Reza and How To Power BI have this too.

@Zak0179 4 ай бұрын

great job

@davidkelly1634 10 ай бұрын

Thank you for this content. I have been looking to do this for sometime and this is by far the best explanation I have come across. Cheers

@EnterpriseDNA 10 ай бұрын

Hi @davidkelly1634 , we’re glad you found this video helpful! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!

@pintastic5876 Жыл бұрын

Great tutorial. My PowerApp never updates when a selection is made. If I make a label that shows RowCount(), it shows total rows but never updates.

@adrianofrizon3514 Жыл бұрын

Amazing tool

@EnterpriseDNA Жыл бұрын

Hi Adriano, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

@zbigniewporzych8303 7 ай бұрын

Thanks Tim, really good guide. Do you know if there is direct query option in PowerBI to avoid refreshing entire dataset? Unless it’s not needed.

@NidhiSharma-gw2qk 10 ай бұрын

Hi Tim, I’m after the solution that you mentioned at 03:22 of your video which is using URL linking to pass data from Power bi to power app. Do you have a video on it that i can refer to? Embedding power app visual in power bi isn’t the solution for my scenario. Any help will be greatly appreciated. Thanks!

@Faedhros 5 ай бұрын

What program are you using to record your screen? Looks incredibly well

@nagendrababu7141 7 ай бұрын

How do you have added comments column in the existing powerbi reports columns?

@yoselinangulo8308 9 ай бұрын

Great video! Is it possible to know who added the comments? I mean, in the table or Power Apps, the name of the person adding the comment would appear.

@user-of9ku1qw3s Жыл бұрын

Brilliant

@EnterpriseDNA Жыл бұрын

Hi Kurt, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

@kanwalsingh2802 3 ай бұрын

Thank you for sharing your knowledge and video. In my list, i have default ID column, could you be able to help me lookup formula? Fyi, i am not using default Title column.

@zacharyphillips300 Жыл бұрын

In regards to the lookup function, I keep getting an error saying my field name is not valid/recognized. Do you know why this might be?

@In_a_state Жыл бұрын

My biggest issue is how the app is rendered when the report is in "Fit to page" view, all fuzzy. Unfortunately I cannot use the "Actual size" view.

@marcocruz5351 10 ай бұрын

Hi there what about when you have an existing powerapp and you want to embedded it into PowerBi? I tried doing this and I am not getting any data from my PowerBi report. Can you please assist? Thanks!

@marktaaaaaaaaaaaaaaa 7 ай бұрын

Can we get the file he worked on, it would be good for training

@legendgod 11 ай бұрын

I have a Power BI dashboard that similar as yours. In the Power App, I have a button that will add selected item (First(PowerBIIntegration.Data)) from BI into a collection. So user need to select the BI item, then press button, then select BI item, then press button again to add multiple items. Is it possible to directly add the selected item to Power App collection using something like PowerBIIntegration.Data.OnSelected?

@rianajoyceortega6079 2 ай бұрын

Hello. What license/s are you using? Hope you can reply. Thank you so much.

@johncruz1644 10 ай бұрын

Hi, Can you help me? I can't seem to make it work when my column name has spaces. It throws "Error when trying to retrieve data from the network:" message. But if I tried to use "Column_x0020_Name" as replacement for 'Column Name', the error is gone but there's no data shown in my form. Edit: It seems to be an ongoing bug on Excel Online (Business) Data connector. As a workaround, I used the OneDrive for Business Data connector instead and now I can use spaces in column name and reference them using 'Column Name' without any error.

@mathieuricard1087 Жыл бұрын

Hello, It looks really good with a list!! I am trying to duplicate the concept with a table in a SQL Azure database. However, there's a message error when I validate the Lookup fot the Item. Any idea/recommandation plz?

@finnpower92 29 күн бұрын

Hi, this might reach you too late, but as far as I know, this technique works only with Power BI service, in browser. You can't do this in desktop

@madsr1992 Жыл бұрын

Sorry if I missed this in the video but is there a way to set this up so that the submitted comment is visible in the report right after submitting it? Perhaps some power automate job or something to trigger refresh?

@timweinzapfel Жыл бұрын

You certainly could use power automate to do a refresh. However if you have a number of updates to make, that could be an issue. This is one downside to this integration unless you are perhaps doing a direct query to the data.

@yasaswibalaji7434 7 ай бұрын

Good video. But don’t we have a delegation issue here ?

@gregoryoliveira8358 7 ай бұрын

I was looking for something about this. Because there is a warning about this. However, I believe we can accept this warning considering you prepare your application to dont fall into a delegation problem.

@hugohenris6481 10 ай бұрын

Super, is it possible to upload datas from the App to the report directly? Without a excel file or a special DB?

@suprateem 9 ай бұрын

yes, possible to upload data from app to report instandly using PowerAutomate flows API mode, which will instantly refresh the dataset in power bi service with updated information from the sharepoint list, which itslef is gettign updated by the embedded Power App

@benjay12 4 ай бұрын

This didn’t work with SQL database source .. the lookup threw an error. Can you do a demo with SQL database source ?

@kanchidoshi6907 6 күн бұрын

We also need to work with SQL server

@Woodborn 7 ай бұрын

The issue I have is that if there is not a corresponding item in my Sharepoint list (i.e. Comment would show blank in your example), the ID that is passed to Power Apps somehow gets filtered out and nothing gets passed to Power Apps at all. To troubleshoot, if I add another table on my page with only ID in it, it's also blank when I selected an ID in my main table without a corresponding comment. Any idea how to solve this?

@user-qc2xt2pc5t 7 ай бұрын

Great video! I was able to create similar functionality thanks to your excellent guidance! Would there be a way to also add functionality to create a new record using the integrated Power App? In my case, it is updating Consultant records, but I would like the ability to add new records, as well.

@AuroraS934 7 ай бұрын

I would add another button "New Lease" and re-use the form; the Default value for Lease ID field should then populate with maximum value in LeaseID field from "Lease Comments List" data.

@davidkelly1634 9 ай бұрын

Hello and thanks for the content. At 11:09 you typed in the look up formula text, why does it use the phrase “Title=First..” should it not refer to “Lease ID=First…, as title did not seem to appear on the SharePoint list you were using? I’m trying to replicate this app and this step confused me? Thanks David.

@QuantumDot2 6 ай бұрын

SharePoint lists always have a "Title" field upon creation. This can be renamed later (to 'Lease ID' in the video), however the *internal* SharePoint field name would still be "Title" which is why it appears that way in the formula. It's one of those endearing SharePoint *quirks*. :)

@davidkelly1634 6 ай бұрын

@@QuantumDot2 thank you. “It’s a feature of the product.” as i heard once.

@UPHARANAND 10 ай бұрын

I only face difficulty in getting the formulae

@EnterpriseDNA 10 ай бұрын

Hi @UPHARANAND, It's a bit difficult to assess and recommend without looking at the data structure, model and working of the PBIX file for reference. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZfaq channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

@UPHARANAND 10 ай бұрын

@@EnterpriseDNA Can I get the data set used in the video ?

@UPHARANAND 10 ай бұрын

@@EnterpriseDNA Can I get the dataset ?