Author Archives: Business Intelligist

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 before something else breaks and

Read more

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 choice (running SQL Server database

Read more

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 with geography as one of

Read more
« Older Entries Recent Entries »