Learn to use the PowerApps Power BI Visual

[@sconsalter]

Don't mind this guy, your intro is your trademark and I like it. Your channel is awesome, aways!

[@ShanesCows]

Thanks 😍

[@alejandraserrano7194]

I love the intro and all content you share! Makes me excited to learn

[@ShanesCows]

Awesome! Thank you!

[@brunolazzarini2351]

You are the best, thanks for all your support.

[@ShanesCows]

Glad to help. 😀

[@pablopaiva7360]

Excellent! Thanks a lot for the tip, I wasn't able to make it work until I went to Online, created the app, saved report, download it and restarted to work in Desktop version.

[@ShanesCows]

Awesome

[@DavidGerard76]

Thanks Shane for the video. All that time I didn't know we can add PowerApps to PowerBI. This is really great. It adds some great potential to visualization. Weird it is still in preview. Great stuff!

[@ShanesCows]

Glad it helped

[@anonuser7111]

Thank you thank you thank you! Just made an app for my company in all of 30 mins, amazing.

[@ShanesCows]

Awesome 😎

[@josesousa2004]

This is the best video so far about Power BI + PowerApps! Thank you Shane

[@ShanesCows]

😎 you are welcome 😎

[@thanghuu887]

the very first words when my wife sees I'm watching your channel is "but first.....here is my intro". LOL

[@ShanesCows]

😂 Tell her I said hello and that I am proud of you for learning such an amazing skill. It will pay off. 🐶

[@jaihari4695]

Thanks for your videos. I started learning power apps with your help

[@ShanesCows]

Great to hear!

[@grahamsheeley]

Thanks Shane. I jumped right out to watch this when you mentioned it in the “Todd Klindt’s SharePoint and Cloud Podcast”. Actionable results by joining PowerBI and PowerApps, great idea. Keep up the great work. Thanks for sharing.

[@ShanesCows]

Awesome!

[@hi_vishy]

Your videos are just awesome as usual.

[@ShanesCows]

Thank you :)

[@amymcneeley9736]

These videos are incredible. Thank you so much for all the hard work you put into them.

[@ShanesCows]

Thank you for the kind comment. let me know if you have suggestions for other videos.

[@sethcalkins6911]

Very cool video on creating a real world example and doing a detailed walk through. This was great introduction to PowerApps integration and I'm looking forward to creating some content. Thanks!

[@ShanesCows]

Glad you enjoyed it! Appreciate the kind words. I am hoping to do another PBI video soon actually. I wish I knew more.

[@алексеймасанский-и4п]

Excellent tutorial!!! Many thanks!

[@ShanesCows]

Glad it was helpful!

[@benbecker2911]

Great video, I do agree the whole date thing is confusing, you'd assume passing over the date in the powerapps data section that the date would be exposed over there but it does not, i confirmed it does come over blank and that is goofy if you ask me.

[@ShanesCows]

Glad I am not crazy.

[@atua13]

Hi, Shane, you are great... This video made my day.... thanks...

[@ShanesCows]

You made me day. Thank you

[@cyflwro]

Thanks for this it's helped me build something that'll hopefully save me a lot of time at work. However Im unable to change the app to appear as landscape in power bi, is that a limitation with this?

[@ShanesCows]

I haven't tried to do that before. I don't think it is possible but not positive.

[@breb.854]

Thanks so much for the tip regarding summarizing dates it was the solution to my problem, you saved me a lot of time. :)

[@ShanesCows]

Awesome

[@jalalsemaan8129]

Mate, the intro is awesome!

[@ShanesCows]

Thanks 😊

[@espiemar1661]

I love the intro!!

[@ShanesCows]

Thank you! 🔥

[@joelpumarola2556]

Very good video !!! Integrating PowerApps within PowerBI is incredible functionality! But I have a question ... if I want to show many fields in the powerapps, I have to put them all in the PowerBI "Data of PowerApps" field, or I have to put one or two fields and the rest I can already retrieve it with the function " ThisItem.xxx "from PowerApps

[@ShanesCows]

Not sure I don’t do a lot with PBI

[@NICAMARCEL1]

I like the Intro!!!!! I rock with it...

[@ShanesCows]

Thanks 😁

[@taylorlevine2082]

