Power BI

Just a quick post today. Power BI desktop has a feature to turn on the SSAS profile traces that allows you to see all the queries (DAX and SQL in DirectQuery mode) generated by the reports. I could…

Fun with DAX – Sudoku (@PhilSeamark) Custom Web Fonts and Icons in Power BI (@dataveld) POWER BI REPORT SERVER DEVOPS (Trisha McCormick) Automatically expand all fields from a JSON document in Power BI and Power Query (@TheBIccountant) Correct calculate of age in DAX from birthday (@marcorus) BONUS ITEMS: Segmented Filtering with Slicers (@PowerBITips) More Details […]

Today, we're going to start a new series about performing Advanced Analytics and Data Science using Power BI. For those of you who are avid...

In this tip we look at how you can use Power BI to detect data anomalies using various charting methods.

It’s almost here, the first-ever Microsoft Business Applications Summit, coming to Seattle July 22 – 24. Don’t miss out! Register today for two info-packed days of amazing sessions, networking opportu…

Did you know there were Power BI drillthrough updates? In this video, Patrick looks at the drillthrough updates in Power BI Desktop. This includes Keep All Filters which will pass the filters on your …

Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-778 Analyzing and Visualizing Data with Microsoft Power BI certification exam. Exam Ref 70-778: Analyzing and Visualizing Data with Microsoft Power BI offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job.

Column-based calculations are part of every BI project. Some of the most common examples include building a street address column from individual fields, concatenating a person’s full …

From now on I will post some quick tips to help you accelerate your Power BI Desktop development. As the first post of these series, I explain a simple way for hiding multiple columns in Power BI Desktop. To do so: Navigate to Relationships veiew in Power BI Desktop Maximise the table you want to … Continue reading Quick Tips: Hiding Multiple Columns in Power BI Desktop

One of the main financial events for the second half of 2018 is the Federal Reserve's ongoing policy normalization and its impact on asset prices and economic activity. Per the FOMC Communications, th…

It’s almost here, the first-ever Microsoft Business Applications Summit, coming to Seattle July 22 – 24. Don’t miss out! Register today for two info-packed days of amazing sessions, networking opportu…

Power BI June 2018 version, released on: 05th of June - 2.59.5135.421 15th of June - 2.59.5135.601 27th of June - 2.59.5135.781 Here’s the complete list of June updates: Reporting High contrast support for reports Donut radius control Pie and donut detail labels position control Format data labels separately for each measure in a combo ... Read morePower BI – June 2018

Quick Tips: Hiding Multiple Columns in Power BI Desktop (@biinsightnz) Iconography in Design (@AdatisBI) How to handle different decimal separator when importing csv files (@donsvensen) Changing outer…

The Power BI World Tour is back! These value packed two-day events will take place in eight cities over the course of four months. Registration is open – secure your seat today to engage in this local learning opportunity! Whether you are local to the area, traveling from near or faraway, the P...

There are lots of cases you may want to comment/uncomment multiple lines in DAX scripts. You can save lots of development time if you know the shortcuts. Here you go: Select multiple lines of code you want to comment Press Crtl+KC to comment those lines Press Ctrl+KU to uncomment commented lines Mini-tip: The shortcuts … Continue reading Quick Tips: Comment/Uncomment Multiple Lines in DAX Scripts

Get tips and techniques to improve the performance of your Power BI reports and dashboards.

In this Power BI tutorial, Adam looks at 4 ways to get data in Power BI. This focuses on Power BI Desktop and the main storage modes – Import, DirectQuery and Live Connections to Analysis Services. If…

We are aligning the update of PBI Desktop w/ the Microsoft Business Applications Summit: https://t.co/2VxxjXlBSf Using wildcards (*) on all 3 levels of themes can be dangerous for color, as it can start popping up in unexpected places as we add more features that can be colored.— Amanda Cofsky (@MissAmandaN) July 10, 2018

The Tabular Model Schema Reference document introduced a couple weeks weeks ago has been uploaded to a GitHub repository and updated (v1.1) with the following small improvements: Refresh button New Me…

Every now and then this request comes up, I want to sort by a measure that is not part of the visual. Even though it is not “visualization” best practice sometimes the job requires it anyway . So l…

Custom connector to enable OAuth2 authentication for accessing Google Sheets with Power BI. This currently works just for Desktop.

In this video, Patrick looks at Power BI Row-Level Security And where to filter. He found that, after applying dynamic security, customers showed up in a slicer when they should not have. Challenge accepted! He walks through Power BI Desktop to show how he fixed his Row-Level Security problem.

ODBC Tutorial on DirectQuery your custom REST API in Power BI

It is a pleasure to announce the newest version of Power BI helper, version 3.0 July 2018 with the great feature of exporting model documentation. The documentation part of the insight from Power BI H…

Center the X-Axis on a Line Chart (@Seth_C_Bauer) ‘What If’ Analysis Techniques For Power BI (@Enterprise_dna) Happy Birthday Power Query (@ExceleratorBI) Power BI Service and Mobile June Feature Summ…

This article describes the differences between report-based tools and model-based tools. Because Power BI is a model-based tool and not a report-based tool,

Problem: Consider the following Power BI report that shows the sum of ResellerSales[SalesAmount] by SalesTerritory[SalesTerritoryCountry], Employee[FullName], and ResellerSales[SalesOrderNumber]. This…