POWERAPPS and POWER BI can do what?!? It's bananas!
Вставка
- Опубліковано 15 жов 2024
- Patrick takes a look at how you can integrate PowerApps with Power BI to get a bananas experience. Updating the PowerApp does something special with the Power BI report.
Create a PowerApp: docs.microsoft...
PowerApps custom visual: docs.microsoft...
********
LET'S CONNECT!
********
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
Check out my Tools page - guyinacube.com...
#PowerBI #PowerApps #GuyInACube
I've been working with Power BI for a couple years now and have begun to work with PowerApps. The possibilities of this integration between the two products is truly "bananas"!! Great video for getting the word out about combining these two technologies!
I'm just starting with Power BI, half a year now. Do you think i should check PowerApps, already?
André Pinheiro depends on your needs. From what I know so far, think of PowerApps as the means to enter and update data and PowerBI as the means to share and report out data. Do you have a need to capture data through a form like tool? If so, explore PowerApps. The power (no pun intended) of PowerApps and Power BI is amazing!
I just wanted to tank you for these videos. I learned so much from this channel and that's what allowed me to drastically improve the quality of work at my company. in addition, it helped me really show value and got me a promotion.
WOW! That's amazing! Great to hear you were able to improve your skills and get to that next level. That is seriously a great story! 👊
This is so true. I watch your videos just to learn the possibilities. Every video is unique and informative. Thank you guys.
Wow - this is the real deal! You should consider doing more than power BI if you can keep it this simple and relevant. #respect
Appreciate that Mangesh. Definitely something to consider. 👊
Great, now I can also use Power Apps in Power Bi, Tried it and it works perfectly. Thanks Patrick.
Yup! It provides a great synergy.
Hi Etienne, what data source did you use for directquery that is supported by both PBI and PA ?
Hi Patrick, Please try to do more videos on Power Apps .I really understand the way to explain with scenarios
Not opposed to doing more. But, we focus primarily on Power BI, so we try to tie everything back to Power BI.
Hello, I have a power apps channel and maybe I can help you, I'm from Brazil, but the videos have subtitles.
Patrick, I can think of so many stuff we can potentially achieve with this integration! You are right, it's "bananas"!!! As always, thanks!
Man, you are just awesome with your explanations....
The energy with which you explain the things creates interest for learning ......Cool ....another great video by the Guy in cube
Power Apps and Power BI together at last! So many possibilities!
This was exactly the information I was trying to find. Thanks!
Interesting and Very Nice to Know. Thank you so much for sharing
you are Power bi "Power Star" with 5 Stars....Brightest Star i never seen ....Thanks sir
Thanks a lot Patrick!
Hi Patrick! Please could you share a total guide for the application in PowerApps that you show here, please thanks!
Any other resources/websites on power apps that you can recommend? Sounds exciting!
Check out Shane Young on UA-cam. ua-cam.com/channels/7_OGRP8BYvtGB8eZdPG6Ng.html
Great video as usual, been meaning to try and develop a PoC of this...... by the way YES YES YES to the DAX formatting toggle feature!
Great video! Do you happen to have a template of the PowerApp you are using?
Could you do a video on how to achieve this using a sharepoint online list, mans struggling right now ngl
This is amazing! Thousands of THANKS!!!
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++ 💥
Patrick: you are crazy - how could I give TWO big thumbs up?! :-)))))))) ....I enjoy every our lesson - keep on!
Once again, thank you! This is great, but why shouldn't I do the same thing in PBI Desktop? Why I need to do this in the Service? I mean, it's going to be painful for version controlling (adding PowerApps App every time we re-upload the report).
@
A Jääskeläinen, PowerApps is 100% online, so the only way to initially add the PowerApp to the custom visual is to do it on the service. Once you've done that step, download the pbix and you'll find that it remembers which PowerApp you embedded. You can then blissfully republish/re-upload your PowerBI report as often as you like! Top tip: watch you don't change the names of the attributes you mention in your PowerApp (they ain't dynamic). Hope this helps!
@@shingomcleod Thank you for the insight! It's very useful!
Great Video! is there a way to get the usage data of an app in Power BI besides the "Preview" in PA Studio?
I want my PowerApps channel to become just like yours. Except for PowerApps! Love the "small channel" feel. Thanks for the great info.
DO IT! Love it! We won't lie. It is a lot of work. And took a long time to get to where we are. Persistance, consistency and passion all help.
Appreciate the kind words 👊
@@GuyInACube 100%. I'm going to keep up! I'll keep watching your great videos as well.
Could we have a separate video on how the power app was created?
Hi pat great video but I don’t see powerapps in my visualisations- powerbi desktop may 2020
Me neither :-(
great video!!!
Is there an alternative to the SQL connection so that PowerBI refreshes instantly?
Would connecting via DataVerse in a table under Powerapps provide instant refresh?
Would any other way provide instant refresh?
That is so awesome! I didn't know that you can combine them.
Oohh... nice
You rock
It is very awesome! Thanks for watching 👊
Hi Patrick, awesome video!! I have only one question. Is it correct that both Power BI and the Power App get their data from a data source like SQL server?
Thank you in advance for your answer!
Great video! Very well explained and easy to follow. Thank you.
Brilliant! How do you do it?! Lucky to have your expertise.
Could you provide a video about how to make the comments/form email with power app in power bi?
Thanks fr this video , I have small clarification on to use POWER apps , I am using Azure tabular model as source for my power Bi report . So its live connection with tabular cube . Is it possible use the power apps here and edit the power BI report also . Could you please clarify this ? Its really urgent requirement for me . Because i could't see model tab in my power bi report since its connected as live connection
I tried the same thing with online share point list as a service.
The new data entered through power app is updated once refreshed in power bi desktop but it’s not working the same in power bi online!
Can you help me why so?
Thanks.
This is brilliant. I have something similar setup but not with DirectQuery. What is the data source type you use that you read in PBI and write in PA that supports DirectQuery? Thanks for a great show
Good question. I would like to know this too.
Will this be counted against Power App Premium connectors?
Very cool, super-helpful stuff. Y'all are really helping those of us in the field.
Hi Patrick, Very nice video. One question I have, If I have created reports from excel data source, then Is it possible to write back to excel using Power Apps and our reports are updated according? If yes, then how?
Hi Patrick, Love the videos! One quick question on this one: Why is it important to upload the report to the PBI service before adding the Power Apps visual?
For context, I missed that step and now I can't get the Power Apps visual to load in the service no matter what I do (darn it, it works fine in the PBI desktop!).
good question. is it still valid or given it is a year now since the creation of the video. is it now ok to build the power app in the desktop?
I know I'm coming to this late, but since you are editing the file on the PBI service, it makes the PBI that was worked on in PBI Desktop obsolete right? So do you save the file back down and post that to source control after doing all the updates?
Hello Patrick, is it possible to edit my power bi table visual. Like if I change a column the data in the visuals change as well
Hi Patrick,Thank you for sharing! clear and awesome video as usual!! Do you have an idea on how to export BI service report which with embedded Powerapps , and import it to BI desktop report? Cuz normally a BI service report needs to be updated from BI desktop report , and unfortunately since Nov. the new version of BI desktop have trouble supporting building or choosing an existing app to embed (have reported this issue to MS). That's why I'm trying to build the embedded powerapps in BI service..but now don't see a way to import it back to BI desktop, any advice is appreciated!!
So can I use this tutorial to build a power app that input KPI statistics through a form on power app and this data is embedded into a KPI power Dashboard?
Will this also work when you collect your data in PowerApps first with a ClearCollect function and base your fields on this collection? Great video btw!
Thanks!
What plan of Powerapp are you using to interact with your database? From what I can tell, it's a "premium" feature, correct?
I actually love this. Nice video
Where is the data going for the Power Apps entry? I have done this and linked to a Sharepoint List for the data, but I see no option for Direct Query. Am I missing something? Is there a better connection I should be using?
Thank you!
Hey guys,
I am quite new to Power BI, and currently I see there is much more functions and skills to obtain for me :o I've got a question, do PBI&PowerApps allow you to add some data directly through report view in PBI? I mean this example shows, that we can edit currently existing data, but how about adding new rows to our database? (For example if I create a pipeline, can I add new client/project via PBI or I need to open Excel and insert necessary info)
Thanks in advance :)
Hi, Galus. Basically, you can do any of DML operations (insert, update, delete) via PowerApp, it only depends on logic which you've implemeted within your PowerApp. UPDATE is only for example at this video. And please be aware that you do changes to your data not in in-memory Power BI data model but at underlying data source (for instance, SQL server).
@@vladyslavgovorukha9229 Oh thanks Vladyslav, editing data directly in data source was exactly my intention. Do you personally know any tutorial video treating about this topic?
Vladyslav is spot on. I love that it adds potential writeback capabilities. One resource you can look at is Shane Young's UA-cam channel. He has been doing stuff about PowerApps that may help - ua-cam.com/channels/7_OGRP8BYvtGB8eZdPG6Ng.html
7:57 - yes why is this still not a thing?! forever bringing my stuff into notepad++ to make it easier
you guys are next level!
Hi Patrick, would this keep a log of previous comments or overwrite them to the latest one?
Really great functionality! But what about security? Let's say you provide one only user with write access to some particular table. Let's say for editing products or address records... Is there any way for preventing break-in? If anyone gets credentials of this write permitted user, can he extend his permissions to delete the table he has access to via editing the App?
Guys am using excel and when I dropdown on the Storage Mode, I only see Import enabled while Direct Query and Dual Storage is disabled. How do I enable it?
This is so great!!!! I have one concern though. Let's say I have a report in mixed mode (both Import and Direct Query). I was able to edit Direct Query tables through my Power App, and changes gets reflected automatically, great!. Now, I also need direct impact on a calculated column of an Import Table. Calculated column, just like with slicers, does not gets updated. I'm able to create a measure, but I cannot use it as axis or columns in my visuals. Is there another alternative? I'm so close to get what I'm looking for for months now!
Thank you for your great channel!
Hello, thank you for the videos. Is it possible to export a power bi visualisation in a power app, and then create a mobile app with power bi dashboard?
Thank you for your videos, they are very good and helpful.
Dhia (from France)
Yes Patrick, it would be awesome if we can have the DAX format editor in Power BI.
Thanks for the video Patrick, just one question, it works with the "publish to web" option?
same question. do you have answer now?
@@ricky2976 No, i still don't know it
Am I the only one that can't find powerapp in power bi desktop
market place? Please help
If you instantly update your data with power apps, is there a way that these actions can become permanent records in a table/view in Azure Data Studio or Databricks?
Having issues, my data source is share point so not direct query, either way when I add fields to the visual they don't seem to be available on power apps...
Great video but you have a few things on your app I have been trying to find how to do, do you have a tutorial on creating your app by chance?
We do not. What specifically were you wanting to know?
it's very cool!read and write data in power bi.
yup! Love it. 👊
Hi Patrick
We are trying to create a workflow where we want to embed a PowerApps form in Power BI to collect daily sign-off from different leads on the daily profits and loss (P&L).
For this we need to pass P&L number calculated in Power BI to the form, so that the lead can approve, this approval is then saved in SharePoint list with leads comments.
Is it feasible to pass calculated numbers/measures from Power BI to Power Apps to populate certain blank items of a form?
Note: The profit and loss calculation is done a massive data model which we don't want to re-implement in Power Apps.
How to refresh power bi dataset from power app when Power BI Source is not direct query e.g Excel on OneDrive etc , as Power integration.Refresh() will refresh power bi dataset if source is of Direct Query type say SQL etc?
Great video. Keep up the good work
hey Guys! Is the PBiX available for this video? I'd like to test it on my system. Great job.
Need your help... I am trying put power points slides to Power BI and trying fletch data from excel file(some comments) to power BI using powerApp...
That's great! How do I manage the comments history?
Does the changes will update the data source data as well? like if the data source is SQL Server
How do I get my field Reset Year to show up in my Power App? Does it need to be in a specific format?
Hi Patrick, for large datasets that have new rows added every week, is Direct query mode better or is incremental refresh better ?
Hi, Nice video. I have a problem, because the first time I open the app in powerapp's editor it works perfectly. After I save and try to reopen the app or using it, ther is no info at all and the fields turn blank. Please tell me if there is any clue about what might has happened, Thank you
Hi Patrick, can we use PowerApps in power bi report server version?
Could you please share how did you make those data fields in Power apps editable ?
Excellent video , many thanks Partrick. So we now can change data as well as see data in a pbi report ! Thats werid.(But useful)
Yes! PowerApps Integration allows for data writeback capabilities.
can you show how to use connectors, like sales force connectors?
Is it possible to store measures values (Calculated on the fly based on slicers) into Azure Database using power apps?
Can we get, in PPowerapps, the value that was sent to filter the gallery ?
Just what I need. this is awesome. my one question, say i have already created report pages over a data model with a lot of tables and all the tables are imported into power BI. Do you have to change the import type of all the tables in the report or just the ones affected by the possible update by a user?
Werry nice until i saw the license cost...Are you kidding me!! $40 pr user/month.. We ar 600 users. thats $24K / month :-D ridiculous..
What code was on the item properly of the edit for, you demonstrated the patch but I'm having a bit of trouble getting the form to populate based on gallery selection
Hello GE
How to filter sharepoint birthday list by todays date in powerapps screen
my sharepoint name is birthday : name | DOB | birthday days & Months i had used powerapps
filter(sharepoint list name source file , birthday day & months =today()) but dosent display todays list in powerapps can you help (formula)
What do you do with refresh if your data source has more than 2000 items.
Patrick: Love your Video. Can you provide a link where I can download data you are using in this Video? That would me/us create what you are doing (hands on for us)
Terrific video - Have everything working well after creating a new PBI and PowerApp. Only difference to your video is the auto refresh. My powerapp doesn't know anything about the "PowerBiIntegration.Refresh' statement. Only PowerBiIntegration.Data is available within my PowerApp - why is this ?
I think the problem I am having is the fact that the PowerAPP I have created was created via PowerAPPS itself - where I think the suggestion is I should have created it via the Create app link in the PowerBI PowerApps visual. Ive tried doing that but the App builder generates an app so far different to the app I want to create. In the video they link to an existing app - the question is whether that app was created via PowerApps or the PowerBi PowerApps visual. Some clairty would be great on this. Why does my powerapp suggest that the PowerBiIntegration.Refresh() function does not exist
Anyone else experiencing the PowerBIIntegration.Refresh() bug? The bug occurs when you call the function and all the filtered records disappear, leaving all the visualizations blank as there are no data filtered. It only started happening after the most recent wave of updates.
Thanks Patrik!!
I'm a little bit confused. I always create and update report pages in Power BI desktop. If I create the Power App in Power BI Service Edit mode and save, then go back to my pbix file to continue on with my reports, the new visual isn't there (fair enough because it was not created in the pbix file. Then if i amend another page in Desktop and publish obviously the power App disappears. Basically, Are we saying that we can only add the PowerApp when we have totally finalised the reports and we don't need to amend the pbix file anymore? for me, that's not something I can do because we are always have more updates to add. Surely you should be able to add this into the pbix file?
Yeah that part can be frustrating. You would need to re-setup the PowerApp if you re-published from Power BI Desktop. Although in the September 2019 release of Power BI Desktop, the PowerApp visual is a native visual now but I believe the steps are the same.
I am missing something maybe, but didn't @Neil McLeod address this exact scenario in his comment above?
Hi Patrick,
I know my question is not related to this video content but I really need help on power bi embedded vs. Power bi premium license.
Queries: We don't wanna force end users to purchase any license to make the use of the power bi reports. We have lots of like 150 to 200 external users who wanted to see the reports so adding all of them into our organisation AD is not feasible so which license we can opt for this scenario.
Please help me out as this is very aggressive and time critical requirements for our project.
Any lead would be really appreciated.
Can I use this to update MSDynamics CRM data? I was wondering how it integrates with that specific CRM.
Great video! I wonder what if your Stores table was in Import mode, would've worked anyways?
WIll work after refresh
Can you help me with,upload pic to gallery (to able to view the same) and then send to share point,as of now am able to send only 1picture, one by one and able to view only the latest pic in powerapp
Hey guys, great vid as usual. Did have a question - is it possible to make an update via the Power App (which still reflects in all the relevant visuals in Power BI) but have an option to discard changes and revert back? So I wouldn't necessarily want it to write back to the Power App per se. Hope I've explained that well. Thanks
Power Apps course, can anyone recommend one?
Awasome, just what I needed to learn!!!
hey Pat , the Blank Panther is so distracting ! i knew what had you had set up, in the vision, sat not in the center stage !
Can someone share a generic example of Dax code that can be used in the power app editor to assign a button to update a value in a text field?
Hello, I have a question- Can we use an excel file from sharepoint as a datasource in Power Apps?
Yes easily