Power BI

Phil sits down with us to walk through his process in debugging a slow Power BI report. This uses some new features in Power BI Desktop as well as using DAX Studio to get further insights. Connect with Phil Twitter: https://twitter.com/PhilSeamark Blog: https://dax.tips/

The Microsoft business applications virtual launch event is almost here! You don’t want to miss this opportunity to get a first-hand look at the new innovations we’re rolling out for Power BI. Register today for this free event, and then tune in to the live stream on October 10, 2019 from 8:00 AM – 9:30 AM Pacific Time.

I have written previously about what is a fact table, and what is the dimension table, and how they relate to each other in a Power BI data model. However, still I see when people use these tables in their model, they get ambiguity of what table should be used for what, and if they…

Power BI and Azure Analytics help businesses build a data-driven culture and drive analytics proficiency.  This has been seen in recent findings from the commissioned Forrester Consulting study, The Total Economic Impact™ Of Microsoft Azure Analytics With Power BI. The study specifies that together, Azure Analytics and Power BI can provide value to customers by delivering an ROI of 271% over three years. 

Microsoft Azure provides compelling, best-in-class tools for data storage, analysis, orchestration, security, and AI. When combined with Power BI, data analytics and outcomes are unmatched.

Patrick shows how you can easily use parameters, for your data source, within Power BI Desktop with minimal clicks. All about reducing the clicks!

The Microsoft business applications virtual launch event is almost here! You don’t want to miss this opportunity to get a first-hand look at the new innovations we’re rolling out for Power BI. Register today for this free event, and then tune in to the live stream on October 10, 2019 from 8:00 AM – ...

This month’s update is filled with major updates across the whole product. In the data preparation area, we’ve introduce query diagnostics, which allow you to see what que…

Whether you want to analyze an individual workspace or your full Power BI environment (all workspaces and solutions you are an admin of), you will find the Power BI Data Dictionary solution invaluable…

October Gateway release

Introduction This is part 1 in a series of articles I plan to write over in the coming weeks regarding the use of Aggregate Tables in Analysis Services databases. Some of the techniques covered in …

In this article, I’m going to describe a technique you may wish to consider to help speed up your Power BI reports. This specific technique is designed to help speed up reports that show comm…

I was recently talking to a potential customer about getting started in Power BI. A question they asked me was essentially “What are the difficult parts of Power BI, how do these engagements usually g…

Whether you want to analyze an individual solution or your full Power BI environment (all workspaces and solutions you are an admin of), you will find the Power BI Model Analyzer solution invaluable. …

Whether you want to analyze your personal “My Workspace” environment, your gateways, or all workspaces and solutions you are an admin of, you will find the Power BI Workspace Metrics solution invaluab…

In the previous article, I have explained what is the key influencers visual and how it works. Later the count and impact have been explained in the other Post. Initially, Key Influencers visual just …

Reporting/Analytics Made easy with FourMoo and Power BI

How to use Power BI Q&ampA to explore your data

Patrick shows how you can make one little change to your Power BI slicers to improve report performance. It’s bananas!

Learn how to create a custom API call to get free stock information for Power BI. This tutorial walks you through how to load data from Yahoo Finance.

The Power BI Desktop Source (PBIDS) File is a file that helps users create files. We built a tool to help with that.. Click here to create PBIS files

Patrick shows you a little known Power BI feature to help your report consumers use every bit of your report. Removing confusion and maximizing use!

The Desired End Result: Compare Two Entities in a Specific Visual Style (Used here for football QB’s, but perhaps useful in other “head to head” comparisons – products, ad campaigns, etc.) Setting the Stage: a “Risk” This is one of those things where I spent a lot of time figuring out how to do something

So how do you design your data model? Do you follow standard practices, or do things your own way? I'm curious to know how you approach this task.

A recent blog on the Power BI website announced the availability of a preview component in Microsoft Flow, which allows to easily refresh a specific dataset. This is good news, because in reality Azure Logic Apps are under the hood of Flow, so this means the refresh capability is now also available

I stumbled across this Reddit post yesterday, discussing the effect that Jérôme Garcès has on Springbok Rugby games. The results are a little scary, and to try and make myself feel a bit better abo…

Introduction Part III in this series looks at another time-based aggregation technique you can add to models. The basic idea of any aggregation table is to generate a summary table the engine can u…