Hi Shane - is it possible to "pin" one of the screens from a powerapp when it is linked in the powerbi? I am looking to avoid having my users click through various screens

[@ShanesCows]

I am not sure Taylor, I have never tried.

[@portnoy388]

What would be consideration using the other way around - embed Power BI dashboard into a canvas app?

[@ShanesCows]

Maybe this will help? kzbin.info/www/bejne/eKDLkJdursebjK8

[@ruffhousen]

I like your intro audio and video

[@ShanesCows]

Thank you 🐶

[@ansumansatpathy3923]

Hi Shane, Great job at providing structured series. One question-if I need managers to see only their reportees data in power App, what do we do on the powerapp side? We can do something ON power BI side but am worried if those users directly access the App and all their data from power App workspace.

[@ShanesCows]

You would have to build the logic to do so. I talk about it here. kzbin.info/www/bejne/Y4fEcneKibWMo8k

[@uniQue_XL]

Thanks Shane. You are awesome!

[@ShanesCows]

Thanks ☺️

[@julietzhang]

Hi Shane, I have the opposite problem. I want to use Power BI visuals in PowerApps. An app I am making needs to show some temporary results before the users confirm and send it back, and I want to use a matrix format to show the results. But in PowerApps all the data is in table format. Is there some good tricks to make a matrix view or embed PowerBI matrix in it?

[@ShanesCows]

Sorry haven’t done that one before.

[@artemburov9456]

Hi Shane! I like the Intro. Cool!

[@ShanesCows]

Hey, thanks!

[@futbolb10]

Hi Shane! Great video! it is nice to know that Power Bi can be embedded with Power Apps. I just have a question, can I modify a table in Power Bi using an embedded Power App, so the user can see the changes real time in the dashboard without using excel to actually modify the tables?

[@ShanesCows]

I think so but I don't much with PBI so I am probably not the best person for help on that. Sorry.

[@stefanodeponte2927]

Hi Shane, first of all thank you ... all I know about Powerapps is thanks to you I wanted to use the PowerApps Power BI Visual but when Powerapps opens the data is not loaded ... why? is it a problem with my settings? thank you stefano from italy (sorry for my english)

[@ShanesCows]

You have to have the proper Power BI Licenses for sharing and viewing the report. That is most likely what you are missing.

[@stefanodeponte2927]

@@ShanesCows i have license pro

[@nikhargesumit9069]

Really Thanks for this video and sharing knowledge

[@ShanesCows]

Glad to help. 😀

[@davidbrown100]

Hi Shane - love the videos. I followed your example but wanted to write back to a sharepoint list. however when i try to connect to the sharepoint list in powerbi it comes back with just a banner "Getting Your Data"? Any ideas where i might be going wrong.

[@ShanesCows]

I don’t. 😑 I am not great at PBI. If you want to email me shane at PowerApps911.com I can ask around for you.

[@jasonwimmert3659]

Shane - thanks for all your videos. They've been a life saver in learning PowerApps. Regarding the date heirarchy. I'm coming across an issue where I have 3 different dates that I'd like to be able to utilize in the PowerApps from the Power BI data. With the field being ThisItem.Month, I can only grab one of them. Any ideas on how to get all 3 dates?

[@ShanesCows]

Deeper down the rabbit hole than I have been. If you ask on Twitter and tag me I will try to RT for you.

[@MrFreedaan]

Thanks Shane you're magic!

[@ShanesCows]

Glad to help. :)

[@newabyuser]

The Intro is awesome!!!

[@ShanesCows]

Thank you! You are awesome for sharing. :)

[@Jasonmadcow666]

Can you filter the information that reaches the app? If I choose February for example I would like for the app to receive all the information in it's multiple rows, not an aggregated one. Is this possible? Many thanks in advance!

[@ShanesCows]

Not sure. I haven’t tried. Sorry

[@jingxiongwang654]

Hello, thanks for the video. I am new to power apps and I have a question about the way you made the power apps. When I deleted the original gallery that created by the power apps, I found that the app lost the capability to interact with the power BI. Also, if I add another gallery and using the original data sources for the gallery, it also didn't interact with the power bi filters. Seems like the only way to make the power apps interact with the power bi is using the gallery that the power apps created for you. Do you have any solution for this situation?

[@ShanesCows]

I thought you could reference the PowerBIIntegration object again but I have never tried so not sure. 😐

