Complete Project with Power BI, Power Apps, Power Automate and Dataverse

Join my Power BI Design training here: my.datatraining.io/pages/powe...
Learn how to work with Power BI, Power Apps, Power Automate and Dataverse. Enjoy 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 [e-mail]
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00:00 Intro
00:00:51 Dataverse
00:17:46 Power Apps
00:41:59 Power BI
01:06:30 Power Automate
01:11:23 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 KZbin: 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

[@RobertoMassucco1978]

The main problem with PowerApps is the licence cost in my opinion. Every user that needs to run a process nees also a licence that is quite expensive especially for casual users

[@Sam-ns9jy]

Host dataverse and the app inside a dataverse for teams environment. That way, Dataverse can be used within powerapps without a premium license, and you can use it as a dataset for powerbi also.

[@mmdrahaman]

​@@Sam-ns9jy do you ha e any documentation on how to achieve this?

[@Sam-ns9jy]

@@mmdrahaman I would just Google "Dataverse for Teams" and follow the Microsoft documentation

[@kkskhin7208]

Thank you so much, Bas. We all owe you much.

[@joshh.3870]

I’m literally finishing up a project using exactly all of this tonight - feel like I just had a message from the universe to push through. I’ll have this on a loop - thanks for copiloting with me bro 👍

[@faulypi]

Excellent tutorial. I actually just started my PowerApps journey last week. this is perfect timing.

[@officesuperhero9611]

Wow. What a great tutorial, Bas. This tutorial was really needed. I don't think there is a tutorial like this on YT. Excellent! Thank you!

[@aftabsuco5233]

Started the video to just overview but it's so satisfying I couldn't skip a single part watched complete video awesome work ❤❤❤❤

[@Brothercole1994]

Love the power platform content!

[@tarekhusam]

you are amazing bro, thank you again and again. make a website and give us tasks etc..

[@khaledahmed955]

Absolutely top notch! Keep up the great work Bas!

[@megabuilds3007]

Excellent tutorial. I actually just started my PowerApps journey. Thanks for mthis full mpacke data flow job. Hoping more videos in this fashion.

[@bartheuts4407]

Have to say, really happy I found this channel. You've taught me a lot already on the Power Platform and how I can use it to add value fast and make it look good in the meantime. Much appreciated!

[@HowtoPowerBI]

Thats awesome

[@kukeleku13]

Amazing as always. I'd love to get into Power Apps more, but I've heard a lot of companies don't because of the license costs. Bummer!

[@padmasubbiah6259]

Very helpful video!! Thanks so much for all the quality content!! Direct Query mode didnt work on my Trial license but managed to do with Import Mode. Some features didnt work but still very helpful. Thanks again 👍

[@marcoramirez2639]

you are a PROOOO!!!! thanks for sharing your knowledge!

[@rickychen1086]

Great work! a simple demo to show how power platform integrate together

[@lijunchen]

This is a great tutorial. I learned a lot about the Power Apps capabilities. Thanks.

[@francisopiyo2332]

Thanks alot for this. it is in deed an all in one package.

[@excel-solutions4564]

Amazing content. Enjoyed every bit of it!

[@bi-ome]

This is brilliant actually - I can see where this would get around all of the weak points of the Power Automate visual like the lack of confirmation message by having the button be in a canvas app instead.

[@FedexBaires]

Brillante Bas, muchas gracias!!!

[@raviranjan5879]

This project is just awesome, you touched upon so many things here. It's worth every second watching and learning from this. Thank you Bas.

[@chrism9037]

Great job Bas!

[@HikimaruL2]

Excellent video, I hope you do more videos like this !

[@nishantdhir570]

Thank you so much! Much needed project. Would be useful in my job search!

[@HowtoPowerBI]

Awesome good luck

[@boonyarithdumrongpalasith5501]

Thank for VDO. It’s very useful.

[@HowtoPowerBI]

😊thanks!

[@luisalbertohernandezbenite6732]

Your videos are always useful keep up with the content you are awesome

[@jakubstesik472]

Wow! This exactly what I am working on right now! Thanks for the video!

[@HowtoPowerBI]

Awesome! Hope it helps

[@ManuDonald]

Thanks!

[@MiguelMadrizGr8]

Wow I can see the reference to the post I made last week in LinkedIn (3rd page) with that Power BI muscled, cool

