When you inadvertently set SQL Server’s ‘max server memory’ to a very low value, you may experience one or more of the following symptoms: SQL Server cannot be started (from a tool like configuration manager) and the following message is logged in the SQL error log:”An internal query can’t be executed due to inefficient…

I have worked on a few cases with this problem. You are not able to start more than 4 SSAS tabular model instances with default configuration settings. The 5th tabular model instance just cannot start unless one of the first 4 instance is stopped. This is an interesting problem. I found after installing 4 SSAS…

Excel 2016 PivotTable report may generate an error message after running the report for 1 minute. The connection timeout was exceeded. This problem only happens if you have the build number 11.0.9167.412 of the SSAS OLE DB Provider shipped in Excel 2016 update. You can check the following files and see if the version is…

Excel 2016 PivotTable report may generate an error message after running the report for 1 minute. The connection timeout was exceeded. This problem only happens if you have the build number 11.0.9167.412 of the SSAS OLE DB Provider shipped in Excel 2016 update. You can check the following files and see if the version is…

We have 2 customers getting an out of memory error when they backup or restore a large tabular model database. �   In the case of restoring a database backup, it is a 300GB .abf file restore on an SSAS server with 1TB of memory. When all the files are extracted to the data folder, the…

Problem: When you open Excel 2016, go to the Power Pivot tab, click the Mange button to bring up Power Pivot window In Power Pivot, click Get External Data, choose From Other Sources Choose Microsoft Analysis Services. Click Next Fill in the SSAS server name, then click Next,   Click on the Design button, you…

Problem: Teradata can accepts authentication of different types. Teradata can authentication user credentials from local accounts, LDAP, or Active Directory. Local account is probably the easiest to create, but hard to manage. If there are hundreds or thousands of users who need access to Teradata database, the local account method is very difficult to manage…

Recently I worked on a Power BI case. The Power BI Personal Gateway fails to install. The error is Service ‘Data Management Gateway Service’ (DIAHostService) failed to start. Verify that you have sufficient privileges to start system services. In the log file, you may see the following message Error 1920. Service ‘Data Management Gateway Service’…

Note: Power BI software is updated frequently. This is written based on the Power BI Personal Gateway released in August 2015. Power BI Personal Gateway allows refresh of data models stored in Power BI that connects to an on premise data source. Power BI support has 2 documents on how to install and troubleshoot this…

After the introduction of the StringStoresCompatibilityLevel property in SSAS dimension after SQL Server 2012, SSAS database designer may try to create a MOLAP dimension with more unique values than what is allowed in previous SQL Server versions. The article Configure String Storage for Dimensions and Partitions has a very good documentation of this property. The…