Power BI

For the fifth week in a row, we’re pleased to announce two new features on “New Feature Friday” for Paginated Reports in Power BI. We’ve added support for two new data sources, Oracle and Teradata, and also added the ability to schedule your e-mail subscriptions on an hourly basis. Oracle and Teradata Now Supported We … Continue reading “Oracle and Teradata data source support and hourly e-mail subscriptions for Paginated Reports now available”

<p>Today we have reached a key milestone, and we are happy to announce the general availability of Solution Checker. Since December, when the PowerApps team rolled out the Solution Ch…

Beginning today, we’re starting a pilot program to send regular emails to notify makers like yourself about the usage of their top performing app. This will give regular insights into how an app is performing without having to actively look at its analytics. In this first email, we’ll let you know how many people used … Continue reading “Get updates about your app right in your inbox”

It is no surprise that I’m a huge Power BI fan! Blogging, public speaking, nearly all community stuff I’m doing is related to Power BI. Besides that, I enjoy a beer every now and then. …

Steadily more users are getting interested in Power BI mobile reports, especially when you design reports for executives; they are more interested in mobile view, of course, they do want…

Way back in Oct-2016, Microsoft released a feature in Power BI Desktop that makes the process of creating groups much easier for the average user. I was reminded of this feature by an article by Re…

Last week I posted an article on my personal blog about the infinite loop and it caused quite a bit of discussion in the community. Apparently many

Social media is brimming with several great blogs, videos, documentation and information that I want to keep up on. And there isn’t enough time in a day to watch or read all the awesome conte…

Patrick shows the magic of getting cross-report drillthrough working in Power BI. He teaches you the clicks to getting this going successfully. Demo files: https://guyinacu.be/demofiles

Let's step through a few very simple things that every Power BI new user needs to know. Power BI is a great tool and it's fairly easy to get started but there are a few gotchas that everybody experien…

You should master lists in M/ Power Query, in order to become an M ninja. This post shows you all the basic concepts behind this value type.

This blog post details how dataset memory can affect the performance of Power BI reports being consumed in Power BI Premium

I’m one of those people who can’t resist peeking behind the scenes, and so when the Key Influencers visual appeared in Power BI I couldn’t help wondering how it worked its machine learning magic. Usin…

Employees at Microsoft are now able to use Bing to search internal company resources, log time off, and complete other common tasks without leaving the search engine, thanks to Microsoft Core Services Engineering’s implementation of Microsoft Search in Bing with PowerApps integration. Microsoft Search in Bing boosts productivity by making it easier for employees to find information and manage day-to-day company tasks in one place—and it’s simple to deploy, since it’s an Office 365 add-in.

Video by: Reid Havens Learn about the form and function of the new Power BI workspaces , their release management cycles, and how to deploy these workspaces to users outside of your organization.

We continue to release connectors for Microsoft PowerApps and Microsoft Flow taking the number of connectors available to over 250. As the number grows, we would like to empower the wider community to maintain these connectors. We now open source our connectors on GitHub. Our ability to open source connectors is made possible through two new exciting features: the Microsoft Power Platform Connectors CLI can be used to download, create, or update any custom connector and template-based policies can be used to modify the runtime behaviors for custom connectors.

The most optimal approach when trying to combine, append, consolidate, stack data using Power BI / Power Query for any data source.

Search through all of your tables' columns with my new Table.ContainsAnywhere function instead of being limited to single columns that you have to specify.

This error occurs whenever the DAX engine was expecting a single value, or scalar, and instead received a table of values instead. This is an easy error to make because many DAX functions, such as FILTER, SUMMARIZE and ALL, return table values.

Time intelligence functions oftentimes hide an automatic ALL statement meant to make time intelligence calculations easier. This article describes this beha

Patrick shows you how you can easily create dynamic titles in Power BI Desktop. This became available in the April 2019 release of Power BI Desktop. Demo files: https://guyinacu.bi/demofiles

Power Query has more than 80 data sources supported, and Microsoft Exchange is one of those data sources. Although it is not a new data source, however, the power of this data source combined with the…

In response to last week's post regarding the retrieval of the artifacts (reports, dashboards, datasets) within a premium capacity via the Power BI PowerShell cmdlets, a follow up question from a read…

Get a similar report on your preferred Facebook page here. Related

Cancelling a refresh can take a very long time. I describe a trick that does this in a breeze without loosing your work. Cancel refresh

A few weeks ago I woke up on a Saturday morning with a question notified on my Quora feed: Why do all the BI consultants hate DAX? I was challenged to answe

With the 2019 NFL Draft upon us, of course I wanted to visualize some NFL draft data in Power BI. So I put together this interesting set of visualizations based on some data I scraped from Pro Foot…

In the previous article, you learned the basics of relationships, you learned why we need a relationship, and what is the filtering impact of it across multiple tables. In this article, you will learn about one of the most important properties of a relationship called Cardinality. Understanding what the meaning is of 1-1, 1-Many, Many-1…

The Elizabeth Glaser Pediatric AIDS Foundation (EGPAF) seeks to end global pediatric HIV/AIDS through prevention and treatment programs, research, and advocacy in 19 countries worldwide. The number of new HIV infections among children has declined more than 90% in the U.S. and 70% worldwide. Over its 30-year existence, EGPAF has played a major role in these … Continue reading “How Power BI enables remote communities in Africa to track AIDS”