Power BI

<p>Organizations and governments around the world are going through an unparalleled pace of digital transformation. This unprecedented pace calls for advanced protection mechanisms that offer security, compliance, and enterprise grade governance controls. Cybercrime is big and growing bigger. Every minute malicious actors simulate thousands of attacks to steal identities, disrupt services, and obtain unauthorized access to…</p>

Overview of Cards for Power Apps, new features, differences with a standard Canvas App and how it integrates with Teams.

<p>We are excited to announce that Power Pages design studio is now fully compatible with Power Apps portals. Portals created with the blank template or Dynamics 365 templates from PowerApps can now be customized in the Power Pages design studio. Try editing your Power Apps portal site with the Power Pages design studio and experience…</p>

In this blog post you will learn how to fill an excel file with data from Dataverse using Office Script and Power Automate.

I love the new Power Apps comments feature. Comments are used to collaborate with other developers and give feedback.

This feature "Format data by examples" will kill one of my most popular posts! How to format dates using formatDateTime.

We’re pleased to announce that Power Apps Ideas are now generally available. Now you can easily write a Power Fx formula using natural language or examples.

The hunt is over! Use Search to quickly find the command you're looking for even when it's not available by default in the shortcut menu.

Step by step tutorial to build a command bot for Microsoft Teams using Teams Toolkit with Visual Studio Code.

Power BI adoption roadmap conclusion7 minutes to read4 contributorsThis article forms part of the Power BI adoption roadmap series of articles. For an overview of the series, see Power BI adoption …

Have you ever wished Power BI knew the optimal number of periods to show? It is possible with my Smart Axis Magic :) ! Here is how to improve UX by creating a smart date axis that automatically picks the optimal calendar period based on the timeframe. In this step-by-step explanation we dive deeper into field parameters, data modeling, and DAX. Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :) Download link: https://my.datatraining.io/course?courseid=howtopowerbifiles *See improved solution in the download files, where you don't need the bridge table and can use a between date slicer -------------------------------- 📊 TRAININGS 📊 --------------------------------- New! Power BI Design 4 Weeks Transformation Program https://my.datatraining.io/pages/powerbidesigntransformation Learning Path https://my.datatraining.io/subscriptions?id=power-bi-zero-to-hero For Custom Trainings and Consulting email directly support@datatraining.io --------------------------------- ⏱️ TIMESTAMPS ⏱️ --------------------------------- 00:00 Intro 01:43 Step 1 - Creating a field parameter with periods 03:23 Step 2 - Creating a helper table 07:17 Step 3 - Creating the relationships 09:14 Step 4 - Applying a TopN filter 10:14 Demo - smart date axis 10:55 Finishing touch - Dynamic title 13:40 End --------------------------------- 😍 JOIN 😍 ---------------------------------- Subscribe: https://bit.ly/31MnQGO​ Website: https://www.datatraining.io Facebook: https://www.facebook.com/groups/howtopowerbi LinkedIn: https://www.linkedin.com/company/datatraining-io Insta: https://www.instagram.com/howtopowerbi/ Twitter: https://twitter.com/HowToPowerBI --------------------------------- 👇 CHECK THIS OUT! 👇 --------------------------------- 💻 My gear https://a.co/69HEjRu 📚 Power BI books MUST READ! https://a.co/5q5k6Dv 💡 General books I recommend https://a.co/05I4W2L 🎶 Music for my videos https://www.epidemicsound.com/referral/8pjcbj 🚀 For growing on YouTube: https://www.tubebuddy.com/bas 🏄 Stuff I use daily https://a.co/4V5CUJN * Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos! Thanks for being a part of this channel and all your support! 💪 🙏 #HowToPowerBI​ #PowerBI​ #DataTraining​ #powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

Quick Tip:Are you OCD like me?Wish you could align your tables in the model view but there are no alignment tools?1. Select the tables you want to align.2. Click on the lowest aligned table and smash it into the ceiling.3. Click and drag another table back down.#PowerBI pic.twitter.com/pV3ooZSJG1— Kim Preece (@KNPBI) November 3, 2022

In this post, I am going to look at automatic partition maintenance by Power BI service for datasets with Incremental Refresh and focus on what happens to the partitions as time goes by. To do this, …

Analyzing data is much like the natural world in many ways. For example, if we walk around a forest, we see the trees towering over the ground.

Can you spot the difference between the following two report pages? Yeah, neither do I! But, there is a huuuuuge difference between those two reports! What if I tell you that the report on the right is 5x faster than the one on the left? Would you believe me? No? Then keep reading and I will show yo

#PowerAutomate Error Handling Patterns 👉 https://lnkd.in/eZG9kJ_m 📕 FREE PDF version available for my blog subscribers ⚖ Try, Catch, Finally ❌ Terminate…

Hi everyone! Quick method to save a bit of report space by using shorter names for date granularity selection within the slicers 🔎🔎 Following example... 14 comments on LinkedIn

𝗙𝗶𝘅 𝗳𝗼𝗿 𝗿𝗲𝗳𝗿𝗲𝘀𝗵𝗶𝗻𝗴 𝗥𝗘𝗦𝗧 𝗔𝗣𝗜 𝗱𝗮𝘁𝗮 𝗶𝗻 𝗣𝗕𝗜 𝘀𝗲𝗿𝘃𝗶𝗰𝗲 🔥 If you don’t do this your API data may not refresh. First of...

Formula repair in Power Apps (preview)2 minutes to read2 contributors[This article is pre-release documentation and is subject to change.]When writing Power Fx formulas, errors are often unavoidable. …

Managing moving parts is hard, and it’s costly to fumble big projectsStruggles with monitoring project health can be perilous. A disastrous project or series of projects could cost your company …

