POWERAPPS and POWER BI can do what?!? It's bananas!

Подписаться 437 тыс.

Просмотров 319 тыс.

50% 1

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.com/powerapps/...
PowerApps custom visual: docs.microsoft.com/powerapps/...
********
LET'S CONNECT!
********
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
Check out my Tools page - guyinacube.com/tools/
#PowerBI #PowerApps #GuyInACube

Наука

Опубликовано:

20 авг 2019

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 173

@DPFierce 4 года назад

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!

@DreeKun 4 года назад

I'm just starting with Power BI, half a year now. Do you think i should check PowerApps, already?

@DPFierce 4 года назад

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!

@nelsonma4711 4 года назад

Patrick, I can think of so many stuff we can potentially achieve with this integration! You are right, it's "bananas"!!! As always, thanks!

@mangeshmehendale4139 4 года назад

Wow - this is the real deal! You should consider doing more than power BI if you can keep it this simple and relevant. #respect

@GuyInACube 4 года назад

Appreciate that Mangesh. Definitely something to consider. 👊

@Grim821 4 года назад

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.

@GuyInACube 4 года назад

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! 👊

@sivasakthi5315 4 года назад

This is so true. I watch your videos just to learn the possibilities. Every video is unique and informative. Thank you guys.

@vijaybodkhe8379 3 года назад

The energy with which you explain the things creates interest for learning ......Cool ....another great video by the Guy in cube

@waysilentbob6976 4 года назад

Power Apps and Power BI together at last! So many possibilities!

@rabidmongooseSEA 4 года назад

Very cool, super-helpful stuff. Y'all are really helping those of us in the field.

@gregpetrites4182 2 года назад

This was exactly the information I was trying to find. Thanks!

@etiennereynecke8717 4 года назад

Great, now I can also use Power Apps in Power Bi, Tried it and it works perfectly. Thanks Patrick.

@GuyInACube 4 года назад

Yup! It provides a great synergy.

4 года назад

Hi Etienne, what data source did you use for directquery that is supported by both PBI and PA ?

@derrontaplin7835 4 года назад

Great video! Very well explained and easy to follow. Thank you.

@927dice 4 года назад

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!

@balajipadmanabhan268 2 года назад

Thanks a lot Patrick!

@AHMEDALDAFAAE1 2 года назад

This is amazing! Thousands of THANKS!!!

@ovaispathan5065 2 года назад

Man, you are just awesome with your explanations....

@johng5295 Год назад

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++ 💥

@katherinebarnes4082 Год назад

Thanks!

@Zatiels 4 года назад

Yay! Thx guys!

@bero5541 2 года назад

Thank you!

@heathfindsvideos 3 года назад

I actually love this. Nice video

@uniQue_XL 4 года назад

Thanks Patrik!!

@AndreaRodriguez-mj2os 3 года назад

you guys are next level!

@ramakambhampati5094 3 года назад

you are Power bi "Power Star" with 5 Stars....Brightest Star i never seen ....Thanks sir

@Sivakumarpoornima 3 года назад

Interesting and Very Nice to Know. Thank you so much for sharing

@facun_OK 4 года назад

Awasome, just what I needed to learn!!!

@caseyrmartinez 4 года назад

Great video. Keep up the good work

@gorxor 4 года назад

That is so awesome! I didn't know that you can combine them. Oohh... nice You rock

@GuyInACube 4 года назад

It is very awesome! Thanks for watching 👊

@DataSpinners 4 года назад

Love it Patrick - it's crazy how you can have PowerApps inside Power BI AND you can have Power BI inside PowerApps too!

@mcsespitia 4 года назад

Brilliant! How do you do it?! Lucky to have your expertise.

4 года назад

Patrick: you are crazy - how could I give TWO big thumbs up?! :-)))))))) ....I enjoy every our lesson - keep on!

@NewMayapur 3 года назад

Hi Patrick, for large datasets that have new rows added every week, is Direct query mode better or is incremental refresh better ?

@debbieedwards7267 4 года назад

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?

@alexaroberto900 2 года назад

Hi Patrick! Please could you share a total guide for the application in PowerApps that you show here, please thanks!

@Pooja-pd1ee 3 года назад

Could we have a separate video on how the power app was created?

@TheMathizze 3 года назад

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!

@daphneboateng7516 3 года назад

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

@adamwillis1299 4 года назад

hey Guys! Is the PBiX available for this video? I'd like to test it on my system. Great job.

@jenskemeijs 3 года назад

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!

@RotterdammerInMiami Год назад

Great video! Do you happen to have a template of the PowerApp you are using?

@user-js4gf4is7r 4 года назад

it's very cool!read and write data in power bi.

@GuyInACube 4 года назад

yup! Love it. 👊

@ioannispanagiotiskipouros5976 2 года назад

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?

@shilpamahajan2921 3 года назад

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?

@benoitrochette8849 4 года назад

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!

@laffiny 3 года назад

can you show how to use connectors, like sales force connectors?

@mikolastewart2458 4 года назад

Can I use this to update MSDynamics CRM data? I was wondering how it integrates with that specific CRM.

@aogliki Год назад

Great Video! is there a way to get the usage data of an app in Power BI besides the "Preview" in PA Studio?

@n2datasolutions443 3 года назад

Could you do a video on how to achieve this using a sharepoint online list, mans struggling right now ngl

@MakePositiveImpact 4 года назад

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)

@likithasiddi1155 4 года назад

Hi Patrick, Please try to do more videos on Power Apps .I really understand the way to explain with scenarios

@GuyInACube 4 года назад

Not opposed to doing more. But, we focus primarily on Power BI, so we try to tie everything back to Power BI.

