Greg Deckler

Do you find that pressing tab while using #PowerQuery's Intellisense repeats the term before the "." in a function name? 🙈 This drives me crazy! In this episode of Monkey Shorts, we'll look at two ways to use the Intellisense in Power Query so that you get the correct function name without duplication: https://lnkd.in/gTt4Puwy

22

4 Comments

The latest update to the ALM Toolkit allows you to view semantic model metadata in TMDL format with helpful, easy-on-the-eyes syntactical coloring! #tmdl #developermode #pbip #powerbi #microsoftfabric #almtoolkit

45

3 Comments

Highlights include a video intro to the new Modern Charts feature, combination query techniques, and handling bit fields in SQL Server. #msaccess #vba #softwaredevelopment

11

1 Comment

"You've got N unused apps in your #PowerPlatform environments, purchase premium licenses to see what they are."💸 There's a teaser UI in PPAC today, when looking at the Power Platform Advisor recommendations. ("Advisor" being a technical feature here, not a consultant.😉) You can see a detailed list of unused apps from Managed Environments. In addition, you can see the total number of apps per environment in non-Managed environments. I think this is actually a nice way to build up awareness and urgency for Power Apps/Automate premium license acquisition. Especially for customers that don't have a human advisor they can ask guidance from. The product UI and default settings have a far bigger impact than anything I could post on social media. At the same time, you can't yet go all that far with the built-in features of the Power Platform Advisor. In particular, there should be a way to exclude apps from this list, without physically deleting the apps. Otherwise the list is just going to grow & grow, without being very actionable.😰 (Yes, I've given this feedback to the product team, too.) When Managed Environments aren't enough for your #lowcode platform governance needs, you can always upgrade to the #CoEStarterKit. When connected with app telemetry data, it can offer customizable reports for analysing app usage. Best of all, you can build views, extend the data model and create the necessary internal tooling to support your organization's internal processes.🛠️ With CoE, you can also govern the dreaded Default environment.😬 Without requiring every single Power Apps user (not just maker) in your M365 tenant to have a premium license. That way, you won't have to wait for your organization's EA contract negotiations with MS to reach the wall-to-wall Premium license coverage needed for Managed Environments. Anyone tried using just the Advisor feature for handling unused apps? What are your experiences with this? What works & what's still missing from ME capabilities?

11

6 Comments

My article “Workflows - infusing classic ingredients into your Power Platform recipe” was mentioned to Power Platform Weekly 🥳 Thank you very much! 🥰 Link: https://lnkd.in/engZx6ih

26

1 Comment

HUGE #PowerPlatform updates ✨✨✨ Out of all my years on the platform these might be some of the most important updates I’ve seen and truly mark a paradigm shift: First, seeing #coauthoring come to fruition is nothing short of a massive milestone that will be a game changer for organizations with traditional development teams looking to collaborate and build apps in a team based format. Secondly, and this one truly brings tears to my eyes, Native source control integration with #DevOps 👏👏👏👏👏👏. THIS. IS. AMAZING!!! It breaks down the massive barrier that existed for makers trying to implement good ALM practices but not being familiar with DevOps pipelines / source control. This paired with the Managed pipelines feature available in managed environments, provides a platform based solution to ALM without needing to install the ALM accelerator. Oh ya and copilot … 😉

3

The #PowerApps feature I blogged about in 2019 is now in Public Preview! 😀 Reading the May 2024 feature update blog post from the product team, I saw a topic that's close to my hear: licensing.❤️ "Public Preview for cross-tenant license recognition Power Apps using Dataverse" What this means in short is that once a user has a Power Apps Premium license assigned in their home tenant, they can leverage canvas apps with premium features in any other tenant where they are the guest. I was excited about this possibility already back in 2019 when I wrote the following blog post: https://lnkd.in/dkXv9fgC I copied the attached image from it. As you can see, a few changes are in order, but the fundamental concept remains the same. #Dataverse was still called CDS back in those days, yet sharing access to it for guest users did already work. At some point this support must have dropped away but now it's coming back: "To reduce administrative overhead for multi-tenant organizations using Power Apps, we are super excited to announce public preview of cross tenant license recognition for canvas and model driven apps using Dataverse! When end-users access an app outside of their home tenant, Power Apps recognizes use rights the user has in both their home tenant or in the resource tenant (where the app is hosted). This is an enhancement to the cross tenant license recognition that already existed for canvas apps not using Dataverse." There's so much value to be unlocked by having a Power Apps Premium license, especially if it could also cover a network of companies that work with one another across Microsoft 365 tenants. Especially when the Premium license is now -50% compared to 2019.

228

16 Comments

Check out these new capabilities in prompts! You can now use your own data from Dataverse! 🚀

9

Have you seen the fantastic new flyout for Power BI Desktop developer mode? It not only clearly indicates when you're saving to a Power BI Project (PBIP), but also conveniently allows you to jump to the PBIP folders. Learn more: https://lnkd.in/d3CR56w9 #powerbi #microsoftfabric #developermode #pbip

516

10 Comments

If you happen to see Nokod Security's article about Power BI, you shouldn't be concerned as a Power BI user. It seems they've discovered #PowerBI Publish to the Web functionality. I'm not sure what the issue is as the feature guidance specifically calls out you should only use it for publicly accessible data. https://lnkd.in/g3am7d8M You also don't need any "free" tools to discover what has been published to web in your Power BI instance. Your admin can go to Embed Codes within the Power BI admin portal to see everything that is publicly facing. In fact, have your Power BI admin review what is in this portal now, just in case someone inadvertently published something to the web. We first wrote about Publish to Web and its implications 5 years ago to the day (June 25, 2019) and teach it in every Power BI workshop. When used appropriately, it's a great feature. https://lnkd.in/gUKBvg8b

