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-ns9jy5 ай бұрын
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.
@mmdrahaman5 ай бұрын
@@Sam-ns9jy do you ha e any documentation on how to achieve this?
@Sam-ns9jy5 ай бұрын
@@mmdrahaman I would just Google "Dataverse for Teams" and follow the Microsoft documentation
@timestoryx2 ай бұрын
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 👍
@joshh.38705 ай бұрын
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 👍
@bi-ome4 ай бұрын
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.
@kkskhin72085 ай бұрын
Thank you so much, Bas. We all owe you much.
@aftabsuco52335 ай бұрын
Started the video to just overview but it's so satisfying I couldn't skip a single part watched complete video awesome work ❤❤❤❤
@tarekhusam5 ай бұрын
you are amazing bro, thank you again and again. make a website and give us tasks etc..
@raviranjan58793 ай бұрын
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.
@faulypi5 ай бұрын
Excellent tutorial. I actually just started my PowerApps journey last week. this is perfect timing.
@rickychen10864 ай бұрын
Great work! a simple demo to show how power platform integrate together
@vishalnasre12512 ай бұрын
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.
@officesuperhero96115 ай бұрын
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!
@megabuilds30075 ай бұрын
Excellent tutorial. I actually just started my PowerApps journey. Thanks for mthis full mpacke data flow job. Hoping more videos in this fashion.
@marcoramirez26394 ай бұрын
you are a PROOOO!!!! thanks for sharing your knowledge!
@khaledahmed9554 ай бұрын
Absolutely top notch! Keep up the great work Bas!
@jakubstesik4725 ай бұрын
Wow! This exactly what I am working on right now! Thanks for the video!
@HowtoPowerBI5 ай бұрын
Awesome! Hope it helps
@bretaddison41464 ай бұрын
How did we get the data originally into Dataverse ?
@BaldBookTuber5 ай бұрын
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.
@patrimoinealgerienetberber2825 ай бұрын
Hello Bas, I can't find the file project :(
@HikimaruL24 ай бұрын
Excellent video, I hope you do more videos like this !
@fitzchivalric84193 ай бұрын
Great function, well explained! THX!
@HowtoPowerBI3 ай бұрын
thanks!!!
@RobHawlor4 ай бұрын
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
@boonyarithdumrongpalasith55015 ай бұрын
Thank for VDO. It’s very useful.
@HowtoPowerBI5 ай бұрын
😊thanks!
@twickAttack5 ай бұрын
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!
@HowtoPowerBI5 ай бұрын
Awesome good luck!
@luisalbertohernandezbenite67325 ай бұрын
Your videos are always useful keep up with the content you are awesome
@padmasubbiah62595 ай бұрын
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 👍
@yakkaluruvijaysankar7875 ай бұрын
Very useful information. Thank you for sharing this information and please do more videos like this
@dreamyuyi5 ай бұрын
Amazing video! Thanks, mate!
@HowtoPowerBI5 ай бұрын
Glad you liked it!
@excel-solutions45645 ай бұрын
Amazing content. Enjoyed every bit of it!
@directtorohitkhanna5 ай бұрын
waiting for another session and power app design😀
@Brothercole19945 ай бұрын
Love the power platform content!
@KalamCrypto2 ай бұрын
Amazing stuff
@agnosticpatriot3 ай бұрын
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? 😊😊😅😅
@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
@MiguelMadrizGr85 ай бұрын
Wow I can see the reference to the post I made last week in LinkedIn (3rd page) with that Power BI muscled, cool
@ItsreallyeasytospellАй бұрын
Is Bas short for BadAss? Love your work, thanks heaps for this!
@sourabhpatel38345 ай бұрын
Wow❤ thank u😊
@HowtoPowerBI5 ай бұрын
Always welcome
@KyleCroucher5 ай бұрын
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?
@ThatDudeRyan5 ай бұрын
You would have to build any Power Platform solutions with the customer license in their environment.
@KyleCroucher5 ай бұрын
@@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.
@saikishore56314 ай бұрын
Awesome Bas, If Employee want to modify the transaction how?
@muhammadazam84223 ай бұрын
Dear, Fine work. How to link/add my power bi dashboard with my linkedin profile.
@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
5 ай бұрын
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();
@HowtoPowerBI5 ай бұрын
Both works i believe
@shubhamsonker34184 ай бұрын
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?
@AgostinoMangiacapra4 ай бұрын
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?
@YardenGilboa-q5u5 ай бұрын
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?
@ManuDonald3 ай бұрын
Thanks!
@gauravguliani3585 ай бұрын
I am seeing 200k subscribers. Vow Bas!
@mtavassoti5 ай бұрын
Great video, thanks a lot
@HowtoPowerBI5 ай бұрын
Thanks for watching
@viclabuschagne4584 ай бұрын
Bas do you or can you do a video on azure security score to Bi
@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.
@hananehanane48815 ай бұрын
How can I refresh data source in power bi if the database updated .. I mean make it synchronize with sql server data base ?
@madhanrajmoorthy88433 ай бұрын
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.
@HowtoPowerBI3 ай бұрын
not possible, you would need to get the data in an unpivoted format in the dataverse
@madhanrajmoorthy88433 ай бұрын
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.
@rajishnАй бұрын
not able to find table option under new @ 4:09 time
@ricardogarcia54274 ай бұрын
can i take your courses if i own a mac or do i need a PC
@HowtoPowerBI4 ай бұрын
You would need a workaround (i.e. parallels) but maybe getting access to pc is easier?
@GuyOrlov5 ай бұрын
wow Danke Bass!
@vaishnavipupneja62875 ай бұрын
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 .
@faith_oseghale4 ай бұрын
Please how do I get the SalesEmployeeImage links?
@HowtoPowerBI4 ай бұрын
they r in the pbix file ( see download link in the description ) .. probably better idea to find your own though
@Nalaka-Wanniarachchi5 ай бұрын
Whoh.The epic ⚜
@Whosisaya5 ай бұрын
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?
@candidjasmine79605 ай бұрын
Couldnt load tables with PBI prefix in the dataverse...
@HowtoPowerBI5 ай бұрын
What error did you get
@candidjasmine79605 ай бұрын
@@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..!!
@OlsoNounas5 ай бұрын
Are the number of refreshes limited to 8 for pro users and 48 for premium license users?
@narendersingh26695 ай бұрын
Yes in one day 8 refresh for pro and 48 for premium
@HowtoPowerBI5 ай бұрын
Indeed, that’s why for this project you r probably better of using direct query
@OlsoNounas5 ай бұрын
Ah, yes, in the service the results will show almost instantly.
@devendrabarasker49875 ай бұрын
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....???
@HowtoPowerBI5 ай бұрын
No it is free, just follow the link in the description, put in your email and there you have all the videos with files
@devendrabarasker49875 ай бұрын
@@HowtoPowerBI Thank you Bas for this kind of amazing content and also for quick response. Got your point🙌
@vishnukumarsankaran5 ай бұрын
@HowtoPowerBI i cant see the exact file name to download after sign in with email in web portal
@HowtoPowerBI5 ай бұрын
should be there now :)
@kukeleku135 ай бұрын
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!
@bartheuts44075 ай бұрын
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!
@HowtoPowerBI5 ай бұрын
Thats awesome
@muhammadazam842219 күн бұрын
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."
@mrbartuss15 ай бұрын
The file is not available
@thghtfl5 ай бұрын
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?
@janslanina22095 ай бұрын
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.
@KCExplains5 ай бұрын
Wow! This is precisely what I'm working on. right now! Thank you for the video! But I can't find the project file.
@lijunchen3 ай бұрын
This is a great tutorial. I learned a lot about the Power Apps capabilities. Thanks.
@captainchannel82105 ай бұрын
Does it need any pro or premium subscription to access all the services
@cristianprifti5 ай бұрын
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.
@parveenbhardwaj45335 ай бұрын
That's a great project with very useful details. Thank you very much
@HowtoPowerBI5 ай бұрын
Glad it was helpful! 😊
@francisopiyo23325 ай бұрын
Thanks alot for this. it is in deed an all in one package.
@mohamedezzat55074 ай бұрын
Amaaaazing Explanation 👌
@edwinarchico4395 ай бұрын
Perfect! Please make more of this
@HowtoPowerBI5 ай бұрын
😅 this one was a loooot of work, but will try
@FedexBaires5 ай бұрын
Brillante Bas, muchas gracias!!!
@nishantdhir5705 ай бұрын
Thank you so much! Much needed project. Would be useful in my job search!