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

[@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 👍

[@d5g7h8i9]

Best Video I have come across in 2024...Thank you

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

[@timestoryx]

Chatgpt give me this😅, chech it out 😂 To address the issue of high licensing costs for PowerApps, you can follow the suggestion to use Dataverse within a Microsoft Teams environment. This approach leverages the free Dataverse for Teams license, which allows users to create and use PowerApps without requiring a premium license. Here is a step-by-step guide on how to achieve this: ### Step-by-Step Guide to Host Dataverse and PowerApps in Teams 1. **Set Up Microsoft Teams Environment:** - Ensure you have Microsoft Teams installed and set up. - If you don't have an existing team, create a new team within Microsoft Teams where you will host your Dataverse. 2. **Create a Dataverse Environment:** - Open Microsoft Teams. - Navigate to the team where you want to create the Dataverse environment. - Click on the "Apps" icon on the left sidebar. - Search for "Power Apps" and select it. - Click on "Add to a team." - Select the team you want to add the Power Apps app to and click "Set up." 3. **Create a New Power App in Teams:** - After setting up Power Apps in your team, open the Power Apps app within Teams. - Click on "Create an app." - Follow the prompts to create a new app. This will automatically use the Dataverse for Teams environment. 4. **Use Dataverse for Data Storage:** - While creating your app, select Dataverse as the data source. - You can create new tables or use existing tables within Dataverse. - This allows you to store and manage your data without requiring a premium Dataverse license. 5. **Building and Sharing the App:** - Design and build your app using the Power Apps Studio within Teams. - Once your app is built, you can share it with your team members. - Team members can use the app without needing additional Power Apps licenses, as long as they have access to the Teams environment. 6. **Using Dataverse Data in Power BI:** - If you want to use the Dataverse data in Power BI, you can connect Power BI to the Dataverse for Teams environment. - Open Power BI Desktop. - Click on "Get Data" and select "Common Data Service (Dataverse)." - Connect to your Dataverse environment and select the tables you want to use. - Build your reports and dashboards in Power BI using the data from Dataverse. ### Additional Resources and Documentation: - [Microsoft Power Apps documentation](docs.microsoft.com/en-us/powerapps/) - [Microsoft Dataverse for Teams overview](docs.microsoft.com/en-us/powerapps/teams/overview) - [Getting started with Dataverse for Teams](docs.microsoft.com/en-us/powerapps/teams/get-started-teams) Following these steps will help you utilize PowerApps and Dataverse without incurring high licensing costs, making it more feasible for casual users.

[@Itsreallyeasytospell]

@@Sam-ns9jy Functionality and controls seem to be very limited in teams environments (maybe this has been restricted). Also no way of linking Power BI that i can find. Good call on highlighting a way to create dataverse tables at no cost though 👍

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

[@kkskhin7208]

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

[@aftabsuco5233]

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

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

[@faulypi]

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

[@ManuDonald]

Thanks!

[@naynayreverbed9034]

Followed all the way through. Very very helpful; there are not many videos out there that implement all these tools together like you did. Great job!!

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

[@tarekhusam]

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

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

[@megabuilds3007]

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

[@ResponsibleTrader-gi4ou]

Hi Bas , Im from India first time am watchin your video's its really good information your sharing and we are learning so much 💥💥💥💥👏👏👏👏👏👏

[@HowtoPowerBI]

🚀💪thanks!!

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

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

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

[@YardenGilboa-q5u]

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?

[@rickychen1086]

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

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

[@edwinarchico439]

Perfect! Please make more of this

[@HowtoPowerBI]

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

[@lijunchen]

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

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

[@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 👍

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

[@jakubstesik472]

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

[@HowtoPowerBI]

Awesome! Hope it helps

[@khaledahmed955]

Absolutely top notch! Keep up the great work Bas!

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

[@Itsreallyeasytospell]

Is Bas short for BadAss? Love your work, thanks heaps for this!

[@bretaddison4146]

How did we get the data originally into Dataverse ?

[@luisalbertohernandezbenite6732]

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

[@patrimoinealgerienetberber282]

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

[@JijaTaheri]

Great! Thanks for such valuable video!

[@nishantdhir570]

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

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

[@marcoramirez2639]

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

[@HikimaruL2]

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

[@boonyarithdumrongpalasith5501]

Thank for VDO. It’s very useful.

[@HowtoPowerBI]

😊thanks!

[@directtorohitkhanna]

waiting for another session and power app design😀

[@muhammadazam8422]

Hi, Fine work . Excellent tutorial. A project on "Add a Power BI report or dashboard to a web page. Embed a report in a secure portal or website."

[@excel-solutions4564]

Amazing content. Enjoyed every bit of it!

[@sourabhpatel3834]

Wow❤ thank u😊

[@HowtoPowerBI]

Always welcome

[@parveenbhardwaj4533]

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

[@HowtoPowerBI]

Glad it was helpful! 😊

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

[@paulkroon]

Hi Bas, good tutorial. One additional question, how can we deploy the Power BI Report to a production workspace and with the deployment connect to an App in Test/Production? Would it be possible for you to make a video about deployment? Hope you can help. Paul

[@MiguelMadrizGr8]

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

[@yemiakinwande7039]

Thanks Bas, this is super helpful

[@HowtoPowerBI]

Glad to hear that!!!

[@bhargavpurohit6848]

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

[@HowtoPowerBI]

🙌

[@Brothercole1994]

Love the power platform content!

[@saikishore5631]

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

[@fitzchivalric8419]

Great function, well explained! THX!

[@HowtoPowerBI]

thanks!!!

[@yakkaluruvijaysankar787]

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

[@GopeshDwivedi]

which screen recording and video editor are you using @How to Power BI?

[@HowtoPowerBI]

Camtasia, premier pro, after effects, audition

[@chrism9037]

Great job Bas!

[@mrbartuss1]

The file is not available

[@dreamyuyi]

Amazing video! Thanks, mate!

[@HowtoPowerBI]

Glad you liked it!

[@rajishn]

not able to find table option under new @ 4:09 time

[@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?

[@francisopiyo2332]

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

[@iezzat189]

Amaaaazing Explanation 👌

[@KalamCrypto]

Amazing stuff

[@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?

[@FedexBaires]

Brillante Bas, muchas gracias!!!

[@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?

[@captainchannel8210]

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

[@bejukacarlson6454]

Hi, while following up with your video, i encountered issues creating a new table. Whenever i select the table icon, nothing shows up. what could be the problem?

[@muhammadazam8422]

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

[@maisieren2027]

Hi Bas, why the visual of mine doesn't look like yours when I published it onto the PBI service? The Power App visual doesn't look like the one in PB desk version.

[@maisieren2027]

The difference is from the environment, and I fixed it already.

[@mtavassoti]

Great video, thanks a lot

[@HowtoPowerBI]

Thanks for watching

[@louizaamalou440]

You are the best 😮 How can I get my original data ( a have a big fact table in excel ) to Datareverse It's impossible for me to create from scratch Copie/past ?? Thanks a lot

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

[@hananehanane4881]

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

[@themolestones]

amazing video

[@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?

[@GuyOrlov]

wow Danke Bass!

[@gauravguliani358]

I am seeing 200k subscribers. Vow Bas!

[@viclabuschagne458]

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

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

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

[@brock7672]

Are you kiddin ! where is the data file to download ?

[@HowtoPowerBI]

It is a few cells with dummy values i entered while recording…

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

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

[@Whosishee]

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?

[@Nalaka-Wanniarachchi]

Whoh.The epic ⚜

[@shallybhateja8761]

Can you create a power automate flow for secret Santa game.

[@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? 😊😊😅😅

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

[@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🙌

[@vishnukumarsankaran]

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

[@HowtoPowerBI]

should be there now :)