Power BI

Power Apps Portal Studio has built-in functionality that allows you to change the appearance of a website without writing code. In this blog post, we explore how it’s done!

The quick measure calculates the Pearson correlation coefficient between two measures within the category.   NAME: Correlation coefficient   DESCRIPTION: Calculate the Pearson correlation coefficient between two measures within the category   PARAMETERS: Name: Category Tooltip: The category in which...

How to simplify DATA with an INNOVATIVE narrative? Here comes the story, with data. Creativity is one of the foundations of innovation and data is the basis of our Digital period. Learning to deal with both, through storytelling, means turning information into solutions, understood for a lot of P...

On-premises data gateway (standard and personal mode) release for October 2021

#powerbi #MSPowerBI

GitHub Copilot works alongside you directly in your editor, suggesting whole lines or entire functions for you.

Reference information including syntax and examples for the App object in Power Apps.

There is a new declarative way to control the first screen shown in a Canvas app: App.StartScreen. It is our first step in providing declarative alternatives for all the things that are done in App.OnStart today. App.OnStart is the source of many app load performance issues as it’s imperative nature prevents many optimizations. Not only that, declarative alternatives are easier to use and less error prone.

Warning : this documentation may mention some features under development which will appear in short term.

DAX generator is a component of Power BI Sidetools able to create complex DAX expressions within your model. Once you built or found the appropriate template,

In this blog post I will outline how to get responses from Microsoft Forms into Microsoft Lists using Power Automate. I am using the Microsoft Lists, Issue tracker template for my examples. I have …

Introduction: In Power Automate, at times we must work on fraction values, float function is used to achieve this. As an example in order to send discounts notifications to customers during festiva…

Since the Power BI team allowed to launch external tools from the Power BI desktop ribbon, several tools became available. Do you know you can create your own

Use this PowerShell solution to verify if best practices are applied in all Power BI models. It includes a template report to analyze results.

#PowerAppsChamp Trading Cards App - v1 This project started from a tutorial as I taught my 10 yo daughter how to make app in Power Apps. (https://twitter.com/alanchai/status/1199874832931917824?s=20) …

Shared via Flipboard

Introduction: In Power Automate, at times we need to merge 2 different strings into an Array we can use Create Array Function so that we can get easily desired result. As an example, let us see how…

When you develop your flows inside solutions you have the option to use child flows. But are they worth it?

Use Aggregate functions using GroupBy in Power Apps canvas apps, Sum/ Count using groupby in canvas apps.

DataSourceInfo function can be used to check the Table / Entity level permission. We can check for Create, Read, Edit, and Delete Permission and can disable, hide and show the corresponding create,…

Microsoft is continually building AI functionality to improve the coding and non-coder experience with examples that include natural language query code generation. In this post, we will explore the pre-release Power Apps Ideas functionality, which transforms natural language formula to code, and the Train with Examples functionality that takes advantage of the ideas of Programming by example (PBE). We will look at how it is applied in the Canvas Apps in data … Continue reading Power Apps Ideas Transforms Natural Language to Formula

Gain deeper insights and take action in optimizing and automating your process with Process advisor Application Analytics and Automation Recommendation features, which are now generally available

Error handling is almost done. Before we complete it, we are making some small changes to how Blank is handled by the Value functions. All changes are under the experimental “Formula-level error management” switch and will not impact the vast majority of apps. We are also introducing a new home for experimental feature documentation and feedback in the community forum.

As you troubleshoot your Canvas Apps, here are a few tools that will be helpful for your troubleshooting!

Performance, performance, performance, everyone loves a report that has good performance right? Specially if we are talking about reports using Direct Query, which is the main focus of this post. While you have some settings in Power BI Desktop that can help you with query reduction (specially useful if you're using Direct Query!), there is no option to add an "Apply all filters" button directly in your report page. Yes, you can add an "Apply all" button if you use the filter pane, but if you're

The first and most important thing we need to understand to get our expected result is forcing the user to use a custom navigation inside of the report. Let's avoid the default pages navigation. We might need to build a single visible Menu page to start our report. You can find a lot of post and vid...

Using the small multiples in Power BI, monitor performance of multiple stores and analyze data in more granular categories

Read this blog to know more about xViz Multiple Axes chart for Power BI which can represent multiple KPIs in up to 5 different axis scales

In this blog post I show how to overcome an error when deploying to Power BI Premium per User when there are incremental partitions created.

Writer and developer James Bartlett delivers another great update to Business Ops for Power BI read about a new tool release Report Analyzer