Power BI Cohort Analysis, DAX Cohort Analysis, Power BI Customer Retention %, DAX Customer Retention %, PL 300 --Content 00:00 Introduction 00:28 Problem Statement 02:00 Power BI Cohort Analysis 12:00 Customer Retention % Last Video: Power BI Unselected values as others, Power BI Show Others, Power BI Pie with others, DAX Others, Concepts PL 300 Abstract Thesis 111: Power BI Modelling- Unselected values as others: https://youtu.be/HX4pgexYwf4 Also, refer Dynamic segmentation -Measure to Dimension conversion: https://youtu.be/gzY40NWJpWQ Dynamic Segmentation, Bucketing, or Binning: https://youtu.be/CuczXPj0N-k Dynamic Segmentation Bucketing Binning https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626 Customer Retention Part 1: https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-1-Month-on-Month-Retention/ba-p/1361529 Customer Retention Part 2: Period over Period Retention https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-2-Period-over-Period-Retention/ba-p/1377458 Customer Retention Part 5: LTD Vs Period Retention https://community.powerbi.com/t5/Community-Blog/Customer-Retention-Part-5-LTD-and-PeriodYoY-Retention-is-only/ba-p/2114497 Last Video: Abstract Thesis 87: Power BI Tooltip Page: How to pass selective values to the tooltip page: https://www.youtube.com/watch?v=lEq7YtkxeLU This link will take you to the power bi dashboard that has links for all my blogs and video -You can get all my posts at https://community.powerbi.com/t5/Data-Stories-Gallery/Blog-Analysis/m-p/1265567#M4403 Like, Share, comment, and Give suggestions for improvement, and the next post/video. Important Links every power bi enthusiastic should bookmark: https://amitchandak.medium.com/important-links-every-powerbi-enthusiastic-should-bookmark-5682c7a3c912 DAX Calendar - Standard Calendar, Non-Standard Calendar, 4-4-4 Calendar https://www.youtube.com/watch?v=IsfCMzjKTQ0&t=145s Also, check Cheat Sheet — Power BI Time Intelligence Formulas Using Today - https://medium.com/chandakamit/cheat-sheet-power-bi-time-intelligence-formulas-using-today-654f26e27304 Cheat Sheet — Power BI Calendar that starts with any date of the month — Just two variables apart - https://medium.com/chandakamit/cheat-sheet-calendar-that-starts-with-any-date-of-the-month-just-two-variables-apart-9fb9a0f65b92

From the ancient masters of rhetoric themselves, we are told that logos, or logic, is an effective way to persuade an audience. And all of recorded history is a testament to the power of storytelling, a most innate human attribute, to influence people’s actions. Therefore, being able to tell a st

We are excited to announce the public preview release of maker matching in Power Apps! Maker matching, available within the integrated virtual agent, connects new makers with other experienced makers, advisors, and internal community members who can help directly when you need it. The support bot also surfaces relevant internal resources and community channels to … <p class="link-more"><a href="https://powerapps.microsoft.com/en-us/blog/announcing-public-preview-of-maker-matching-in-power-apps/" class="more-link">Continue reading<span class="screen-reader-text"> “Connect with other makers in your organization via maker matching, now in public preview!”</span></a></p>

We are pleased to announce the general availability of the enhanced environment picking experience. The enhanced environment picking experience makes it easier to find the right environment to work with. For example, makers can now directly tell environments with Dataverse apart from those without Dataverse, as well as environments where they have sufficient maker and … <p class="link-more"><a href="https://powerapps.microsoft.com/en-us/blog/making-it-easier-to-work-with-the-right-environment/" class="more-link">Continue reading<span class="screen-reader-text"> “Making it easier to work with the right environment”</span></a></p>

We are happy to announce that Coauthoring is now available in most of the regions allowing fusion teams to build better apps faster. With coauthoring you can see who is working on the same app at the same time, and you can see their applied changes in real-time. You don’t need to worry anymore about … <p class="link-more"><a href="https://powerapps.microsoft.com/en-us/blog/announcing-public-preview-of-coauthoring-in-modern-app-designer/" class="more-link">Continue reading<span class="screen-reader-text"> “Announcing public preview of coauthoring in Modern app designer “</span></a></p>

Welcome to the Power Apps monthly feature update! We will use this blog to share a summary of product, community, and learning updates from throughout the month so you can access it in one easy place. A variety of new and highly anticipated features are now available which we are very excited to share. We … <p class="link-more"><a href="https://powerapps.microsoft.com/en-us/blog/whats-new-power-apps-october-2022-feature-update/" class="more-link">Continue reading<span class="screen-reader-text"> “What’s new: Power Apps October 2022 Feature Update”</span></a></p>

We’re glad to announce that formula repair is now available for you in preview. We know when writing formulas, errors are unavoidable, and troubleshooting could be time-consuming and cumbersome even for tiny errors like a missing parenthesis. With formula repair, now you may skip some of the troubleshooting effort as whenever you have a formula … <p class="link-more"><a href="https://powerapps.microsoft.com/en-us/blog/formula-repair-now-in-preview/" class="more-link">Continue reading<span class="screen-reader-text"> “Formula repair now in preview”</span></a></p>

A few weeks ago I wrote a post showing how you can use the new EvaluateAndLog DAX function to diagnose performance problems relating to the use of the Switch function. Did you know that calculation…

In October 2022, two new DAX functions appeared in the Power BI service: TOCSV and TOJSON. In this blog post, I'm showing a few use cases.

Did you know there are a lot of keyboard shortcuts for the advanced editor in Power Query that can save you time?