Can’t INPUT DATA in Power BI? Here is a WRITE BACK Option with Power Apps!
Ғылым және технология
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 KZread: 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
Пікірлер: 287
This is the single most impactful Power BI video I have seen… anywhere. Many KZreaders 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.
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
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 !
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!
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!
That was such a helpful and useful tutorial. Thank you for being very clear 😊
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!
Right in time for my Project. Thank you @How To Power BI!
Amazing!!! Thank you so much for the excellent demonstration!
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 😊
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 :)
Great Tutorial, answers a lot questions. Thanks
Bas my man, you saved me big time with this video !! Very good content !!!
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.
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....
nearly 40k views but only 28k subs, cmon guys , this is amazing content!! Show Bas and the team some love
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 :)
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
I deeply appreciate this video !!, thank you !!.
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.
I have watched many videos, good work here. Learning alot
Very nice demonstration .Thanks for sharing.💙
Thank you for sharing, inspiring seeing how you work, and passing knowledge…
@HowtoPowerBI
2 жыл бұрын
My pleasure! thanks a lot for your kind words!
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!
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
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!
Thanks so much for this Bas , This helps a lot !
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!!
Amazing tutorial, congratulations! Thank you very much for sharing this
@HowtoPowerBI
2 жыл бұрын
You're very welcome Matheus! happy you enjoyed it :)
I was searching ALLLLL day for this solution on KZread 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
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
Very useful. Thanks for sharing.👍
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!😊
LOVED THIS! You are god sent!
@HowtoPowerBI
Жыл бұрын
Thank you so much!!
Thanks a lot Bas. Really helpful
Fantastic, bro...thanks very much...
Very very very good! I will need to do something like this.
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 😎
amazing video! Thanks for all the details!!
@HowtoPowerBI
Жыл бұрын
Glad you like it :)
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!
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?
Bas you're a legend and have a great smile. Thanks for the vid
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!
Thanks for sharing, its really helpful !!
@HowtoPowerBI
2 жыл бұрын
You are welcome Sanket, glad it helped!
This is incredible 👏 thank you for this video.
@HowtoPowerBI
2 жыл бұрын
Amy, I am glad you liked it :) Power Apps are soooooo cool...
That's Great...Thanks for knowledge sharing...🙂
@HowtoPowerBI
2 жыл бұрын
thank you Vijay😀
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
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.
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 -> kzread.info/dash/bejne/Z4Oc0plygK_SfZs.html
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.
Very instructive video Thanks a lot
@HowtoPowerBI
5 ай бұрын
Glad you liked it
Thanks. Its helpful!!
@HowtoPowerBI
Жыл бұрын
Cool, happy i could help
Loved it
Best PowerBI Channel around
@HowtoPowerBI
Жыл бұрын
Thx!
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 :)
I think you are the best thanks you help me a lot
@HowtoPowerBI
5 ай бұрын
😁i wish ;) .. thx !
Great stuff! Thanks :-)
@HowtoPowerBI
2 жыл бұрын
hi Alex, very happy you like it! :)
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?
You are really awesome sir 🙂
That's amazing. Our new ERP system sucks so I'm writing all these reports outside of the ERP for people, and this might open up a whole new world for editing back the data! My boss jokes that we're going to re-write the ERP slowly over the next 10 years, but....I'm not sure he's actually joking, hehe. Thank you!! Also, you're very peaceful and calming to watch :).
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.
I always loved your videos :-)
@HowtoPowerBI
2 жыл бұрын
Thanks Philip :)
best power bi video ever!
@HowtoPowerBI
2 жыл бұрын
Oh wow thanks Ian!
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?
Very informative video. Do you have a video on how to delete an entry, not just edit it?
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 ❤❤
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?
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".
U r such a lovely amazing person ur videos are super amazing😮😮
@HowtoPowerBI
9 ай бұрын
Thank you so much 😀 and thanks for watching!!
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.
congratulations!, very useful my friend!👌🤝🤝
@HowtoPowerBI
Жыл бұрын
great to hear, thanks Luis!☺
Perfect solution
@HowtoPowerBI
2 жыл бұрын
Thanks!!!
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
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 🤓
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?
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?
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
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 ?
great video!
@HowtoPowerBI
2 жыл бұрын
thanks, glad you enjoyed it :)
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?
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?
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?
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
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
Amazing!
@HowtoPowerBI
2 жыл бұрын
Thank you! Cheers!
Amazing
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
Thanks!! Very insightful video!! Just a question, when you said that pro licenses has an 8 limit, is this per day? Month? Ever???
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!
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?
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…
This video is great, but have a quick question, should the datasource for powerBI and powerApps be the same? Please clarify
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
Great video as always, just a quick question, is it normal for there to be almost a 5 minute delay after submitting the form and the visual refreshing? I have to hit refresh on the browser quite a few times before I see the update on my table visual. I am using the power automate method for refreshing my dataset.
Thanks!
@HowtoPowerBI
2 жыл бұрын
thank you for supporting the channel!
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.
Thanks
@HowtoPowerBI
2 жыл бұрын
Thank you very much for supporting my channel :) much appreciated!
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.
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?
Hi - should this work after publishing the PowerBI report to the service? I've managed to use your tutorial to create a form on my PBI report, and all works fine on desktop, but when I publish the report, there seems to be data source credential issues. I checked my data source configurations in the desktop file, and the only connection is the one to the Excel file in my OneDrive - and I've set that to organizational permissions. Are there settings within the Power App that I need to configure as well? Thanks! Love your videos!