cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Sakura
Advocate III
Advocate III

Dataverse and PowerApps Licensing

An organization has standard 365 plans for their 160 users. They have access to Power Apps with their standard plan. One developer has an E3 plan.

Is it at all possible to build a Power App with a Dataverse connector that these standard plan users can access? I know this has been asked many times before and the answer seems negative, but recently I found this article on Dataverse and Power Apps licensing by Microsoft dated two weeks ago.

The article interestingly uses the past tense here when discussing the Dataverse connector for Power Apps.

 

 

It's use was considered PREMIUM in the same manner as connecting to a SQL Server connector due to the power afforded by the access.

 

 


The Microsoft author also concedes that indeed many people are using Excel and SharePoint as a backend for Power Apps (guilty as charged) to avoid high costs, but that

 

 

tended to drive data to SharePoint Lists or Excel Files which did not support data management best practices in the manner of a true database platform

 

 


This leads to loss of business because

 

 

In those cases, the choice to not use the Power Platform over another custom solution because of cost was quite common.

 

 

 
The article then continues with how Microsoft has chosen to address this:

 

 

Microsoft has recognized this blocker and has chosen to leverage Microsoft Teams as their own "starter" environments to promote usage and to consequently further adoption and perhaps innovation as the entry point for implementation now aligns with the same entry point for other Power Apps and Power Automate solutions even bringing in Power Virtual Agents which itself starts at a fairly steep monthly charge. This core concept becomes important because not only can guidance now point to more appropriate solutions but because adoption will certainly drive the need to handle cases where more capacity and scale will be required but this time in the same context as other storage and capacity decisions covered here.

 

 

 

I have trouble wrapping my head around this last paragraph. Can anyone confirm if my below understanding is correct?

  1. we still cannot use Dataverse in Power Apps because it is still a Premium connector. Users without access to premium features will not be able to access tables from Dataverse.
  2. however, users can access Dataverse tables if the Power App is opened through Teams (?)

It seems Microsoft is acknowledging that we have to resort to funky backend solutions in Excel, Sharepoint, Power Automate (and in my case even TypeScript) because there is a high (and expensive) wall around Dataverse. But it is not clear to me what the announced outcome in this last paragraph is. In my PowerApps, Dataverse is still flagged as a premium connector and users will get a pop up that they need to switch to a premium plan.

Feel free to point out anything I am misinterpreting here.
Also, if anyone has any pointers on how I can make an app with Dataverse for non-premium Power Apps users, it would be much appreciated. If the developer / app owner needs a Premium plan, that's of course ok. But 10 or 40 USD * 160 users per month will be an impossible sell.

1 ACCEPTED SOLUTION

Accepted Solutions
ChrisPiasecki
Most Valuable Professional
Most Valuable Professional

Hi @Sakura,

 

Unfortunately there is no way around the licensing. Dataverse for Teams allows you to get started with Dataverse without any additional cost and can fulfil many use cases. It can be upgraded later on to a full Dataverse if needed for those enterprise workloads or apps with greater complexity.

 

While the licensing might seem like a lot, you have to consider the costs of custom development and time to market. A single contracted developer will cost more than that in 2 weeks, and will likely take an order of magnitude longer to develop an app with similar characteristics.

 

With each app built for your per user licensed users you realize a greater return on investment so the economies of scale are further realized.

 

Hope this helps.

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
Chris

View solution in original post

6 REPLIES 6
ChrisPiasecki
Most Valuable Professional
Most Valuable Professional

Hi @Sakura,

 

Unfortunately there is no way around the licensing. Dataverse for Teams allows you to get started with Dataverse without any additional cost and can fulfil many use cases. It can be upgraded later on to a full Dataverse if needed for those enterprise workloads or apps with greater complexity.

 

While the licensing might seem like a lot, you have to consider the costs of custom development and time to market. A single contracted developer will cost more than that in 2 weeks, and will likely take an order of magnitude longer to develop an app with similar characteristics.

 

With each app built for your per user licensed users you realize a greater return on investment so the economies of scale are further realized.

 

Hope this helps.

 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
Chris
Fubar
Multi Super User
Multi Super User

The cost justification comes from the fact that Microsoft are managing the infrastructure at an Enterprise level i.e. your IT staff aren't purchasing and managing enterprise level hardware (expensive) and software, the web and application servers, load balancers, continuous backups, data center security denial of service attacks etc etc etc.  

Total/True cost of ownership of doing it yourself vs software as service probably sit on the SAAS side being more economic.

Sakura
Advocate III
Advocate III

