All the tools, SSMS, SSDT, and Power BI Desktop share the IE cookies cache that stores the Azure Analysis Services login credential. If you need to login using a different credential, and the tool does not provide an interface to put in a different credential, you can clear the IE cookies Please go to Internet…
Azure Analysis Services – How to switch to a different user account in reporting tools
All the tools, SSMS, SSDT, and Power BI Desktop share the IE cookies cache that stores the Azure Analysis Services login credential. If you need to login using a different credential, and the tool does not provide an interface to put in a different credential, you can clear the IE cookies Please go to…
Azure Analysis Services processing/refresh sample AMO code
Sample code to process object in Azure Analysis Services Visit this web page Data providers for connecting to Azure Analysis Services, URL is https://docs.microsoft.com/en-us/azure/analysis-services/analysis-services-data-providers At the bottom of the web page, download then install AMO. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Threading.Tasks; using Microsoft.AnalysisServices; using Microsoft.AnalysisServices.Tabular; namespace AMOAzureASProcess { class Program…
SSAS processing performance gain by using OLE DB provider for Oracle instead of using .NET provider for Oracle
Problem: You are unable to change the size set parameter in the data source of an SSAS model that gets data from an Oracle database Cause: Oracle .NET provider may not support the property you want to set Solution: Switch to user the Oracle OLE DB Provider. It may support additional properties that are not…
Azure Analysis Services Preview shows workspace databases not being deleted
Problem: You may see Analysis Services tabular model workspace databases remain on the Azure Analysis Service server. Cause: When you create a tabular model in Visual Studio, you choose the Azure Analysis Services server as the workspace server, and the default Workspace Retention property is set to Unload from Memory. The workspace on Azure Analysis…
Azure Analysis Services Preview -How to add security group
The information posted originally in this blog is now out-of-date due to change in the Azure products. Please open a new support case if you need help with adding security group in Azure Analysis Services. Security group now can be added in format obj:<objid>@<tenanted> using SSMS or AMO. Problem: You are not able to…
Azure Analysis Services connection error “The connection string is not valid”
Problem 1: When you try to design an SSRS report to get data form an Azure Analysis Services server, you may get an exception when you try to preview the report Cannot create a connection to data source The connection string is not valid Problem 2: You cannot see the list of database when you…
Client unable to establish connection.. error when you configure ‘max server memory’ to a low value
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…
You are not able to start more than 4 SSAS tabular model instances with default configuration settings
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 timeout error on SSAS data source after 1 minute
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…