Power BI

I am showing how using the Power BI Community I enabled someone to be able to hide the filter when running a Power BI report in full screen

In this part of the series we will look into the different Analyze options of Power BI. Previous part of this series can be found here. Explain the Increase/Decrease This is the first type of the Analyze features. If your visual is containing a date dimension than by right clicking on any point you will […]

There are a lot of discussions these days around Power BI tools to create reports and for sure many of you may have already downloaded and worked with some of them if not all of them. You may also already thought that some of the tools’ names are confusingly similar. I recently had an interesting … Continue reading Power BI Ecosystem Report Authoring Tools Demystified

Reading Time: 2 minutes If you use Power BI Desktop regularly, you might notice an occasional reference to CefSharp. Unless you’re in web or application development or already familiar with Chromium, the following general information could be helpful. You are probably familiar with the popular web browser Google Chrome. The Chrome browser is based on Chromium, an open-source project…

This post shows you how to use Power BI drillthrough filters & how to reset them to either display all data or to select a new item to filter.

Patrick shows you how you can clear the Power BI Desktop model cache when troubleshooting DAX performance.

You’ll notice one of our exciting updates right away when creating new reports with the September update of Power BI Desktop, a new, modern default theme! Not only do we have a new default theme, but we’ve more than doubled the number of built-in theme options for your report. If you’re a theme author, potentially more exciting are the updates to our theme JSON format which make it much quicker and easier for you to create your own custom themes that significantly change the look and feel of your report. Thanks to an intern project, we’re also releasing a frequently ...

When you work on real-world projects in power BI, you would probably have different environments Like DEV, UAT, Pre-Prod and Prod. It is important for you and your audience to know what the data is coming from. Am I looking at Dev or UAT data or I am actually looking at real data in Production … Continue reading Good Practice: Always Display the Reporting Environment

If you find yourself clicking the same button in the Power BI Desktop you might find this little tip useful. When you right click a button in the ribbon – you can add it to the Quick Access Toolbar…

Patrick looks at native query and why you should be careful when using it in Power BI. He looks at what native query is, what to consider when using it, and how to monitor what query folding, in Power…

Stock-type indicators are more complex to calculate than purely additive-type indicators. The most important point to consider is that each calculation has its pro and cons, and choosing the “best” approach will depend on these parameters.

We have plenty of resources to get ready for the upcoming release wave with confidence. Learn more about the upcoming Power BI features included in 2019 release wave 2 with our new overview video and guide, and understand key milestones in this process.

In 2015 I released the first version of VertiPaq Analyzer, a tool to quickly analyze the structure and data distribution of a Tabular model that can be used

September release of Gateway

Patrick looks at other tools you can use against the Power BI Desktop diagnostic port besides DAX Studio. From clearing the model cache, to getting other information, this is a handy way to look at your Power BI Desktop file. PowerShell – Get Diagnostic Port Clear Model Cache XMLA Download SQL Server Managment Studio

In my last post I showed lots of examples of how Power BI’s new custom format string feature can be used to format numbers. This post, looking at dates and times, will be a bit different for two re…

The Power BI REST API provides lots of data for Power BI admins. Easily import and monitor this data in Power BI with a Power BI REST API custom connector:

Learn how to use a custom color palette, and apply it to an entire report in Power BI Desktop

I have previously written how to create a ragged hierarchy, which can be used for organization hierarchy or chart of accounts or similar scenarios. A ragged hierarchy is a hierarchy with un-even number of levels. In a parent-child scenario of organization hierarchy, for example, the CEO is the highest level of the organization, so won't…

We’re happy to announce our September 2019 update of Power BI Report Server! This release is packed with tons of reporting features, including visual level filters for slicers, Icon sets, grouping for visuals, new default themes, and more! In this release, you will also see the new updated design, the new filtering experience, and more conditional formatting options. Read on to learn more about the new features and many other capabilities in this release.

Table of Contents1 Which part is slow?2 Tuning the data refresh2.1 Verify that query folding is working2.2 Minimize the data you are loading2.3 Consider performing joins in DAX, not in M2.4 Review your applied steps2.5 Make use of SQL indexes3 Tuning the model calculations3.1 Use the Power BI Performance Analyzer3.2 Confirm that the storage engine … Continue reading A comprehensive guide to Power BI performance tuning →

As report authors we sometimes get caught up in how easy it is to create a report and provide value to the business. Each report [...]

Power BI Training Content http://aka.ms/PBItraining The Power BI engineering team develops and maintains several workshops and classes that are available to our partners and community leads for free to help them to train their customers and communities on Power BI. Every class will include all mat...