Power BI

Yesterday there was a webinar on how Power Query is going to be used as the way to load data into the Microsoft Common Data Service. You can watch it online here (if you’re in a hurry, skip to 24 m…

Today, I am excited to announce the availability of usage metrics in the Power BI service for dashboard and report authors. This feature gives you one-click access to key usage metrics for your dashboards and reports, allowing you to pinpoint how your end users are interacting with your content. We hope these metrics can help you justify your investments and prioritize your efforts on the most impactful, widely used content.

It has been a busy week with the start of another month leading into June, so here are the updates. I am pretty confident that with the Microsoft Data Insights Summit happening Monday & Tuesday…

Last week Power BI team had announced a new feature in the Power BI service – Usage Metrics of Reports and Dashboards. Read more here. While many additional great features were announced here (and each deserves a dedicated focus), I wanted to share today why and how you can take advantage of the Power BI Usage Metrics. Keep …

A blog from the SQL Server Reporting Services product team at Microsoft.

I'm a big fan of reusing Power BI datasets whenever possible to minimize redundant datasets floating around the organization. It's less maintenance, less chance of calculation differences, and less data refreshes to schedule. And, this technique is a way to separate who handles report creati

Many of you may know of our wonderful business partners over at PowerON. Among the services and software they offer is a powerful tool called Power Update

A few months ago we released a Preview of the Amazon Redshift connector in Power BI Desktop. This new connector allows users to easily build reports based on their Redshift data, either by importing the data into Power BI Desktop or by using DirectQuery mode. Today we are very excited to announce support for Redshift-based reports in the Power BI Service, allowing users to publish their reports to unlock seamless consumption of reports & dashboards based on Redshift data. In this blog post, we will show you step-by-step how to accomplish this task.

A blog from the SQL Server Reporting Services product team at Microsoft.

New capacity-based Power BI offering helps organizations expand access to insights. Power BI Premium builds on the existing Power BI portfolio with a capacity-based licensing model that increases flexibility for how users access, share and distribute content. The new offering also delivers additional scalability and performance to the Power BI service.

Using the “demo” database, which I described in Part 1 of this set of blog entries, I have created a number of sample reports using Power BI Desktop for various areas of the Financial Services Division of a fictitious company, ABC Automotive Ltd. The “demo” database, together with other data, were imported into Power BI Desktop and, where … Continue reading "Power BI – ABC Automotive Ltd. (Part 2 – Financial Services Reports)"

There has been a variety of updates and blog posts in the past week, so here are my BI updates. Power BI – Service March Update There were quite a few service updates for March within the Power BI …

In today’s post, I am going to be associative a bit, and explore the latest Power BI Desktop along several topics that I’ve wanted to share. We will cover the best features of Power BI Desktop April update: Power BI Service Live Connection and Add Column by Example (also known as Column From Examples in the UI). Finally, …

Today, I am excited to announce the view related content feature in Power BI service. Now, users will be able to easily jump between related dashboards, reports and datasets.

There has been a whole host of updates to Power BI in the past week which is great to see, so I hope that you enjoy reading this as much as I enjoyed putting it all together. Power BI – March Deskt…

VertiPaq Analyzer is useful to analyze VertiPaq storage structures for a data model in Analysis Services Tabular. A complete description and short tutorial

This just in from the Reporting Services product team: “Power BI reports in SQL Server Reporting Services: January 2017 Technical Preview now available”  This feature addition will allow Power…

Newly added to the Power BI Service is a much awaited feature called Power BI Subscriptions. If you’ve worked in Microsoft BI in the past this idea is likely familiar to you. This new feature share…

A blog from the SQL Server Reporting Services product team at Microsoft.

Last Friday’s big news was the release of the first CTP for Analysis Services v.next. Among several major new pieces of functionality (Ragged hierarchies! Drillthrough that works properly, even for…

A blog from the SQL Server Reporting Services product team at Microsoft.

A modern Service Desk is driven by data. It has a huge amount of data, but that data is very hard to grasp for the human mind. The smart Service Desk Manager visualizes this data to make it

As Power BI is maturing for organisations using Office 365, the responsibility to monitor usage and administer Power BI was in the hands of Office 365 Global Administrator until now. Power BI team

There were already written few blog posts both about Row Level Security. I would like to add one more about this topic. I use this pattern for several years in SQL Server Analysis Services. Biggest

Experienced Analysis Services and Power Pivot developers will know all the interesting things you can learn from DMV queries. For example, in this blog post Kasper de Jonge shows how to use a DMV t…

Today we will learn two simple methods to import ongoing Twitter data to Excel & Power BI. The methods will take advantage of Microsoft Flow and Zapier, two workflow automation services that will allow us to easily import new tweets into an Excel workbook on OneDrive for Business. The Excel file will be updated whenever a new …

Happy Saturday to all! As you may have noticed, I haven’t posted on my personal blog in some time (although I have been posting over at the SQL Server Reporting Services team blog fairly regularly)…

Professional BI developers using Analysis Services and advanced users working with Power BI share a common pain. Their productivity editing a large data mod

One of the coolest new features in SSAS Tabular 2017 and Azure Analysis Services is the integration of Power Query and M for data loading. Over the last year or so the Analysis Services team blog h…