Don't get me wrong, I do understand the pricing narrative of ROI. I just don't agree this ROI is there for all use cases. A majority of requirements I see merely require a user-friendly interface to update a database. This organization already has Python apps that use MySQL to do this. Even many simple VBA scripts handle certain processes just fine. None of that is nowhere near as expensive to make as a yearly cost of 76,800 USD + developer/consultant cost that Power Apps would require. SaaS also comes with unexpected price hikes that can make business-critical connectors suddenly a premium feature ... These are some of the counter-arguments we are dealing with.

@ChrisPiasecki  Thank you so much for that clarification. I looked deeper into it and it indeed seems there is a Dataverse 'Lite' hidden in Teams. I am grateful you pointed me towards this.

Just leaving this to future readers of this post. If you open Teams and add the Power Apps app, then don't add an app you already created in Power Apps, but create a new one through Teams itself. It will give the associated team and app access to 2 GB of combined Dataverse and file storage. It's a workable compromise by Microsoft that may help with a lot of low-key projects out there.

Microsoft documentation here
Tutorial video here

ChrisPiasecki
Most Valuable Professional
Most Valuable Professional

Hi @Sakura,

 

Agreed that it can be overkill for simplistic workloads. Using SharePoint lists or Dataverse for Teams as a data store is meant for exactly the simple use cases like you mentioned.

 

Feel free to mark the original response as a solution if it answered your question. 

---
Please click Accept as Solution if my post answered your question. This will help others find solutions to similar questions. If you like my post and/or find it helpful, please consider giving it a Thumbs Up.
Chris
BenGWeeks
Advocate II
Advocate II

Unfortunately, this is currently a showstopper for most clients. I do not understand why Dataverse suddenly incurs per-user licensing costs when compared to SharePoint when underlying infrastructure is presumably very similar.

Manuel_P
Frequent Visitor

Hi,

I want to add to this discussion as I am currently trying to use Environment Variables within PowerApps.

Environment Variables are a great way to use environment specific configuration. In power automate using environment variables is quite easy and a standard approach when using solutions. In PowerApps this does not seem to be standard if it comes to variables other than connections. 

I found a "workaround" to read the variables reading the environment variables in dataverse global table. This works well but my Standard app is promoted to Premium app just because of this feature.

@microsoft : Why do I need a premium license just to be able to use Environment variables in solutions?

Am I missing something and is there a different approach?

Helpful resources

Announcements

Celebrating the May Super User of the Month: Laurens Martens

  @LaurensM  is an exceptional contributor to the Power Platform Community. Super Users like Laurens inspire others through their example, encouragement, and active participation. We are excited to celebrated Laurens as our Super User of the Month for May 2024.   Consistent Engagement:  He consistently engages with the community by answering forum questions, sharing insights, and providing solutions. Laurens dedication helps other users find answers and overcome challenges.   Community Expertise: As a Super User, Laurens plays a crucial role in maintaining a knowledge sharing environment. Always ensuring a positive experience for everyone.   Leadership: He shares valuable insights on community growth, engagement, and future trends. Their contributions help shape the Power Platform Community.   Congratulations, Laurens Martens, for your outstanding work! Keep inspiring others and making a difference in the community!   Keep up the fantastic work!        

Check out the Copilot Studio Cookbook today!

We are excited to announce our new Copilot Cookbook Gallery in the Copilot Studio Community. We can't wait for you to share your expertise and your experience!    Join us for an amazing opportunity where you'll be one of the first to contribute to the Copilot Cookbook—your ultimate guide to mastering Microsoft Copilot. Whether you're seeking inspiration or grappling with a challenge while crafting apps, you probably already know that Copilot Cookbook is your reliable assistant, offering a wealth of tips and tricks at your fingertips--and we want you to add your expertise. What can you "cook" up?   Click this link to get started: https://aka.ms/CS_Copilot_Cookbook_Gallery   Don't miss out on this exclusive opportunity to be one of the first in the Community to share your app creation journey with Copilot. We'll be announcing a Cookbook Challenge very soon and want to make sure you one of the first "cooks" in the kitchen.   Don't miss your moment--start submitting in the Copilot Cookbook Gallery today!     Thank you,  Engagement Team

Announcing Power Apps Copilot Cookbook Gallery