7

This exciting #DimensionalModeling training pairs two of #SelfServiceBI’s most powerful features: #PowerQuery and the #DataModel. Learn to use each for what they were designed to do, and how to determine if it’s a Power Query job or a #DAX job. 💪 🔵 Join us today and use code LEARNMODEL to save 20%: https://lnkd.in/g3QKXcH9 #NationalOnlineLearningDay #DataAnalysis #BusinessIntelligence #DataModeling

2

Watch Damien Bird's latest video demonstrating how to trigger a flow from a button in SharePoint for a selected item or file. The video provides a step-by-step guide on integrating Power Automate flows directly into SharePoint Lists and Document Libraries, including some code walkthroughs and tips on using Copilot to speed things up. 👌

8

2 Comments

Power Platform Greatest Hits, Vol. 2: Stunnware Tools for Microsoft Dynamics CRM 4.0 by Michael Höhne. Today, there's is vibrant ecosystem of community and ISV tools for #PowerPlatform. Rewind back to 2008 and early XRM days, and you were lucky if there were forum threads about how to solve your problem with the SDK and a lot of custom code. We were still years away from what #XrmToolBox made possible. The first box of tools for admins and developers that I recall seeing was from Stunnware. I still have the .chm help file for the product, which gives this intro: "The Stunnware Tools for Microsoft Dynamics CRM 4.0 combines a set of tools created for CRM developers and consultants. Initially being divided into multiple standalone applications, the tools framework serves as a single container for all of them, allowing for interaction between components which wasn't possible before." There was a free Community Edition with Metadata Viewer, FetchXml Wizard and Excel Export. The paid Professional Edition added Code Generator for C# and VB.NET, CRM Help File Generator and additional features for the FetchXml wizard. Browsing through the screenshots, I also saw Sitemap & ISV.Config editor, customization comparison, trace file viewer. All highly useful tools for customizing and troubleshooting the CRM 4.0 servers that you were intimately familiar with back in those pre-cloud days. The pattern of hosting multiple tools inside a common framework still lives today in the XrmToolBox platform that Tanguy TOUZARD created. Generating and editing FetchXML is today made possible by the tool maintained by Jonas Rapp. The stats say that in 2024 there are in total 375 tools created on top of XrmToolBox. 16 years ago, no one could have imagined what an important role the 3rd party tooling on top of Microsoft's platform would be playing in enabling the success of #Dataverse, #PowerApps, and #Dynamics365 CRM apps. But seeing the Tools that Michael Höhne combined under his solution must have given inspiration for many who are still contributing to the tool ecosystem today. That is the reason why I selected Stunnware Tools to be the second chapter in my #PowerPlatformGreatestHits series. If you have memories of using the tools in your work, feel free to drop a comment below and show the whole world what an old CRM geek you are.🤓

99

21 Comments

⭐ Learn about Power Automate cloud flow Licensing, Ownership, and API Limits Watch 📽️ https://lnkd.in/gNRAvBre ✔️ Identify license needs ✔️ Power Platform request limits? ✔️ Change Owner of cloud flow #powerautomate #powerplatform

311

5 Comments

Adding #PowerApps apps to #MicrosoftTeams has been broken for 2 weeks now. Are people actually not using this feature or what's the catch?🤨 When using the "add to Teams" feature from inside Power Apps Maker portal, the resulting tab addition to Teams fails with the message "this app does not exist". There's something messed up with the app manifests. The issue also concerns apps that have been previously added to the Teams app catalog of the M365 tenant. There is a workaround: you can first add the Power Apps for Teams app as a tab, then pick the app from the list - and it works. Presumably because the ancient "Power Apps version 0.7" that lives inside Teams creates the app manifest in a different way than the other features. When talking to an ISV today, I learned that the issue has been affecting all their customers' tenants for 2 weeks now. Tickets have been opened, no solution available yet. It makes me think that there can't be a very high number of users that rely on Power Apps distributed via Teams. Otherwise an issue like this would have gotten more attention. In the same session, I also learned that using AI prompts in Power Apps is broken on the Teams desktop client. Works on the web client. That's a bit easier to understand, given how the AI Builder GPT models probably aren't in mainstream use yet. Have you encountered this kind of issues when using Power Apps via Teams tabs?

52

24 Comments

Sometimes, you want to browse #Microsoft's official documentation for #PowerQuery's function library when you are writing a query. Maybe you need to discover a function, or maybe you just need more information on how it works. In this episode of Monkey Shorts, we'll look at two options for doing so: 🔶Microsoft's official website 🔶Using the #shared keyword inside the Power Query editor Watch the episode here: https://lnkd.in/gCaeTphx #Excel #PowerBI #DataAnalytics #DataAnalysisTools

17

1 Comment

Embed workflows in your Power BI Reports with Power Automate Visual, now Generally Available ▸ https://lttr.ai/AU75r #GainValuableInsights #PowerBiReports #PowerBiDesktop #PowerAutomateVisual #PowerBiVisual #Wefine

1

Fabric Databases are designed with the DBA in mind. Check out how EASY it is to monitor the performance of your Fabric Database! Unbelievably nice for a public preview feature! #MicrosoftFabric #PowerBI https://lnkd.in/g7uRjKmf

18

Curious about how to streamline app development without extensive coding? Discover the power of Model-driven Apps! Learn how you can build robust, data-centric applications with ease using Microsoft Power Apps. From modeling business data to defining processes, we break down the benefits and methodologies.   Read now and transform your App Development Process: https://lnkd.in/gRUw_GRs #NoCode #PowerApps #ModelDrivenApps #AppDevelopment 

35