Power BI

Hello! My name is Maya. I’m a rising sophomore at the University of Illinois at Urbana-Champaign studying Molecular and Cellular Biology. You can find me on Linkedin here. I joined DataChant to explore the data analytics world before I immerse in biology research next year — this is clearly very new to me, which makes […]

Breaking change to Power BI PowerShell cmdlets. Need to upgrade module to 1.0946 or later

Welcome to the June update! Loads of updates on connectors this time around. Also, DirectQuery support for Dataflows is now generally available! On top of that, we are happy to announce the preview of the paginated reports visual – we know many of you have been eagerly awaiting it, so take it for a spin and provide your feedback! Our Small Multiples and DirectQuery for Power BI datasets and Azure Analysis Services previews are still ongoing and receiving some updates this month. There is much more, so read on!

The huge enhancement to the APIs we’re announcing today includes the items our customers have been asking for most – now, as part of the API response, you can get the metadata of dataset tables and columns, measures, DAX expressions, and mashup queries.

Charticulator has been around for a while but recently Microsoft announced the Public Preview of Charticulator in Power BI. So what is Charticulator? The best way to describe it is a 'low code' environment where you can build new and exciting chart types directly in Power BI. It really is a fantastic tool for Power BI development. Why is this cool? Well Power BI developers have always had a few choices when it comes to using non native visuals. Just go to Microsoft's App source and you will s

New option available to enable bookmarking, export, printing, full-screen view, and favoriting in the Power BI webpart for SharePoint Online.

Follow these instructions to download and install AdventureWorks sample databases to SQL Server using Transact-SQL (T-SQL), SQL Server Management Studio (SSMS), or Azure Data Studio.

Change Log1.2.0 (2021-05-24)Submitted to AppSource and awaiting approval.New FeaturesAllow Text SelectThe Content Formatting menu now includes a Allow Text Select property, which if enabled, will allow …

I was helping someone recently with an issue. They wanted to allow end users (department managers in this case) to enter data in a table as simply as possible, and then use this data for reporting. The challenge often is, that the easiest way to enter data from a user’s [...]Read More »

Extension for Visual Studio Code - Extension that makes your writing better by taking the recommendations from the Microsoft Writing Style Guide into account.

When you customize SharePoint List Form using Power Apps you would probably prefer to complete it on test environment and them migrate or export to productio...

Importing PowerApps package as a SharePoint list form is not that straightforward as importing a standalone app. Read here how to do it properly.

Learn to deploy a static site to Azure Static Web Apps.

Download your digital copy of our book to learn how to become a more effective data storyteller from 12 data & analytics leaders.

An exponential moving average (EMA) is a type of moving average (MA) that gives a higher weight and importance on the latest data points. An exponentially weighted moving average responds more greatly to recent price changes than a simple moving average (SMA), which uses an equal weight to all obser...

This blog post shows configuring and refreshing data using incremental refresh when comparing Azure Analysis Services & Power BI Premium Per User

Our intake form is opinionated. Years of designing and carrying out analyses has taught me that the more context I have up-front, the better my analysis will be. So, our intake form is designed to …

In this article I will review the Power Apps source code tool, explain its purpose and tell you why its worth checking out.

In this article I will teach you how to build a Power Apps Component with an OnSelect property you can load with your own custom code.

Welcome to my Power Apps guide on how to filter a gallery by a date ...

I strongly believe that it is key to describe everything that you have built as part of your Power BI model. As we all have a hate-love relationship with documenting our work, the external tool tha…

Warren DeanData God of the Week 5/13/2021Warren has been a great partner in contributing to the Data Visualization Guide. Make sure you check it out!Justyna LucznikData Goddess of the Week …

By default, a vertical gallery can only be scrolled one way - vertically. This can be a problem when trying to present data in Excel style and show many

Bottom N Analysis in Power BI

Power BI Bookmarks Tips. Bookmarks are powerful and can improve the reader's experience. However, there are several settings to be aware of.

TBD

This article provides a complete explanation of the behavior of the ALLxxx functions in DAX. When used as filters in CALCULATE, ALLxxx functions might displ