Power BI : Excel Auto Refresh from On Premise SQL Server Data Source in Office 365

Hi! Let's propose this scenario: You have an Excel Workbook that consumes data from a SQL Server Database in your network, like this diagram: In this case, you live happily ever after because your desktop is in the same network of your SQL Server, so you just create your data connection, input the server name,…

2

Checklist when configuring ADFS with SharePoint

Hi everyone! This time, let's summarize a check list if you have to configure AD FS for a SharePoint 2013 environment. The basic steps are well described in the following TechNet article: http://technet.microsoft.com/en-us/library/hh305235.aspx I will just mention things that you should take care of before and during the configuration process. My first recommendation is to…

1

Checklist when configuring Reporting Services for SharePoint 2013

Hi again! Continuing with my series of check lists, this time it's turn for Reporting Services from SQL Server 2012 with SharePoint 2013. The high level steps are: Install SSRS in SharePoint mode (and the add-in) in the farm server you want to be the Reporting Server. Install the SSRS add-in in the remaining farm…

0

Checklist when configuring PowerPivot for SharePoint 2013

Hi everyone! Currently I am in the middle of a deployment with PowerPivot in SharePoint 2013, for the sake of have as much new stuff as possible, at least from the SharePoint end. My scenario looks like this: For the installation the high-level steps are: Install a SQL Server Analysis Services for SharePoint in any…

0