Dataverse "Virtual Tables" are underrated.

Why replicate data from SQL into Dataverse if you don't have to? Virtual tables let you CRUD data sitting in SQL without moving it. Less storage cost, real-time access. Work smarter.

#Dataverse #Architecture #PowerPlatform

My dedicated website for all things Microsoft licensing (Power Platform, Dynamics 365, Copilot) has now been launched. Introducing: The Licensing Guide.

https://jukkaniiranen.com/2025/12/spirit-of-the-licensing-guide/

Flexible Dataverse capacity for apps and agents - Microsoft Power Platform introduces flexible Dataverse capacity for apps & agents, empowering businesses with scalable data solutions. #Microsoft #PowerPlatform #Dataverse #AI #Cloud #Innovation
https://www.microsoft.com/en-us/power-platform/blog/2025/12/04/dataverse-capacity/

You can now check how much #Dataverse storage capacity different Power Platform and Dynamics 365 licenses give you, using this Dataverse Capacity Calculator I created:

https://www.youtube.com/watch?v=zMbbKDQRqd8

Direct link: https://dataverse.licensing.guide/

#PowerApps #PowerAutomate #PowerPages #CopilotStudio #Dynamics365

Fix OData filter errors in Power Automate! Apostrophes in SharePoint and Dataverse queries (e.g. O'Reilly) can break your flow. Learn how to fix this and keep your flows running. #PowerAutomate #PowerPlatform #OData #TechTips #Automation #SharePoint #Dataverse

http://elliskarim.com/2025/12/06/power-automate-fixing-odata-filter-errors-when-strings-contain-apostrophes/?utm_source=mastodon&utm_medium=jetpack_social

Here's how the Dataverse database capacity increases, based on whether you have Power Platform, Dynamics 365 CRM or Dynamics 365 ERP licenses as the "top" SKU.

As a reminder, #Dataverse add-on capacity is expensive AF. $40/GB, per month. So, #Dynamics365 CRM customers now get $9,600/y worth of new GBs. With #PowerApps or #PowerAutomate premium, you get half of that. With ERP - well, you're already paying a fortune for D365 FinOps anyway.😜

For once, Microsoft is giving you more capacity without a price increase!🥳 The December 2025 update for #Dataverse default storage capacity raised my quota from #Dynamics365 licenses by 20 GB.

Read all about it in The Licensing Guide blog:
https://licensing.guide/december-2025-dataverse-default-capacity-changes-illustrated/

🔑 Tired of dealing with GUIDs in Dataverse?

Use Alternate Keys to:
✔️ Upsert records via business IDs
✔️ Reference related records in APIs
✔️ Sync with external systems
✔️ Maintain clean referential integrity

New blog ⬇️
#Dataverse #PowerApps #Integration

http://mytrial365.com/2025/12/04/mastering-alternate-keys-in-dataverse-the-key-to-seamless-integration-upserts-and-sync/

My #PowerPlatform bookmarklet now copies not just the Dataverse table columns and types into your clipboard, but also the choice column (picklist) values. These are traditionally tedious to get from the #PowerApps maker portal. Now, you get them from #Dataverse with one click on a bookmark:

https://youtu.be/K_k0p8gnQIg

🟦 Top 3 XrmToolBox plugins for Solution Architects
Boost Dataverse productivity with three XrmToolBox plugins I use daily. 🚀

💡 SQL 4 CDS — run SQL queries, perform bulk ops, and convert results to FetchXML.
🔍 FetchXML Builder — craft advanced views and generate
⚖️ Data Transporter — migrate tables, playlists, and preserve lookup integrity.

Ready to streamline your builds? What’s your go-to XrmToolBox plugin?

▶︎https://www.hubsite365.com/en-ww/pro-office-365/?id=4fcf2a3f-06bb-f011-bbd3-7ced8d108acb&topic=c096725c-bb75-ea11-a811-000d3a210788&theater=true

#Dataverse #XrmToolBox #PowerPlatform #SolutionArchitecture

🧼 A bloated schema = a slow app.

In Part 6 of our Power Platform Performance series, learn how to use Object Checker to clean up your Dataverse tables, columns, and forms before they cause trouble.

#Dataverse #PowerApps #LowCode #Performance

http://mytrial365.com/2025/11/06/power-platform-performance-cleaning-schema-with-object-checker/

🟦 Copilot Studio — SUPER ACCURATE Dataverse Results
Inconsistent Dataverse answers? Apply four practical techniques to make Copilot Studio reliably accurate 🚀

💡 Glossaries, targeted column selection and synonym lists reduce
🔍 Enable multiline text/file-column indexing and tune Azure AI Search
⚖️ Use MCP/Azure Functions for extensibility, honor MIP labels and track ROI

Want a quick checklist or examples for your environment? Based on a recent Copilot Studio demo.

▶︎https://www.hubsite365.com/en-ww/citizen-developer/?id=b8713e8f-04ba-f011-bbd3-7ced8d108acb&topic=9f678e9a-8cd4-ec11-a7b5-6045bd92fe52&theater=true

#CopilotStudio #Dataverse #AzureAI #Makers

Do you ever find yourself explaining to AI chatbots what your #Dataverse tables look like? Such as when trying to get them to spit out the right expressions for #PowerAutomate cloud flows?

Stop checking what your schema is, just copy-paste the details from the Web API with this bookmarklet: https://link.jukkan.com/bookmark

#PowerPlatform #bookmarklet

#Dataverse und #Dynamics aus der #MS365 Welt sind zwar kostenpflichtig aber dafür ordentliche Kraftpakete in der Powerapps Umgebung.
Nur man muss sich als Unternehmer/Abteilungsleiter auch damit beschäftigen was es leisten kann. Abteilungen die nur noch Excelmakros setzen, verlieren schnell den Anschluss.
Die Anbindung an Copilot wird jeden Monat besser.
#Microsoft #linux

🟪 Improving the Timer in Power Apps | Low to Pro
Make model-driven apps behave like a real, millisecond-accurate timer—no half-done records. Pragmatic Works demos replacing built-in Timer limits using command-bar JavaScript.

💡 Start/Stop record-scoped timers, persist state across tabs, and write elapsed ms
🔍 Wire Begin/Stop buttons, pass primaryControl, survive reloads
⚖️ Logs only when the timer completes; the video challenges you to add Pause/Cancel.

▶︎https://www.hubsite365.com/en-ww/citizen-developer/?id=bcddd109-67ae-f011-bbd2-7ced8d8ed4ba&topic=8daf8386-bb75-ea11-a811-000d3a210788&theater=true

Watch the walkthrough and try the challenge—what would you add to this timer?
#PowerApps #Dataverse #LowCode #Microsoft

🟩 Introduction to Dataverse Introduction to Dataverse MCP
Julie Koesmarno demos the Dataverse MCP Server—agents can query and update Dataverse with natural language across Copilot Studio, Claude Desktop, and VS Code/GitHub Copilot.

💡 Add Dataverse MCP as a tool in minutes for retrievals and write‑backs.
🔍 Auto-generate ERDs and dashboards from live Dataverse tables.
⚖️ Cross-platform integration with enterprise security and lifecycle controls.

▶︎https://www.hubsite365.com/en-ww/citizen-developer/?id=d4e77204-00a9-f011-bbd2-7c1e5227538c&topic=8daf8386-bb75-ea11-a811-000d3a210788&theater=true

#Copilot #Dataverse #MCP #PowerPlatform

⛔ Still using sync HTTP requests in your model-driven apps?

Part 3 of our Power Platform Performance series shows how to replace them with async best practices for faster, safer forms 🚀

#PowerApps #JavaScript #Dataverse #LowCode

http://mytrial365.com/2025/10/16/power-platform-performance-using-asynchronous-http-calls-for-faster-smoother-forms/

🚀 Sluggish forms kill user experience. Start fixing that today.

Part 1 of our Power Platform Performance series is live:
“Design Performant Forms in Model-Driven Apps”
💡 Layout tips, async JS, caching strategies & more!

#PowerApps #Dataverse #Performance

http://mytrial365.com/2025/10/02/enhancing-form-performance-in-power-apps/

Here's a bit of a technical post about how to change the default 28-day run history to something adapted to your needs. Whether you want longer retention periods for sporadic runs or lower retention periods to save on Dataverse costs, I've got you covered. Here are 2 ways to do it. http://tgom.es/ladki #powerautomate #dataverse

🔐 Ever had a customer email you their credit card number or TFN? 😬
Now imagine that info being visible to every support agent in the system...

The new Data Masking Rules in Power Platform give you a clean, built-in way to automatically obfuscate sensitive data, on forms, in emails, and even in Copilot replies.

👉 Check it out and let me know: What’s one field in your system that absolutely needs masking?

#PowerPlatform #DataPrivacy #Dynamics365 #Security #Dataverse…

http://mytrial365.com/2025/09/25/mask-it-like-you-mean-it-protecting-sensitive-data-with-power-platforms-new-masking-rules/