[@fitzchivalric8419]

Great function, well explained! THX!

[@HowtoPowerBI]

thanks!!!

[@twickAttack]

That's very cool, I'd be doing it along with you in the next week or so. Complete projects are quite useful, thank you heaps, dude!

[@HowtoPowerBI]

Awesome good luck!

[@BaldBookTuber]

Some great stuff here. With the ranking, I would have used the RANK window function, which allows you rank based on multiple conditions, and gone with first Total Sales then # of Sales.

[@yakkaluruvijaysankar787]

Very useful information. Thank you for sharing this information and please do more videos like this

[@edwinarchico439]

Perfect! Please make more of this

[@HowtoPowerBI]

😅 this one was a loooot of work, but will try

[@GuyOrlov]

wow Danke Bass!

[@dreamyuyi]

Amazing video! Thanks, mate!

[@HowtoPowerBI]

Glad you liked it!

[@mohamedezzat5507]

Amaaaazing Explanation 👌

[@cristianprifti]

Nice video! Would be nice if we would also get the documented functionality of choosing the desired environment in the Power Platform without hacking the browser console.

[@themolestones]

amazing video

[@parveenbhardwaj4533]

That's a great project with very useful details. Thank you very much

[@HowtoPowerBI]

Glad it was helpful! 😊

[@directtorohitkhanna]

waiting for another session and power app design😀

[@sourabhpatel3834]

Wow❤ thank u😊

[@HowtoPowerBI]

Always welcome

[@KCExplains]

Wow! This is precisely what I'm working on. right now! Thank you for the video! But I can't find the project file.

[@mtavassoti]

Great video, thanks a lot

[@HowtoPowerBI]

Thanks for watching

[@vishalnasre1251]

Holy moly, this is out of the box and I am on time as wanted to build something like this only. I have few questions: 12.31 - Can we insert excel file data here instead of manually typing all - only for historical data. 15:05 - Even when we selected required column in power apps, why all other column are showing in power BI ? One general question, Instead of just one values, can we add a table with one row and then submit button, which will update the row in my table.

[@Nalaka-Wanniarachchi]

Whoh.The epic ⚜

[@RobHawlor]

Loving the course, right up until having to download the material. I added my email address which took me to a list of resources, I assumed it was the one called "Complete Project with Power BI, Power Apps, Power Automate and Dataverse" - When i expand, the only option to download is the PBX, no csv or other files. When i do download the PBX i get dynamics CDS which keeps saying "Couldnt Authenticate". Tried a few times with my normal sign on. How do i get the employee data to copy over and resolve the dynamics issue? Thanks

[@bhargavpurohit6848]

Yeah , Awesome buddy. Learned Lot.....😀

[@HowtoPowerBI]

🙌

[@saikishore5631]

Awesome Bas, If Employee want to modify the transaction how?

[@user-zb5li3nc9o]

On 40:12 , Why did you put the refresh function before the Patch Function? isn't it means that the Visual is being refreshed and only after the new record is added?

[@thghtfl]

Did I hear correctly that it is impossible to create such an app following conventional ci/cd flow? You can do this only from within PBI Service after the workbook has been published?

[@gauravguliani358]

I am seeing 200k subscribers. Vow Bas!

[@patrimoinealgerienetberber282]

Hello Bas, I can't find the file project :(

[@AgostinoMangiacapra]

How does it work with access rights? I guess all Power BI users need to have access to the Power App. What about dataverse? Do all of them need system customiser role for seeing the table and adding rows?

[@hananehanane4881]

How can I refresh data source in power bi if the database updated .. I mean make it synchronize with sql server data base ?

[@bretaddison4146]

How did we get the data originally into Dataverse ?

[@KyleCroucher]

Bas! Amazing video, this is just what I’m looking for! I’m trying to freelance and this came in handy, however I did have a question. As an individual, how would I be able to get my own access to the Power Apps since you can’t use a personal email? Any ideas?

[@ThatDudeRyan]

You would have to build any Power Platform solutions with the customer license in their environment.

[@KyleCroucher]

@@ThatDudeRyan Okay, that’s what I thought. Thanks! Was curious how Bas can do it… I assume he set up his own work email and pays for it.

[@muhammadazam8422]

Dear, Fine work. How to link/add my power bi dashboard with my linkedin profile.

