Power BI

PowerApps allows you to can manage organizational data by using either an app that you created or one created by someone else who shared it with you.

Using Azure Functions to extend PowerApps expression language: a walk-through with examples

A SharePoint, Office 365, Azure, PowerApps, and Mobile Blog

Reference information for working with state, context variables, and collections

When you create a canvas app in PowerApps, you can now use server-side business logic from the Common Data Service.

In the May update of Power BI desktop, we are excited to see the release of the new Power BI connector for the Common Data Service for Apps. The CDS for Apps Power BI connector allows you to connect d…

Working with data in the Common Data Service for Apps (Import, Export and the Excel Add-in)

#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.

The October release of PowerBI Desktop introduced a very interesting feature, Top N filtered is pushed down for Direct Query Sources, I thought I may give it a try and blog about it, for some reaso…

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

Sometimes, when you’re analysing data, you need to be able to change variables and see what the impact is: for example you might want to see what your profit margin looks like if tax rates ar…

Today, we’re excited to announce that Community Templates are now available, giving our community members an opportunity to contribute to our existing template gallery.    Templates are predefined Azure Data Factory pipelines that allow you to get started quickly with Data Factory. Templates are esp...

We are constantly inspired by all of you and how you use Azure Data Factory for all your data integration needs. Thank you for continuing to share your feedback with us. We love hearing from you and continue to use your input to improve Azure Data Factory.    Many exciting announcements are landing ...

I've blogged twice (here and here) about authentication using the msal Python module. I'm going to cap off this topic with a third and final entry by moving onto the azure-identity module. When I first looked at Azure authentication for the Power BI REST API, I honestly kind of fell into using the msal library first. I found it easy to use and went on to blog about it. Recently, I needed to use the azure-identity module took the time to try it out for getting access tokens to call the Power BI A

Databricks, Lakes & Parquet are a match made in heaven, but explode with extra power when using Delta Lake. This session will dive into the details of how Da...

Author(s): Arshad Ali and Abid Nazir Guroo are Program Managers in Azure Synapse Customer Success Engineering (CSE) team.   Introduction Data Lakehouse architecture has become the de facto standard for designing and building data platforms for analytics as it bridges the gap and breaks the silos cre...