[@jingxiongwang654]

@@ShanesCows I just tried the powerbiintergation, and it worked! Now the app in the power bi report has the interaction with the filter!🤗

[@kamilsafrioui494]

Hello Shane, Thanks a lot for this amazing video. However, I still have a question regarding the parameters you include in the power apps visual. What if, after having the app using Power BI data, I want to add a new Power BI data in the app ? Will I have to create a whole new app from scratch to include this new data ? If not how can I refresh the data coming from Power BI ? Thank you in advance for your precious help and time !

[@ShanesCows]

Not sure. I don’t do a lot with PBI

[@anjan_j_k1050]

Hi Shane, That's very informative video.. I have question. Power BI has its own app version available in play store then why do we need powerapps ! How does powerapps different than power BI app version ?

[@ShanesCows]

Power BI is a reporting tool. PowerApps is an app building tool.

[@micheleciarniello2127]

Good Job definitly!

[@ShanesCows]

Thanks 🐶

[@aartiladdha01]

I have a PBI dashboard. The input data source fetches data from an excel file where users are currently manually adding data and I am linking the dashboard to that excel. I want to leverage Powerapps and eliminate this manual step. Could you please suggest ?

[@ShanesCows]

Change your data source to Sql or the likes for PBI. Then build a powerapps app to modify the sql data is what I would do.

[@solwebsolutions9779]

Hi Shane. Great video! Have you done anything with PowerBI and SharePoint search results? We're always looking for ways to export search results with data such as URL to file, site URL, last modified by, created by, etc.

[@ShanesCows]

I have not. Sorry.

[@DanielWeikert]

Thanks Shane. Does this work in PBI Desktop as well? For some reason my Powerapp is not filtered by the slicer. In Desktop you only have the option to choose an existing PowerApp so I guess there is no way to create a connection for filtering from one datasource to the Powerapp viz?

[@ShanesCows]

Hey Daniel. Not sure I don't do a lot with Power BI. :|

[@alaflen7634]

Great Video Shane. How do we add a static image of the power bi report to the email? Possibly make the image a hyperlink back to the report? This way the recipient of the email can click on the image, be redirected to the report, and dive deeper?

[@canasman11]

Intro is AWESOME!! Shane

[@Endemoniaoq]

Hi. I come from Chile and I have a question about power app.. its referential a list from sharepoint I would like to separate in a three process..can I send a mail? Because in this mail I explained everything? By and thanks

[@ShanesCows]

Shane powerapps911.com

[@mayank15081987]

Hey Shane, Thanks for this video. I tried it it is great. I just have one error, after selection from the power BI report, when I click the ">" button in Power App, it is not navigating to the email page.

[@ShanesCows]

What did you set for the OnSelect property of the > button? Should be Navigate(EmailScreen, Cover) or something similar.

[@mayank15081987]

Did the same. It works when we execute it in the Power apps preview but not when it becomes interactive in Power BI

[@nirajjaipuria2869]

