
Power BI
The Future of Business Intelligence Part 1: The Mangled 'Supply Chain of Analytics'
Why the 'supply chain of data' has reached it's terminal endpoint, a history of how we got here, and a glimpse at what comes next.

Has Progress on Data, Analytics, and AI Stalled at Your Company?
Companies need to rethink how they’re investing in data, analytics, and AI — and whether these investments are creating real business value.
A disappointing 40.8% of executives reported that their companies were competing on data and analytics, a decrease(!) from 47.6% four years ago.
Finally, and most discouraging, a meager 20.6% of executives — barely one in five — reported that a data culture had been established within their companies, a 27% decrease from the 28.3% of companies reporting having established a data culture back in 2019.* Regression, not progress.
It's about the proces and the people

Bayer builds crisis management dashboard for data-driven decisions using datamart in Power BI
Bayer is a life science company and a global leader in healthcare and nutrition—and the organization’s work became even more critical during the COVID-19 pandemic. To keep its employees safe and business production on track, the Bayer crisis management team needed access to critical COVID information for the ASEAN country group. Using datamart in Power BI, the organization built a dashboard that delivers insights in real time, enabling better decision making and enhancing cross-team collaboration for future crisis management needs.

How to build data literacy in your company | MIT Sloan
Data literacy is an in-demand skill for many workers and a stepping stone to becoming a data-driven organization. Here’s how to get started.
“In a world of more data, the companies with more data-literate people are the ones that are going to win,” said MIT Sloan senior lecturerMiro Kazakoff
chief data officers found that poor data literacy is one of the top three barriers in building strong data and analytics teams
understanding data and data visualization

Screen Guides component for Power Apps
Let’s face it: sometimes canvas apps end up too complex and users get easily little bit lost with where to find which functionality or even what features are available. To be easily able to p…

How to incorporate fluent UI framework in Canvas Apps - Microsoft Dynamics 365 CRM Tips and Tricks
To enhance the look and feel of the Canvas App, we can use a fluent UI framework by using the Creator Kit. The Creator Kit helps create Power Apps experiences on the web and mobile platforms with convenient components appearing in modern software. Prerequisites - The Power Apps code components for the Canvas Apps feature

More on Formula by Example
Last month, we announced Formula by Example starting to roll out to Excel web users. Formula by Example looks for patterns as the user enters data in the worksheet. When it recognizes a pattern, Formula by Example offers a formula to fill the rest of the column with the recognized pattern. The examp...

Build next-gen apps with OpenAI and Microsoft Power Platform
Today, we will talk about OpenAI and the Microsoft Power Platform and how to build next-gen application with it. Over the past few weeks, social-media feeds and newsletters have been filled with stories and conversations about artificial intelligence (AI). ChatGPT and OpenAI were often center of the...

Microsoft 365 & Power Platform Development Community call - 2nd of February, 2023
Two demos: Turn that ‘Power Apps’ app into a Mobile app! and List Formatting Magic – Query string options and look up field handling. Delivered 4 Independent Publisher Connectors, 2 Teams, 7 Script, and 2 Power Apps samples.

Dataflows refresh monitoring – Data Meerkat
Dataflows have been with us in Power BI for some time now, and people have gotten more used to them. However, as their popularity grows, so does the need to control them.

A - Accordion gallery - How to make one in Power Apps | Hardit Bhatia: The Power Addict
Learn what is an accordion gallery and how to make one in Power Apps using either a single gallery or nested galleries!

B - Batch updates using ForAll or not - Which is better? | Hardit Bhatia: The Power Addict
Learn how to perform batch updates in Power Apps! Should you use ForAll + Patch or just the Patch function? Which one is more performant?

C - Custom pages - how to add multiple screens? | Hardit Bhatia: The Power Addict
Custom pages bring model-driven apps and canvas apps together! However, you cannot add multiple screens out of the box. Learn how to!

Reinventing search with a new AI-powered Bing and Edge, your copilot for the web

Power Platform: Coming Soon: Power Platform Connections!...
Power Platform Connections is a new show hosted by David Warner and Hugo Bernier from the Power Platform Community Team....

16. Intro to PCF Control
Power Component Framework can be used to enhance the user experience for users working with data on forms, views, dashboards, and even canvas app screens. Learn more in #LowCodeFebruary.

New Navigation for Power Apps Maker Portal - Aric Levin's Digital Transformation Blog
If you have launched the preview maker portal in the last week or so, you might have seen some big changes in the navigation and the ability to customize this to fit the needs of the maker. In this post, I will demonstrate some of the new highlights of the new preview portal (currently in Preview), and discuss some of the benefits.

SubwayNav control reference (preview) - Power Platform
Learn about the details and properties of the SubwayNav control in the Creator Kit.

Make Your Goals a Reality with OKRs and New Capabilities from Microsoft Viva Goals
As we enter a new year, more gyms are packed, more books are read, but within the first month, about a third of individuals will see a dissolution of their goals. Setting goals and sticking to them isn’t just a challenge for personal pursuits—it holds true for your professional life too. Organiza...

powerbi-desktop-samples/README.md at main · microsoft/powerbi-desktop-samples · GitHub
Power BI Desktop sample files for the monthly release. Here you can find the PBIX files used in the monthly release videos. - powerbi-desktop-samples/README.md at main · microsoft/powerbi-desktop-s...

GitHub - KornAlexander/PBI-Tools monitoring solution for pbi report server. PBIRS
Contribute to KornAlexander/PBI-Tools development by creating an account on GitHub.
Automatically generating measure descriptions for Power BI and Analysis Services with ChatGPT and Tabular Editor
Using thr char gpt api and tabular editor you can now add business descriptions to your dax statements.
Deneb Template - IBCS Performance Visual
The IBCS standard can enhance the clarity of visualizing relative performance by distilling it to its essence, and I enclose a Deneb/Vega-Lite template for such an IBCS-style visual. This is a single composite visual that’s been provided with only category (product), current year (Sales CY), and previous year (Sales PY) data values. This template illustrates a number of Deneb/Vega-Lite features, including: a “title” block with title and subtitle text a “transform” block to extend the datase...
SynapseGenie/utilities/DeltalakeAutoMaintain at main
Genie Framework improves Spark Pool utilization by executing multiple Synapse notebooks on the same spark pool instance. Uses vaccum and optimize to maintain efficient delta tables.
Strengthen Delta Lake in Synapse with auto maintenance job
Using optimize and vaccum to removed unused delta patition files.
Helps maintain a minimized delta table size footprint.
Deviating from Star Schema Principles a financial model
A finance user case The Star Schema methodology is the application of dimensional modelling techniques to a relational database. This includes not only simple star shaped models, but a wide range of techniques such as snowflaking or factless fact tables. These principles should (almost always) be adopted in Power BI (a relational-like database). This article discusses one of the exceptions; dealing with subtotals.
Avoiding The "Maximum Allowed Size" Error In Power BI DirectQuery Mode With Aggregations On Degenerate Dimensions
Prevent the "The resultset of a query to external data source has exceeded the maximum allowed size" error in Power BI by building aggregations

Streaming data Azure & Power BI - Introduction
Case I want to send streaming data to Power BI for reporting purposes. What should I take into account when choosing the right architecture...