3 года назад

Hello, I have a power apps channel and maybe I can help you, I'm from Brazil, but the videos have subtitles.

@joec4720 4 года назад

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?

@dzay3410 3 года назад

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)

@mitalipatel2621 2 года назад

Could you please share how did you make those data fields in Power apps editable ?

@dnickgt16 4 года назад

What plan of Powerapp are you using to interact with your database? From what I can tell, it's a "premium" feature, correct?

@beckyshao1729 4 года назад

Yes Patrick, it would be awesome if we can have the DAX format editor in Power BI.

@framusk5585 2 года назад

Could you provide a video about how to make the comments/form email with power app in power bi?

@aprilowen9437 3 года назад

How do I get my field Reset Year to show up in my Power App? Does it need to be in a specific format?

@henryouang 4 года назад

I want my PowerApps channel to become just like yours. Except for PowerApps! Love the "small channel" feel. Thanks for the great info.

@GuyInACube 4 года назад

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 👊

@henryouang 4 года назад

@@GuyInACube 100%. I'm going to keep up! I'll keep watching your great videos as well.

@gopinath3396 4 года назад

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

@rustice2 4 года назад

Great video! I wonder what if your Stores table was in Import mode, would've worked anyways?

@kapillehar5747 4 года назад

WIll work after refresh

@shabeermp6989 4 года назад

Hi Patrick, can we use PowerApps in power bi report server version?

@rodelharvey 3 года назад

Does the changes will update the data source data as well? like if the data source is SQL Server

@databases2288 3 года назад

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?

@AliTwaij 4 года назад

Excellent video , many thanks Partrick. So we now can change data as well as see data in a pbi report ! Thats werid.(But useful)

@GuyInACube 4 года назад

Yes! PowerApps Integration allows for data writeback capabilities.

@priyasharma-rq4iw 3 года назад

Is it possible to store measures values (Calculated on the fly based on slicers) into Azure Database using power apps?

@luisernestosanchezacevedo4982 4 года назад

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

@mshparber 3 года назад

That's great! How do I manage the comments history?

@n2datasolutions443 3 года назад

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

@haroon420 3 года назад

Hi Patrick, would this keep a log of previous comments or overwrite them to the latest one?

@rebeccaj138 4 года назад

What do you do with refresh if your data source has more than 2000 items.

@n2datasolutions443 3 года назад

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...

@deborahadeloye851 2 года назад

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

@amit260183 3 года назад

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?

@electrobritable 4 года назад

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?

@GuyInACube 4 года назад

We do not. What specifically were you wanting to know?

@markvanblargan9813 2 года назад

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?

4 года назад

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

@pietjehans206 Год назад

Good question. I would like to know this too.

@mjess84 4 года назад

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!).

@akthar3 2 года назад

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?

@aniking145 3 года назад

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?

@hannguyenngoc7269 Год назад

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?

@mattstyles9714 3 года назад

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?

@vikasbairy5143 4 года назад

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...

@test123ok 4 года назад

You're kind of a big deal... haha.. thanks so much. Very clear explanation. first video I've seen of yours and I've subscribed.

@test123ok 4 года назад

As xibit would say ... "so you can powerapp when you BI and BI when you powerapp"

@williamscolaro1159 4 года назад

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?

@bezen7808 2 года назад

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!!

@bmxsmurf88 2 года назад

7:57 - yes why is this still not a thing?! forever bringing my stuff into notepad++ to make it easier

@JEffigy 4 года назад

Hehe love your little comment, wouldn't that be nice to have that in a little DAX editor...wouldn't that be nice! Lol hint, hint nudge, nudge...hell yes 🤣🤣🤣👍

@jaysizmir9432 2 года назад

Can we get, in PPowerapps, the value that was sent to filter the gallery ?

@chaslesabimana8444 4 года назад

Any other resources/websites on power apps that you can recommend? Sounds exciting!

@DPFierce 4 года назад

Check out Shane Young on RU-vid. ru-vid.com/show-UC7_OGRP8BYvtGB8eZdPG6Ng

@ghazanfarabidi4137 4 года назад

You're right, the banana readings are off the charts on this one!

@GuyInACube 4 года назад

haha love it 👊

@rajarn7566 4 года назад

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

@allanadriano7534 4 года назад

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.

@FabioSalinas1982 4 года назад

Thanks for the video Patrick, just one question, it works with the "publish to web" option?

@ricky2976 3 года назад

same question. do you have answer now?

@FabioSalinas1982 3 года назад

@@ricky2976 No, i still don't know it

@trevorsavin380 3 года назад

Hi pat great video but I don’t see powerapps in my visualisations- powerbi desktop may 2020

@germantejeria3677 3 года назад

Me neither :-(

@paritoshromy 3 года назад

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.

@PCube27 2 года назад

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.

@tahreemansari4867 4 года назад

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.

@prakug 2 года назад

Will this be counted against Power App Premium connectors?

@ektatomar303 4 года назад

Hello, I have a question- Can we use an excel file from sharepoint as a datasource in Power Apps?

@arunrohilla9597 4 года назад

Yes easily

@corby8678 3 года назад

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)

@ajaaskelainen 4 года назад

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).

@shingomcleod 4 года назад

@ 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!

@ajaaskelainen 4 года назад

@@shingomcleod Thank you for the insight! It's very useful!

@carolinemcdougall3422 3 года назад

GEAUX Tigers! 💜💛

@GuyInACube 3 года назад

Yes! Geaux Tigers!!!!!

@shaunandkatewilkinson1746 4 года назад

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 ?

@shaunandkatewilkinson1746 4 года назад

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