[@shubhamsonker3418]

I love the way how you make content but i have a one problem i am not able to create tables under solution i think i have a problem in environment creation. Can you help me out in this?

[@mrbartuss1]

The file is not available

40:19 Not sure how that refresh of PBI integration data works before the Patch(), my understanding of that PowerFx would be other way around. Like 1. Patch(); 2. Refresh(); 3. Notify();

[@HowtoPowerBI]

Both works i believe

[@captainchannel8210]

Does it need any pro or premium subscription to access all the services

[@vaishnavipupneja6287]

Hi I am trying to save the power bi export as pdf to a share point folder. The fliw that I am currently creating is when a button is clicked on power bi dashboard it will export the report as pdf and send a email to listed recipients. Once that is done, i want to save this pdf export file on a share point folder which is giving me some error. Could you please help me with a possible solution to this .

[@Whosisaya]

I have my source in csv files, is there a way that i can link them with sql server and then to pbi ? (everyday ihave new csv files comes in with new data i need to figure out how my dashboard can be updated automatically) anyone can help?

[@viclabuschagne458]

Bas do you or can you do a video on azure security score to Bi

[@madhanrajmoorthy8843]

Hi, Great, Thank you. I am using Dataverse has Data source. I want to have Direct Query Mode for almost real time reporting. However, power BI is not allowing me to unpivot the data in Power Query Editor. If I unpivot, it immediately notifies to move to Import Mode. But I want it in DirQuery mode with transformations like unpivoting.. Do you have any ideas to solve this issue? Thank you.

[@HowtoPowerBI]

not possible, you would need to get the data in an unpivoted format in the dataverse

[@madhanrajmoorthy8843]

Thank you so much 😊. Currently, I found a way DV Table -> SSMS(Unpivot in SQL) -> Added SQL in Power BI as a Query with SQL while loading. Then I got the unpivoted data, then I was able to do transformations as DirectQueryMode itself.

[@janslanina2209]

Hello sir, if it would be possible, can you please tell me, if it is possible to datastream in real life from Swagger API to power BI ? I tried and I am starting to give up. :( Is it even possible to get data in real life to power BI report ? thank you in advance.

[@OlsoNounas]

Are the number of refreshes limited to 8 for pro users and 48 for premium license users?

[@narendersingh2669]

Yes in one day 8 refresh for pro and 48 for premium

[@HowtoPowerBI]

Indeed, that’s why for this project you r probably better of using direct query

[@OlsoNounas]

Ah, yes, in the service the results will show almost instantly.

[@agnosticpatriot]

Thanks for the video, but there is problem, i can't see what you are doing in the power bi screen, your cam fills the space. Yes we respect you and your efforts to teach us newbies. If possible, can you zoom in to the fields? Im going to get torn apart with comments by fanboys, innit? 😊😊😅😅

[@faith_oseghale]

Please how do I get the SalesEmployeeImage links?

[@HowtoPowerBI]

they r in the pbix file ( see download link in the description ) .. probably better idea to find your own though

[@candidjasmine7960]

Couldnt load tables with PBI prefix in the dataverse...

[@HowtoPowerBI]

What error did you get

[@candidjasmine7960]

@@HowtoPowerBI Nothing its just not showing up in search.. I see why My office 365 is my own person account... while for accessing the Power BI free trial, it only works with works with WORK/SCHOOL account, so I used my cousin's school email... probably its not make connection because the sign in info for BI and powerapps is different ? I am not working right now... so that was the only option I got to complete this project... Fantastic work on your part..!!

[@ricardogarcia5427]

can i take your courses if i own a mac or do i need a PC

[@HowtoPowerBI]

You would need a workaround (i.e. parallels) but maybe getting access to pc is easier?

[@devendrabarasker4987]

I am unable to download the files is that paid? I mean if i purchase your course than i will be able to download the dataset....???

[@HowtoPowerBI]

No it is free, just follow the link in the description, put in your email and there you have all the videos with files

[@devendrabarasker4987]

@@HowtoPowerBI Thank you Bas for this kind of amazing content and also for quick response. Got your point🙌

[@user-ck4pb8eq4h]

@HowtoPowerBI i cant see the exact file name to download after sign in with email in web portal

[@HowtoPowerBI]

should be there now :)