With the release of the Power BI Gateway, it is now possible to publish specific data sources for the entire organization. The gateway works in both live connect (data stored… Continue reading Power BI Enterprise Gateway and SSAS – What Account Should You Use?
At the moment (July 2015), SQL Server Analysis Services (SSAS) data has the widest range of connection options in Power BI. This is a good thing, but the flip side… Continue reading Connecting to Analysis Services in Power BI
It is fairly well known that ever since SQL Server 2012, users have been able to install SQL Server Analysis Services (SSAS) in one of two modes – either “Multidimensional… Continue reading Analysis Services Power Pivot Mode in SQL Server 2016
Using Excel Services, SharePoint users have been able to share workbooks that are connected to back end data since SharePoint 2007. Typically, the connection is made to SQL Server, or… Continue reading Schedule Data Refresh for SSAS Connected Excel Workbooks with PowerPivot for SharePoint
One of the more powerful features in the new Power BI preview is the ability to connect your Power BI dashboard to an on-premises instance of SQL Server Analysis Services.… Continue reading Something Went Wrong When Connecting Power BI to SSAS