Category: Power BI

Power Pivot and Power BI
Power Pivot and Power BI
Ebooks

Microsoft PowerPivot is a free add-on to Excel from Microsoft that allows users to produce new kinds of reports and analyses that were simply impossible before, and this book is the first to tackle DAX formulas, the core capability of PowerPivot, from the perspective of the Excel audience. Download 2 Chapters: 8 – CALCULATE() –… READ MORE

Currency Conversion in Power BI Reports
Currency Conversion in Power BI Reports
Blog Posts

Currency conversion applied to reporting can include many different scenarios. Data in multiple currencies, report with a single currency Data in multiple currencies, report with multiple currencies Data in a single currency, report with multiple currencies The rule of thumb is to apply the currency exchange conversion upfront. Therefore, it is a good idea to… READ MORE

Creating a Send-smile-component for Power Apps using Power BI and Application Insights
Creating a Send-smile-component for Power Apps using Power BI and Application Insights
Blog Posts

Early February we released an exciting new feature that enables you to add telemetry logging to your application using Application Insights. That blog post can be found here: https://powerapps.microsoft.com/en-us/blog/log-telemetry-for-your-apps-using-azure-application-insights/ This blog post is a walk through for getting that running specifically for creating a send a smile experience from your Power Apps. You can also find… READ MORE

Power BI Security
Power BI Security
Blog Posts

A common topic I have been discussing recently with customers is the security around Power BI. Basically, how to prevent users seeing data they shouldn’t. So I’ll discuss the various “layers” of security. The Power BI service architecture is based on two clusters – the Web Front End (WFE) cluster and the Back-End cluster. The WFE cluster… READ MORE

New Features Coming to Power BI in 2020
New Features Coming to Power BI in 2020
Blog Posts

In late January, Microsoft published the Power Platform: 2020 release wave 1 plan which lists all the new features that are targeting a release date before the end of 2020. The Power Platform ecosystem currently includes several different products that work reasonably well together and enable “users and organizations to analyze, act, and automate on the data to… READ MORE

Applied Microsoft Power BI- Introducing Power BI
Applied Microsoft Power BI- Introducing Power BI
Ebooks

This book introduces information workers, data analysts, IT pros, and developers to Microsoft Power BI — a cloud-hosted, business intelligence and analytics platform that democratizes and opens BI to everyone. Access Chapter 1: Introducing Power BI here. Book contents: Get insights from popular cloud services on any device! Implement sophisticated personal BI models! Enable team… READ MORE

Power BI – Dynamic Axis
Power BI – Dynamic Axis
Blog Posts

A question I come across in Power BI from time to time is how to configure a report to show an end-user a list of options, and then have visuals in the report use the selected item on the axis. There are a few ways this can get solved, such as using bookmarks. For this… READ MORE