Category: Power BI

Hybrid Tables (In Power BI) Q&A

Are Hybrid Tables tied to a developer license type? No. Incremental Refresh and Hybrid tables are tied to workspace (dataset) type. They are set up in Power BI Desktop. A developer must have Pro or Premium Per User (PPU) license to publish the report to the service. See the next two paragraphs for workspace (dataset) … Continue reading Hybrid Tables (In Power BI) Q&A

Use PowerShell to download all your Power BI reports from a workspace

You can use PowerShell to download all of your PBI reports in a workspace all at once without having to go through the PBI service UI one at a time. As an added bonus, you may notice that downloading a report with PowerShell is faster that downloading it through the PBI Service UI. This script … Continue reading Use PowerShell to download all your Power BI reports from a workspace

How much can you save by splitting Date Time columns into separate Date and Time columns in Power BI models?

As you may have already heard, one of the easiest ways to reduce a Power BI model (dataset) size is by splitting DateTime columns into separate Date and Time columns but the question is how much space reduction can you achieve by doing so. As I show in this blog post, the reduction can be … Continue reading How much can you save by splitting Date Time columns into separate Date and Time columns in Power BI models?

I will be speaking at #DataWeekender on Saturday May 2nd.

I will be presenting "Using Power Apps in Power BI reports: Enabling writeback". Join me to learn how to build a simple Power Apps app that can be integrated into a Power BI report to update data and have it refresh the Power BI report automatically after the data updates to reflect the changes. Register … Continue reading I will be speaking at #DataWeekender on Saturday May 2nd.

Aggregations and Time Series calculations in Power BI

I have received a couple of questions about Aggregations in Power BI and whether they can be used to cover time series calculations such as Year to Date, Quarter to Date, and Month To Date. The answer is yes. Since time series calculations break down into calculations over a series of days, an aggregation table … Continue reading Aggregations and Time Series calculations in Power BI

Aggregation Precedence in Power BI: How does Power BI choose between candidate aggregation tables with the same Precedence?

Precedence is one of the aggregation properties that you can define on an aggregation table in Power BI. In a model with multiple aggregation tables, you can use Precedence to define the order in which aggregation tables will be considered by Power BI to answer queries. The higher the Precedence number, the sooner the aggregation … Continue reading Aggregation Precedence in Power BI: How does Power BI choose between candidate aggregation tables with the same Precedence?

Aggregations in Power BI

Aggregations became generally available in Power BI in July 2019. Aggregations are a modeling optimization technique that can improve user experience when dealing with large datasets. Combined with Power BI composite models, they make it possible to analyze big datasets efficiently by allowing high level analytical queries to be answered from memory while sending more … Continue reading Aggregations in Power BI

A simple Power BI report to help you choose which PASS Summit 2019 activities to attend.

PASS Summit 2019 is about to start. There are many social ane educational events during this week. You can find a complete list here. It is somewhat difficult to get an overall look of events per day. I put together this simple PBI report to get a list of events by day/time/sponsor. Here is a … Continue reading A simple Power BI report to help you choose which PASS Summit 2019 activities to attend.