Can’t INPUT DATA in Power BI? Here is a WRITE BACK Option with Power Apps!
Рет қаралды 270,623
Күн бұрынIn this video I will show you how to write back to the data source from Power BI. Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks!
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly support@datatraining.io
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:47 Creating a Power App and have it interact with other Power BI visuals
03:14 Creating a form in Power Apps
05:18 Show data of selected items in the Power App form
08:02 Add a button to a Power App Form
11:00 Trigger a data refresh on submitting a Power App form
14:16 Using a data source with direct query as storage mode
15:27 Visualisation options for the Power App visual
17:25 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on KZfaq: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI #PowerBI #DataTraining
#powerbidesktop #powerbitraining #powerbideveloper #DAX
@johnsamuels9564 2 жыл бұрын
This is the single most impactful Power BI video I have seen… anywhere. Many KZfaqers teach and demonstrate applications, but The creativity you apply to your solutions makes you a standout and front-runner among your peers. Awesome work!
@HowtoPowerBI 2 жыл бұрын
John, thank you very much for the kind feedback :) really appreciate it!
@jpctm7508 Жыл бұрын
Amazing!
@mellowcat42 Жыл бұрын
He's the Paul Davids of Power BI :)
@delicious9930 Жыл бұрын
I haven’t even started the video but just by this comment I know it’s going to be good :)
@erinfield1943 Ай бұрын
He is terrific, but he learns from other youtubers who aren't as famous, and then makes their solutions more bite-sized, edited, and aesthetically-pleasing. No question he brings value, but it's always good to credit who you learned your tips and tricks from.
@RanmaSaotome666 2 жыл бұрын
A quick tip: create a measure in powerbi for selected value, and pass that to powerapps. Like this you can add an overlay message in the powerapps, where if the passed measure value is blank or erro you can sho a message with "no item selected". like this you will not have always the "first item" of the list ;)
@ajitgosawami6851 2 жыл бұрын
Go
@howardzonder8316 Жыл бұрын
I'm looking for a video on how we can do that. Please help me with how i can set it as a new form by default and when i select it shows the related record to edit. I'm not using the gallery as shown in the video and a single screen for edit and adding a record
@mingp7247 2 жыл бұрын
I decide to watch all your videos. Its incredible! Cant wait to learn more about the difference between import and direct query. Sir, can you make a video of that? Big Thanks!
@elhabribenzeguir5653 Ай бұрын
I have leaned a lot from you ! Your videos are condensed with small tricks and information that makes the watcher move forward quickly. Thanks you man !
@hi55us2 2 жыл бұрын
Great video, I ended up building something similar about 6 months ago! The data source I was using was import only and what I did was included a visual that appeared if the data set had been refreshed in the last 2 hours that said to the user not to refresh the data. Fortunately my power bi report wasn't having data entered it was more having dynamic parameters that were stored in OneDrive.
@aferrandiz Жыл бұрын
I have seen dozens of videos talking about integration, but yours is the only one that actually teaches how to do it effectively. You are the best!!!
@HowtoPowerBI Жыл бұрын
Thanks a lot Alan! This made my day!
@SamiaAllaou Жыл бұрын
Great content and super useful. Just a little comment, would be great if you can share the full screen instead of snips. It'll help us locate where things are. thanks a lot!
@yandhi4202 2 жыл бұрын
That’s great thank you for the thorough walk through!! I wish there was a way for the user to just write directly in the cell and be able to copy paste down - like in excel
@HikimaruL2 2 жыл бұрын
That is great, I hope you continue posting more about these other tools such as Power Apps and Power Automate, and how they can help our Power BI Reports. Great video!
@HowtoPowerBI 2 жыл бұрын
That's the plan! +1000 other topics ;)
@HikimaruL2 2 жыл бұрын
Also, I know it is kind not what you are trying to show here, but it would be nice to see the steps of setting a simple excel table into the SQL server or Data Verse. Thanks!
@ildashabani2358 Жыл бұрын
That was such a helpful and useful tutorial. Thank you for being very clear 😊
@buddy332 2 жыл бұрын
Right in time for my Project. Thank you @How To Power BI!
@ChewingGum113 2 жыл бұрын
Thank you so much for sharing this. I was about to use only Microsoft form and have an URL reference from my PBI report. But this is so much better and updates the source right away!!! Great video!
@HowtoPowerBI 2 жыл бұрын
Fantastic! Happy to hear it helped :)
@chronicallyVirgo 2 жыл бұрын
Hi, this was extremely helpful. Thank you so much! I really needed this, I'm currently working on something similar and you explained it so well. One question though: can I use a .txt file generated from an ETL job as the source dataset in Power Apps? Thanks!
@adelawilliams2260 Жыл бұрын
Amazing!!! Thank you so much for the excellent demonstration!
@zerobars3 Ай бұрын
Great Tutorial, answers a lot questions. Thanks
@mohanreddyk1983 Жыл бұрын
Hi Bas, Really gained knowledge out of this video to implement at my work. The way you explained is really AWESOME... Thanks a million and keep going....
@benjisamuel2399 Жыл бұрын
Thank you sir. you are Genius. your video helped me to create my first power bi report integrated with power apps and power automate. God bless you sir. you are just amazing teacher. you make even the difficult topics very easy to understand.
@ofentsekoolopile4811 2 жыл бұрын
Bas my man, you saved me big time with this video !! Very good content !!!
@eugeneopachev480 2 жыл бұрын
Hi BAS. I really like your videos. I often run into a problem when I need to move the filter context to another page. But detailing is not applicable in my case, because it transfers all the filters of the original page, and not the one I need. For example, I want to highlight on the first page a certain product that customers bought, but I don’t want to transfer the filter where and when they bought it. Those. I only need to sync the filtered ClientIDs. It would be great if you cover this topic in your videos. Thank you very much for your work!
@nicolaschinchon3403 2 жыл бұрын
Thanks for the video. I have been strugling with writeback for a few weeks. first time i notice you kind of "please work", face ... but i still think its quite tricky. thanks again, love your content
@williamleveson-gower5088 7 ай бұрын
I deeply appreciate this video !!, thank you !!.
@drtonys.6963 Жыл бұрын
I have watched many videos, good work here. Learning alot
@diyhell8712 Жыл бұрын
Love this! Clear, easy steps and some interesting stuff re refreshing data sources which was me to me. A bit about power apps subscription requirements for each option would be the icing on the cake.
@HowtoPowerBI Жыл бұрын
thanks will keep this in mind for the next time :)
@Chris-wb1pz 2 жыл бұрын
I was searching ALLLLL day for this solution on KZfaq and through Google. I wish I had remembered that I received a notification for this video.... Oh how the stars align. Thanks Bas!!
@HowtoPowerBI 2 жыл бұрын
Chris, glad to hear my timing was right, hopefully next time too :) take care
@brianmariscal5401 Жыл бұрын
Excelente explicación y paciencia para brindar buena e importante información. Te agradezco mucho, de seguro que lo pondré en práctica. Abrazo! BMAZ desde Buenos Aires - Argentina 😊
@dcpowered 2 жыл бұрын
I really enjoy your videos. They are complete and very enlightening! Could you please make a video on star schema in Power BI. It is a confusing topic. Please show a project on how to use it. Thanks!!
@Brothercole1994 2 жыл бұрын
nearly 40k views but only 28k subs, cmon guys , this is amazing content!! Show Bas and the team some love
@KN-wi4ns 2 жыл бұрын
Thank you for sharing, inspiring seeing how you work, and passing knowledge…
@HowtoPowerBI 2 жыл бұрын
My pleasure! thanks a lot for your kind words!
@SoNonWoo Жыл бұрын
Thank you. This was super helpful. How can this be modified to write to several cells in a column? I would like to use this to validate records, but I would like to validate a selection set instead of a lone value.
@khaledbelhadj5587 Жыл бұрын
Very nice demonstration .Thanks for sharing.💙
@nawafsharaf 3 ай бұрын
Thanks so much for this Bas , This helps a lot !
@felixhau8249 Жыл бұрын
Mindblowing Bas! Honestly I am very new to PowerBI and I am just slowly grasping the possibilites of it. Great video
@HowtoPowerBI Жыл бұрын
:) wonderful, especially power apps integration opens up a whole new world! Good luck with it 😎
@shivamchaudhary4456 11 ай бұрын
Hi Bas, really interesting video and so simply explained. I am going to apply the learnings in current video. If you dont mind can you please tell how did you manage dividing the screen and show what you were typing at the same time while speaking. It will be of great help to me. Thank you.
@pavankumar-hw6zb 2 жыл бұрын
Great great great .... Video waiting this kind of video for so Long Thankyou very much ... This is much needed in every organization by financial team
@HowtoPowerBI 2 жыл бұрын
So nice of you :) thanks for all the kind words!
@TrassBI 2 жыл бұрын
Very useful. Thanks for sharing.👍
@mabl4367 2 жыл бұрын
Great video. I have worked with this myself and I have expirienced some of the limitations. If your dataset contains large amounts of data it will not fit into the powerbiIntegration Object. The limit looks like it is 2000 records. If you include multiple fields from your power bi model into the powerapps visual then each unique combination of values in those fields will be represented by a record in the powerbiIntegrationObject and the limit is still 2000 records. This means that you will very fast run up against this limit and you will get no warning when you exeed it. The data will just be missing in the integration object. Also when using direct query you have to be really carefull or prefornance will suffer.
@EagelzOfficial Жыл бұрын
Is there a possibility to have more than 2000 records in your source file?
@josefernandoramirezamador2280 Жыл бұрын
@@EagelzOfficial Use Filter function on Datasource before apply the condition for specific item
@prosperduke Жыл бұрын
You absolute legend thanks for this i was wondering why my dataset with 2.1 mil records refused to work
@user-dl6xg1jq3y 3 ай бұрын
This is Brilliant, for those people for whom the intial filtering of data set didn't work from desktop and you're scratching your head, you need to first upload the dashboard to the service and then it will work.
@savyasachimurulyashridhar7156 2 ай бұрын
How do you do that?
@eladushkegm 5 ай бұрын
Thanks a lot Bas. Really helpful
@amandajrmoore3216 2 жыл бұрын
What a useful video, often a facility need to explain to people and now will just send them you video thanks excellent .
@HowtoPowerBI 2 жыл бұрын
that's great to hear. Thanks for watching Amanda!😊
@ericrudawski8586 Жыл бұрын
Thank you Bas, great content as always. What would you say are the pros / cons of embedding PowerApps inside of PowerBI, versus embedding PowerBI inside a PowerApp through tiles? Have a use case where a small team is responsible for reviewing a report, and adding comments on a monthly basis.
@nlvq Жыл бұрын
To use sql or dataverse at end you need pro power apps per user…
@neerpanwar Жыл бұрын
LOVED THIS! You are god sent!
@HowtoPowerBI Жыл бұрын
Thank you so much!!
2 жыл бұрын
Amazing tutorial, congratulations! Thank you very much for sharing this
@HowtoPowerBI 2 жыл бұрын
You're very welcome Matheus! happy you enjoyed it :)
@Pavlushok 2 жыл бұрын
Hi! Thanks for video. I have a question, can i edit summarized data in table with PowerApps? For example i need to edit summarized forecasts in table to view changes in whole year.
@yehiman Жыл бұрын
Fantastic, bro...thanks very much...
@tarnapro77 Жыл бұрын
Great video and I decided to test this. I run into problem however, as the PowerApp is created to different environment than where my data is. This will require some investigation to find out if I move the app to another environment or define in Power BI which environment to use with Poweraps.
@jamesrosicky2912 2 жыл бұрын
Hi Bas, Would you be able to show how to use Dataverse to add power app that will allow us to write back to PowerBI?
@gregoryoliveira8358 7 ай бұрын
Very very very good! I will need to do something like this.
@stuckdata3484 2 жыл бұрын
Nice video! I have a question, this works when we have a Direct Query? I mean with a connection to a cube on Analysis Services
@PabloBadenas Жыл бұрын
amazing video! Thanks for all the details!!
@HowtoPowerBI Жыл бұрын
Glad you like it :)
@siddharthalethbridge995 22 күн бұрын
Bas you're a legend and have a great smile. Thanks for the vid
@datadragyn 2 жыл бұрын
This is incredible 👏 thank you for this video.
@HowtoPowerBI 2 жыл бұрын
Amy, I am glad you liked it :) Power Apps are soooooo cool...
@lampjr2 2 жыл бұрын
Hi! Kinda new to Power BI here... first of all, great video! It gave me a lot of ideas on how to edit datasources way easily. I just have a question... does that DirectQuery option of refreshing on the spot also works with an Azure Databricks query?
@javierpereyra7098 2 жыл бұрын
The scope of this solucion si really inmense, great video as always. Greetings from Argentina.
@javierpereyra7098 2 жыл бұрын
PD: Hope this year "editing tooltips" will be easy
@tallalaazmi1287 Жыл бұрын
Hey Bas! Amazing work.... Love your videos, Followed this and able to write back data! Just an issue I'm getting that I want that bookmark way to pop up power app visual, but the selection made in the table doesn't carry along, any idea about this?
@user-cv5hd1jg8w 4 ай бұрын
Very informative video. Do you have a video on how to delete an entry, not just edit it?
@ruiwang1875 Жыл бұрын
Hi Bas, thanks and what a greatest video I have ever seen for power bi. Just one question for integration, how could we write data from power bi to a sql server database. I am looking forward for the solution ❤❤
@sanketkulkarni3 2 жыл бұрын
Thanks for sharing, its really helpful !!
@HowtoPowerBI 2 жыл бұрын
You are welcome Sanket, glad it helped!
@atheelxall2523 Жыл бұрын
Thank you for sharing with us this helpful video. But how about creating a form to get changeable data and represent it in Power BI?
@c.nikhilsimha3271 2 жыл бұрын
This video is great, but have a quick question, should the datasource for powerBI and powerApps be the same? Please clarify
@mnesevati 2 жыл бұрын
Hi, many thanks to you!. I have a question, regarding using SQL database, it works on Powerbi Desktop, but when I went to PowerBI service, it didn't work and I can't see the app and the table as well. I tried to figure the issue out but I could not ...we'll be highly appreciated
@Ctan618 Жыл бұрын
This video was very helpful for me! Is there a way to enable multiple filters? In your video, you show how to do it by Client ID. In my situation, I have two filters where the first is "customer" and the second is "region", and I want to have it so that users can writeback comments to "customer 1 + America" vs. "customer 1 + Asia".
@lhoussineelomari5689 5 ай бұрын
Very instructive video Thanks a lot
@HowtoPowerBI 5 ай бұрын
Glad you liked it
@OlayemiOA Ай бұрын
This is really helpful Bas, I will try to follow this step.
@HowtoPowerBI Ай бұрын
also check out the more recent video that I did on this topic -> kzfaq.info/get/bejne/a7WYo5pqtbLQfWw.html
@terramex73 4 ай бұрын
Great explanation ! You are the only one explaining clearly. What I do not understand is if I have users in parallel logged in the system, if I can use the same Planning tool, to plan for example on different cost centers. So they do not plan on same data, but each one will input data on different cost centers. Can this be done in parallel ? So is the PowerBI application a central planning tool, or everyone should have for example the powerBi application sitting separate on a sharepoint folder dedicated to him/her ?
@srikanth06451 Жыл бұрын
Yes, What john Samuels has said is absolutely correct . I have a question on this write back functionality , what if we dont have an ID column , How to work with such kind of things?
@Primaveraweb1 2 жыл бұрын
That's Great...Thanks for knowledge sharing...🙂
@HowtoPowerBI 2 жыл бұрын
thank you Vijay😀
@massimocolaceci 2 жыл бұрын
Hi Bas, thanks for showing us such an interesting workflow. I wonder if Power Platform allows to add a customization: to enable the editing form only for a user (or for a group of users), in the report, and let the rest to read-only the table
@vedapriya3269 Жыл бұрын
Yeah I was about to ask same question.... I wanted to restrict to only for few users
@Carlossa-619 Жыл бұрын
I'm looking for the same feature, have you been able to find your solutions?
@jonsmanning Жыл бұрын
Awesome vid! My PowerBIIntegration is connected to a fairly large dataset. Any tips on how to apply a filter to the Item section to avoid the Delegation Warning?
@rajarshisingh2547 2 жыл бұрын
I have implemented the same solution using the trio application on the power platform. I created a custom app wherein there are more functionalities and the refresh is using power automate but I'm not refreshing the whole dataset rather using the xmla endpoint to refresh only the commenting tables. Unfortunately as my client is a bank it has some issues with data security and is in talks with Microsoft hence power apps and automate I couldn't use in production environment and I had to ultimately create it in sandbox environment as a POC
@killiangraas9355 5 ай бұрын
I think you are the best thanks you help me a lot
@HowtoPowerBI 5 ай бұрын
😁i wish ;) .. thx !
@WillY1905 Жыл бұрын
Hey Bas, what about the sizing of the app, is it possible to make it smaller?
@vicenteantoniomagallanesju5289 2 жыл бұрын
Hola gracias por tus videos , tengo una pregunta tengo un cliente que quiere ver las ultimas 8 semanas del informe y luego seleccionar hacia atrás en el tiempo y que se vayan sumando a esas 8 establecidas , la verdad no se como hacerlo crees que podría hacer en power apps como un filtro dinámico de fechas que se autoseleccione en base a una condición??
@nataschalaros418 Жыл бұрын
Hi Bas, this is great. I would like to try it but it the Power App visual that you use is not available for me. Could it be that I need a newer version?
@kavinyudhitia Жыл бұрын
Thanks. Its helpful!!
@HowtoPowerBI Жыл бұрын
Cool, happy i could help
@Rudenezz 2 жыл бұрын
Power apps seems awesome .. 👌🏽 great tutorial! Where did yiu learn to use power apps? Are there courses? It seems pretty new and not much learning resources out there 🤓
@iancockcroft9427 2 жыл бұрын
Hi Bas, great solution. thanks.. I am working on a report that has a SQL source. Because users dont have Premium licence, they cant write back to SQL. They will write back to a form in sharepoint. from here it can update the SQL. How do i load the app with the line i have selected. ie. data from PowerBIIntegration source? is this a good work around?
Жыл бұрын
Thanks!! Very insightful video!! Just a question, when you said that pro licenses has an 8 limit, is this per day? Month? Ever???
@guptaashok121 Жыл бұрын
This is good. I am also using xls from one drive and able to update data however it does not reflect I power bi for about 30-50 sec even if I do manual refresh multiple times. Is there any work around for this or any setting needs to change
@willianthalles Жыл бұрын
Come on. This was great!!!! I'm thinking in different solutions already into my project with this video. Great stuff brother
@HowtoPowerBI Жыл бұрын
Awesome! Good luck Willian :)
@cathrerinezetadrones3169 7 ай бұрын
What interesting is on the PBI phone app you can interact with some tooltips. Depends on what is visual it is on. So it could be a simple implementation for non phone clients
@RotterdammerInMiami Жыл бұрын
Thanks so much! It works ❤ One question, hope someone can help me out.. The app isn't sharp in my Power BI. Something with the size I suppose, but I cannot change the size. Anyone advise on how to handle this?
@benjisamuel2399 Жыл бұрын
Hello Sir, I really like your teaching method. its amazing. you have a great knowledge. sir i have a small question though. the issue i encountered. say if you have an empty NULL cell in sql server table you can write it with power apps in power bi. but the problem is once you write something you can change it with some other value but you cant make it NULL again. I will be thankful if you can help in this sir. Regards.
@tyannamorrison8252 9 ай бұрын
Awesome video!! It seems I am having trouble with the lookup formula. Using 'Goal_Id' where your client id went in the lookup formula. I am getting an error saying, "Expression Goal_Id eq null is not supported". Any insight on how to fix this?
@sharmacreatives255 Жыл бұрын
You are really awesome sir 🙂
@user-jf9pn8re7x Жыл бұрын
Hi Bas, thank you for this video! You are always my go-to for anything Power BI related that I do for work - which is a lot! I follow your video steps by step, but I've found that once I update the app for the form, save and publish, my Power BI report does not update - it gets stuck on Getting your data... I have searched for a solution online but nothing comes up. Do you know a way of solving this?
@ryharpon 4 ай бұрын
I have a similar issue, the PowerBI does refresh with the new edit however the PowerAPP FORM is stuck with "Getting your Data". Users are having to click back on the record in PBI manually for the App to reload.
@tarashinponnen5998 Жыл бұрын
Best PowerBI Channel around
@HowtoPowerBI Жыл бұрын
Thx!
@ishiitapal 2 ай бұрын
Hi will the lookup work with matrix visual?
@QuynhNguyen-op6tx Жыл бұрын
Hi, This is really cool. After seeing your video, I am wondering if I can make something like a quote form with multiple line items in powerbi. Do you think this is something I can build using this tutorial? Love to take this offline if it helps to explain it.
@480thConsulting Жыл бұрын
This works ... but is SO complicated / clunky to get going. The cell should just be editable directly in the table like an excel sheet. No sausage making back end stuff that can break on you.
@MrErolyucel 2 жыл бұрын
Perfect solution
@HowtoPowerBI 2 жыл бұрын
Thanks!!!
@Galu97 10 ай бұрын
This is amazing and a great video, really well explained. I working on something similar, but I want to use Power Apps as a notebook while consulting infomration from a Power BI Dashboard, the Dashboard extract information from a Cube-Data Base, does anybody know how can I start with the connection?
@ohmoneymoneyhome6430 2 жыл бұрын
is this function available for power bi desktop?
@jensflemmig9168 5 ай бұрын
Great video.. thnkas a lot... even a year after it is published: I have a questiion: the source data (excel) that I want to write back is connected to an dataflow and the report is connected to this dataflow. As consequence, the refresh would need to run in a sequence... Write back data to source excel --> refresh dataflow --> refresh dataset. Is there any intelligent solution for this? Thx a lot
@vishalnasre1251 2 жыл бұрын
Hi, Is there any way to formate values in multiline card, As million because by default it shows whole value
@-_--zq5ft 2 жыл бұрын
Hi Bas, the formula at minute '6:51'... what does it look like in case of connection to a sharepoint list ?
@user-sd4np4sr4q 5 ай бұрын
Thank you for this video. Could you tell me if it's possible to use power apps to write back to let's say Excel or Smartsheet all the report data plus user's input IF the source of that report data is coming from Snowflake. I know that SF is a premium connector so would such a workaround be possible at all? If yes, would that just require Excel or Smartsheet as data source for power apps to be selected? Thank you!
@alexrosen8762 2 жыл бұрын
Great stuff! Thanks :-)
@HowtoPowerBI 2 жыл бұрын
hi Alex, very happy you like it! :)
@mtavassoti 2 жыл бұрын
Bas, thank you for the good content. Can I ask you what makes you think people wants to see your face more than the content they want to learn about please? It's so hard to follow what you are doing trying to do/teach when I can't see the whole window!
@HowtoPowerBI 2 жыл бұрын
Thanks for watching and for your feedback
@i.b.elivan1976 4 ай бұрын
Hello do you have a video on how to set up the last option with Message button?
@tangtom2478 2 жыл бұрын
Thanks
@HowtoPowerBI 2 жыл бұрын
Thank you very much for supporting my channel :) much appreciated!
How to Power BI
Рет қаралды 53 М.
How to Power BI
Рет қаралды 78 М.
Reza Dorrani
Рет қаралды 135 М.
MITutorials
Рет қаралды 9 М.