SQL Server Data Tools (SSDT-BI) for Visual Studio 2013 are back and available for download

SSDT-BI were down for almost a month after the release of the SQL Server 2014 causing a lot of frustration to the end users who were trying to develop BI solutions using Visual Studio 2013. No point of getting into the reasons why, let's just take a deep breath and download the latest version here … Continue reading SQL Server Data Tools (SSDT-BI) for Visual Studio 2013 are back and available for download

How to restore your MDS database on a different domain/server and fix the “Access Denied” error

This has happened to me a few times now and every single time I had to spend quite a bit of time sifting through the blogs looking for answers. So I finally decided to document it for myself here. These are the steps: Go ahead and restore the MDS database on the server of your … Continue reading How to restore your MDS database on a different domain/server and fix the “Access Denied” error

Passing parameters to Power View reports in SharePoint to force filter condition

  Here is an interesting article on how to pass a filter condition to a Power View report in SharePoint. One of the biggest complaints that I get as I demo Power View in SharePoint is its inability to save custom preferences for different user groups. In other words, if I have a dashboard built … Continue reading Passing parameters to Power View reports in SharePoint to force filter condition

April Update for Power Map Adds Audio, Clears Confusion

On April 18 Power Map got updated, although if you have a Click-to-Run installed version of Office 365 Pro, you would never know it since these updates are pushed automatically. Here is a link describing the new features, other than some cosmetic updates, ability to add audio to a tour is probably one of the … Continue reading April Update for Power Map Adds Audio, Clears Confusion

Support of Power BI across various versions of Microsoft Office

In this post I wanted to address several general confusions about Power BI and Microsoft Office. Sometimes I wonder if these confusions have been engineered by design or whether they occurred serendipitously… The most important point to understand is that Power BI is intended to be bundled with the Office 365 Pro version of the … Continue reading Support of Power BI across various versions of Microsoft Office

Few thoughts on the SQL Server 2014 launch event in San Francisco

I just finished watching the hosted customer even in San Francisco where the Microsoft CEO Satya Nadella, COO Kevin Turner, CVP of Data Platform Group Quentin Clark and the SQL Server Product Marketing GM Eron Kelly officially introduced the new release of the SQL Server 2014. In this post I am not going to give … Continue reading Few thoughts on the SQL Server 2014 launch event in San Francisco