Thanks for simplifying this immensely, Shane. I followed all your steps to achieve my desired output, and the PowerApps visual in PowerBI worked as expected. However, I encountered a weird problem. The PowerApps visual seemed to dynamically change in PowerBI, based on the selection of the filter, until the point when I closed the PowerApps tab in my browser. Once I close the PowerApps tab in my browser, the PowerApps visual becomes a static visual, and does not change based on the selection of the filter any more! When I am closing the PowerApps tab in my browser, it prompts that I may have unsaved changes which will be lost. I am sure I have saved the PowerApps and Published it as well (that's why it works in the PowerBI window). I CANCEL on this prompt, and go to File->SAVE in PowerApps menu, but it doesn't give me a SAVE button - implying that the app is already saved! Anything that I am missing?

[@nirajjaipuria2869]

UPDATE>>> Resolved the above issue! All that was needed was to close the PowerBI Report after saving it, and reloading it again. This causes the PowerApps visual to reload, and it reflects all the latest changes seamlessly! Thanks again Shane, for illustrating this so simply!

[@ShanesCows]

Glad you figured it out 🤩

[@MrSunni10]

I am not able to find the power Apps in the market place. Can you please let me know how to get the Power Apps to market place.

[@ShanesCows]

Not sure what you are trying to do

[@YongBaekKim]

Hi, Shane. Do you think this is possible that PowerApp could call or embed screens or charts built in PowerBI? The reason is that PowerApp Chart shows very limited API and attributes to program Chart.

[@ShanesCows]

Yes, in PowerApps click Insert > Controls and at the bottom of the list is Power BI Tile.

[@himanshunaidu4249]

My client wants all possible output of my line graph while changing the slicer field how can i automate this

[@ShanesCows]

Not sure

[@SmartChosk]

Hey Shane thanks for the video! Just let me ask you a question, I tried to access the powerapps on a published power bi report and it did not work...do you know if it is possible to use it on a published report? (Using the published page, not in PBI painel).

[@ShanesCows]

Yes, that should work. Did you make sure the PowerApp was published and had permissions set well?

[@SmartChosk]

Shane Young yes...published and permission is ok also...it only loads and not start o.o..can you give it a try there?

[@andrewwilber4041]

So instead of doing the new route, I tried existing app (using same data source for the APP and PowerBI). I was able to get the app embedded, but when I do sorting in powerBI it doesn't sort the app. Any idea how to make that connection work?

[@shubhamkaushik641]

But But, what if I want my existing Power App to interact with Power BI dashboards. Help me Shane; my Power App is used to collect data for a sharepoint list but I want it to be interactive when I connect it to Power BI using the custom visual

[@ShanesCows]

Sorry haven’t done that before

[@romulooliari]

Hi Shane, 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.

[@ShanesCows]

Not any limitation I know of. I would check to see if you have some type of data mismatch.

[@alphamusicbar]

Hi , very nice video ！I have a question，can we import a PowerApps in PowerBI and filter the data in PowerBi DashBoard ？（Data source of PowerBi and Power Apps is the same ）

[@ShanesCows]

I am not sure. Sorry. I have not tried to go that direction so I am not sure. Please let me know what you figure out though. That is a great question.

[@alphamusicbar]

Thanks for response, I tried several times ，but didn't make it. As for me，the reason is that when I tried to import an existing app into a powerbi report， the ‘’ item‘’ attribute in the gallery is often the result after filter ，even after I defined the gallery （item = table which I used as datasource in PowerBi） ， it still doesn't work， looking for better solution if someone succeed~

[@mikeolsen27]

Can you show how you can make your ETH price a different color contingent upon the value being greater than or less than zero?

[@ShanesCows]

Sorry. I don’t have anything to offer.

[@luisernestosanchezacevedo4982]

Hi, thanks for the video. Mi app integrates data from powerBI when created. After saving it shows no data, would you give me some sort of help?

[@ShanesCows]

Did you try a refresh?

[@TheKalipolis]

Share, my hero!!!

[@ShanesCows]

Thanks

[@abhinavkumar2354]

I love the intro - zoooom

[@ShanesCows]

Thanks! The intro loves you back 🥰

[@davidmendez3997]

Hi Sean, great video! Quick question: do you know how to get multiple records on powerapps based on Power BI selections? When you do the following, you get only 1 record: LookUp (TableSource, Id=First (PowerBIIntegration.Data).Id)

[@ShanesCows]

Lookup only returns one record. You need to filter to get more than one.

[@davidmendez3997]

@@ShanesCows got it! Will try. Thanks for replying.

[@sunilanumolu9211]

I like your Intro :)

[@ShanesCows]

Thanks 😊 me too 😁

[@TheRamiroB]

Hi Shane, I been watching your videos, are really greats. A have a few questions. 1 I have a Sharepoint list with many columns and recived an error, is there any way to select columns in a connection? regards Ramiro

[@ShanesCows]

No, not that I know of. How many columns does the list have? What type of list is it?

[@bartwelvaarts8860]

Thanks, great video! I assume this also works with an application that uses CRUD operations to, for example, an SQL server database?

[@ShanesCows]

Yes it should

[@Loves-f3y]

Can you connect PowerBI and PowerApp the other way as well? Can you add the BI Report to the App and have them communicate? Would you want to? (Funny, I learned that we can share a PowerApp w/o sending emails - will come in handy for us shortly. )

[@marciokataoka]

No problem with the intro! =o)

[@ShanesCows]

Thank you. I love the intro. :)

[@gozinto87]

