Power BI

The Man, The Myth, The On-Prem Server Guy… (@PowerPivotPro) M QUERY EXTENSION FOR VISUAL STUDIO CODE (@BrettPowell76) Walk Through Of Many Ranking Techniques using DAX in Power BI (@Enterprise_DNA) Power BI Desktop October Feature Summary Power BI Service and Mobile September Feature Summary BONUS ITEMS: Offline model editor experience for Power BI (@marcorus) Data types […]

Official News from Microsoft’s Information Platform

We’re glad to announce that it is now possible to use Single Sign-On, leveraging Kerberos, when connecting to certain data sources using DirectQuery mode from Power BI.

Learn how you to enable data-democratization within your organization, as well as provide a tool for your power users to maintain data quality in their reports.

One of the really cool features contained within the PowerBI.com service is the ability to monitor how often your dashboard or report is being viewed. You’ll find this feature by opening up …

There has been a lot of interest in the analytics community to be able to visualize the output of an Azure Machine Learning model inside Power BI. To add to the challenge, it would also be great to operationalize Azure ML models through the Power BI service. Imagine you could have Power BI regularly bringing in the latest output of your fraud model or the sentiment for recent Tweets about your products. The following tutorial will outline a proposed approach for doing just that.

When it comes to writing, I have the least trust in my writing skills. I always wanted my blog to sound more like a personal journey than some docs, whenever…

Between sessions at the PASS Summit, I had the privilege of interviewing Alberto Ferrari and Marco Russo; SSAS Maestros and BI industry thought leaders. Alberto and Marco are revered as expe…

A while back you may have caught my blog post introducing the Power BI Chat Bot 9000. Since posting that blog, I’ve received a lot of requests on the steps required to build the bot. The good new i…

Today I published an extension for Visual Studio Team Services (VSTS) that gives you the ability to deploy PowerBI files (pbix) to PowerBI.com

Detail Rows in Power BI Let’s say you have an Analysis Services 2017 (1400 CL) model and you’ve implemented several detail rows expressions to help users drill into the details of their…

One of the new features in Reporting Services 2017 is the new REST API. The announcement is here: And the online documentation for the API is here: Interestingly, the new API seems to be OData comp…

Object-level security is one of the significant new features introduced for SQL Server Analysis Services 2017 and Azure Analysis Services. With object-level security, you have row-level security an…

With the February Power BI Desktop and a recent companion Service update, you now have the option to add a customized collection of visuals for users. Companies may easily distribute their own or t…

The Power BI service and mobile team is thrilled to kick off the first feature summary blog for 2018! With a new year in full swing, we’ve been hard at work on features to make it easier for you to…

Announcing Visual Studio Team Services (VSTS) Solution Template Blue Margin, Inc., Microsoft Gold Partner in Data Analytics and Data Platform just released a VSTS solution template to provide project…

This article describes a reference Date table in DAX using a Power BI template. The same technique can be used in Analysis Services models. Download the lat

The Power BI Service (PBIS) is designed to make your life easier. Save your file locally, let it sync to SharePoint Online, track versions, and publish the app after the report is refreshed.

Power BI Report Server is an on-premises product based on the SQL Server Reporting Services (SSRS) framework which allows hosting, sharing, and collaborating on Power BI Reports, all behind your organization’s firewall.

In some cases, you might not want to give all users access to all measures in your model – you might not want to show the profit to certain users. In the Power BI Desktop designer/Service we can…

When purchasing Power BI Premium, you get the best of both worlds when it comes to reporting – Power BI Service and Power BI Report Server. Power BI Service gives you all the functionality of Power BI and cloud reporting while Report Server allows you to continue to host reports behind your firewall

After getting back from the MVP Summit in Bellevue, which was an incredible experience the Power BI team has been extremely busy getting some great new features out the door. Which means there is q…

Last week I got involved with a customer issue. A refresh of the data imported to a PBIX always works in Power BI Desktop, but the refresh operation intermittently fails in the Power BI Service. Their workaround had been to refresh the PBIX in Desktop and re-upload the file to the Service. This post

It’s time again to recap all the features and announcements in Power BI service and mobile in the month of February. Here’s what we released: Automatically install apps, P4 and P5 capacities on Premium…

The feature you have all been waiting for is finally here. Today, I’m thrilled to announce the general availability of persistent filters in the Power BI service. All Power BI reports will now…

The other day, one of my enterprise customers asked me if there were any guides or documentation to forecast the cost for Power BI service licensing (Pro and Premium) for 3 years based on user grow…

Power BI Service and Mobile February Feature Summary Announcing Persistent Filters in the Power BI Service Share your Power BI content with anyone by email Power BI Desktop March Feature Summary Power BI for Mixed Reality app now available in Preview BONUS ITEMS: BI Bake Off at Gartner Data and Analytics Summit 2018 On-premises data […]

New capability reduces the time, complexity and cost of extracting intelligence from disparate data sources.