We are excited to share that the all-new Copilot Cookbook Gallery for Power Apps is now available in the Power Apps Community, full of tips and tricks on how to best use Microsoft Copilot as you develop and create in Power Apps. The new Copilot Cookbook is your go-to resource when you need inspiration--or when you're stuck--and aren't sure how to best partner with Copilot while creating apps.   Whether you're looking for the best prompts or just want to know about responsible AI use, visit Copilot Cookbook for regular updates you can rely on--while also serving up some of your greatest tips and tricks for the Community. Check Out the new Copilot Cookbook for Power Apps today: Copilot Cookbook - Power Platform Community.  We can't wait to see what you "cook" up!      

Tuesday Tip | How to Report Spam in Our Community

It's time for another TUESDAY TIPS, your weekly connection with the most insightful tips and tricks that empower both newcomers and veterans in the Power Platform Community! Every Tuesday, we bring you a curated selection of the finest advice, distilled from the resources and tools in the Community. Whether you’re a seasoned member or just getting started, Tuesday Tips are the perfect compass guiding you across the dynamic landscape of the Power Platform Community.   As our community family expands each week, we revisit our essential tools, tips, and tricks to ensure you’re well-versed in the community’s pulse. Keep an eye on the News & Announcements for your weekly Tuesday Tips—you never know what you may learn!   Today's Tip: How to Report Spam in Our Community We strive to maintain a professional and helpful community, and part of that effort involves keeping our platform free of spam. If you encounter a post that you believe is spam, please follow these steps to report it: Locate the Post: Find the post in question within the community.Kebab Menu: Click on the "Kebab" menu | 3 Dots, on the top right of the post.Report Inappropriate Content: Select "Report Inappropriate Content" from the menu.Submit Report: Fill out any necessary details on the form and submit your report.   Our community team will review the report and take appropriate action to ensure our community remains a valuable resource for everyone.   Thank you for helping us keep the community clean and useful!

Community Roundup: A Look Back at Our Last 10 Tuesday Tips

As we continue to grow and learn together, it's important to reflect on the valuable insights we've shared. For today's #TuesdayTip, we're excited to take a moment to look back at the last 10 tips we've shared in case you missed any or want to revisit them. Thanks for your incredible support for this series--we're so glad it was able to help so many of you navigate your community experience!   Getting Started in the Community An overview of everything you need to know about navigating the community on one page!  Community Links: ○ Power Apps ○ Power Automate  ○ Power Pages  ○ Copilot Studio    Community Ranks and YOU Have you ever wondered how your fellow community members ascend the ranks within our community? We explain everything about ranks and how to achieve points so you can climb up in the rankings! Community Links: ○ Power Apps ○ Power Automate  ○ Power Pages  ○ Copilot Studio    Powering Up Your Community Profile Your Community User Profile is how the Community knows you--so it's essential that it works the way you need it to! From changing your username to updating contact information, this Knowledge Base Article is your best resource for powering up your profile. Community Links: ○ Power Apps ○ Power Automate  ○ Power Pages  ○ Copilot Studio    Community Blogs--A Great Place to Start There's so much you'll discover in the Community Blogs, and we hope you'll check them out today!  Community Links: ○ Power Apps ○ Power Automate  ○ Power Pages  ○ Copilot Studio    Unlocking Community Achievements and Earning Badges Across the Communities, you'll see badges on users profile that recognize and reward their engagement and contributions. Check out some details on Community badges--and find out more in the detailed link at the end of the article! Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio    Blogging in the Community Interested in blogging? Everything you need to know on writing blogs in our four communities! Get started blogging across the Power Platform communities today! Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio   Subscriptions & Notifications We don't want you to miss a thing in the community! Read all about how to subscribe to sections of our forums and how to setup your notifications! Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio   Getting Started with Private Messages & Macros Do you want to enhance your communication in the Community and streamline your interactions? One of the best ways to do this is to ensure you are using Private Messaging--and the ever-handy macros that are available to you as a Community member! Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio   Community User Groups Learn everything about being part of, starting, or leading a User Group in the Power Platform Community. Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio   Update Your Community Profile Today! Keep your community profile up to date which is essential for staying connected and engaged with the community. Community Links: ○ Power Apps  ○ Power Automate  ○ Power Pages  ○ Copilot Studio   Thank you for being an integral part of our journey.   Here's to many more Tuesday Tips as we pave the way for a brighter, more connected future! As always, watch the News & Announcements for the next set of tips, coming soon!

Hear what's next for the Power Up Program

Hear from Principal Program Manager, Dimpi Gandhi, to discover the latest enhancements to the Microsoft #PowerUpProgram, including a new accelerated video-based curriculum crafted with the expertise of Microsoft MVPs, Rory Neary and Charlie Phipps-Bennett. If you’d like to hear what’s coming next, click the link below to sign up today! https://aka.ms/PowerUp  

Users online (4,647)