service

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…

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…