There are a lot of videos about powerapps integration in power bi, but only a few about power bi integration in powerapps :(

[@ShanesCows]

So you want opposite?

[@mukeshsomvanshi6657]

Power apps creates by default mobile app, how we can create an canvas app??

[@ShanesCows]

Only app from data creates mobile by default. You can create an app from blank and choose either format.

[@sigmametheus]

This is a great video! So is the intro btw! Q: I'm not sure you cover this in a different video, but can I add a method to refresh the dashboard as soon as I use the 'send' function in the app? I would like to add a graph that tells me how often I've sent an email. It should change as soon as I hit send.

[@ShanesCows]

Brian I got it. PowerBIIntegration.Refresh()

[@njfrlng]

How do I get a details screen going when I use this "PowerBiIntegration.Data" method? I've created an app within a Power Bi dashboard, it successfully syncs with Power Bi Report. However, when I go to create a "details" screen (since the auto app builder only created an app with a single screen and single gallery), I'm unable to do so. I've tried manually using "PowerBiIntegration.Data" as my data source, as an item, I've search all through the data source options, but essentially it's as if my 2nd screen is not associated with the first screen at all and I have no way of connecting the two. Any insights?

[@ShanesCows]

Hey Nic - I don't have time today to set it all back up to jog my memory. I will try to circle back tomorrow with you. In my head it wasn't hard but maybe I am miss-remembering. I THINK that if you look at connections it setup a connection back to your data for you. So you would have a form that uses that connection and for the item you would gallery1.selected. Does that work?

[@CA-oe3sr]

Intro rocks.

[@ShanesCows]

You Rock Chris! :) Thanks for supporting my precious intro. :)

[@kylecox5127]

Really great videos, I've learnt a lot so far, way more than what I got from the documentation xD. Honestly Microsoft themselves couldn't explain PowerApps better than you. Just a quick question, how would you be able to find the data source that info in the CDS is coming from? I have a whole lot of entities and picklists that I can see, but I just don't know where they are coming from and I can't see any of their data either as it just constantly has the "Loading Data..." message up. It would help me so much if I could just access the data sources for these entries as I am working on some example apps for a demo to a big construction company for next week and it would really help us get the position if I can make use of the data that they already have. (Btw I have been given access to one of the Admin Microsoft of this company accounts and I am currently using it with a PowerApps Plan 2 trial to try and showcase to them what PowerApps can do. Just in case anyone thought I was doing something illegal xD.) Would really appreciate some advice as I am very confused at the moment. You might have mentioned it in a newer video, but I'm still making my way through all of them and wanted to ask before I forget.

[@ShanesCows]

If you go into CDS through the admin screens you can work with the data a bit in that you can see it, export it and bulk import. Other that that there is no way to go behind the scenes with a tool like SQL Management Studio.

[@truevaluebusinessintellige6146]

Great intro.

[@ShanesCows]

Thank you. 😀

[@none1615]

You sent blank email from PowerBI ... but was not supposed to have data /Graph to be in the body of email at all ? what's the point of sending email otherwise ... Good Video but I think it's missing the story .

[@ShanesCows]

I was just trying to show what is possible, sending an email. Unfortunately, I don't know how to send the graph. You could grab the data and send that by putting it in the body portion of the email.

[@tjvillanueva396]

Mate, can you please add an outro in your future videos? Please? and then at the end you will say, "At last, heeeres our Outro!!!"

[@ShanesCows]

LOL. Thanks for the support TJ. You rock!

[@VIACOMSUX1000]

add pac-man to your intro!

[@ShanesCows]

That would be fun.

[@PcGeek04]

you have feelings? nonsense!

[@ShanesCows]

You know me too well. ;)

[@davidsonmg]

HOG WASH!

[@caesarespinosa3131]

the intro is disastrous, please pretty please substitute it with a banner under or above the video WITHOUT music or pause, just keep on talking, you don't perceive it but to a viewer awaiting anxiously your words, one has to suffer viewing the disaster !!

[@ShanesCows]

Caesar I am sorry you don't like my intro. :( A lot of my viewers enjoy and gives the video a sense of quality.

[@caesarespinosa3131]

ok, it a lot of users like it, I must submit to their wishes respectfuly, thanks for your considerate answer

[@khargos7602]

Who doesn't think this is awesome? 🥄😡WHO!?