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…

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

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…

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

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…

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.

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.

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

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…

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…

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…

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…

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…

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…

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

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…

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…

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…

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.

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 …

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.

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.

Official News from Microsoft’s Information Platform

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 […]

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…

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

At some point this weekend, the Microsoft Power BI folks turned on the drillthrough feature in the Power BI service. This is the same drillthrough feature that demonstrated during day 1 of the Micr…

(Ideally, I would like to do this as a Power BI custom data connector. I have tried, for some reason, my Visual Studio has been crashing when I click on…