Sites Microsoft


Azure Analysis Services processing/refresh sample AMO code

Publié le 25 janvier 2017 sur microsoft sql server support blog
 

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 …

SSAS processing performance gain by using OLE DB provider for Oracle instead of using .NET provider for Oracle

Publié le 25 janvier 2017 sur microsoft sql server support blog
 

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 Prov …

Azure Analysis Services unable to deploy due to lack of credential cache

Publié le 24 janvier 2017 sur microsoft sql server support blog
 

Problem: You may want to deploy an Analysis Services server, and get the following error Either the abc@xyz.com’ user does not have permission to create a new object in ‘servernameservername’, or the object does not exist. Cause: SSDT …

SSAS DirectQuery undocumented limitation

Publié le 24 janvier 2017 sur microsoft sql server support blog
 

Problem: Error received while accessing SQL Server 2016 DirectQuery tabular model using a pivot table   “Query execution encountered an MDX construct that is not allowed on DirectQuery models.”   The models works fine when 4 or le …

Azure Analysis Services DirectQuery known problems

Publié le 24 janvier 2017 sur microsoft sql server support blog
 

Problem: DirectQuery may not work well in Azure Analysis Services Cause: There are product defects that are currently being fixed. Solution: Do not mix DirectQuery and In-Memory partitions in the tabular model in Azure Analysis Services. The whole mode …

Azure Analysis Services cross tenant access

Publié le 24 janvier 2017 sur microsoft sql server support blog
 

Problem: You want to allow user from Azure tenant A to login to an Azure Analysis Services in tenant B. This is called cross-tenant access. Solution: There is a workaround for granting access to users from a different tenant. Say the Azure Analysis Ser …

Azure Analysis Services does not have scheduled data refresh

Publié le 24 janvier 2017 sur microsoft sql server support blog
 

Problem: No schedule data refresh on Azure Analysis Services databases Cause: The current release of Azure Analysis Services does not support scheduled database refresh like Power BI does. You should manage the refresh/processing job just like managing …

Azure Analysis Services gateway may use substantial amount of memory during processing

Publié le 24 janvier 2017 sur microsoft sql server support blog
 

Problem: When you process database on Azure Analysis Services, you may find the gateway process utilize substantial amount of memory. Cause: This is a known behavior. The highest memory I have observed is 11GB. You may find the following exception in t …

Azure Analysis Services database cannot run query while the database is in the middle of a processing/refresh

Publié le 24 janvier 2017 sur microsoft sql server support blog
 

Problem: When you process a database on Azure Analysis Services, you cannot execute queries or run report on the database   Cause: This is a design limitation on Azure Analysis Services in order to conserve memory utilization. This is a different …

Azure Analysis Services shows workspace databases not being deleted

Publié le 24 janvier 2017 sur microsoft sql server support blog
 

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, …

Publié le 24 janvier 2017 sur microsoft sql server support blog
 

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, …

SSAS tabular model know performance problem with Power BI queries

Publié le 24 janvier 2017 sur microsoft sql server support blog
 

Problem: When you create a Power BI report based on a tabular model database, you may find adding a numeric data type column to the report can make the report run much slower, or even causing the tabular model server running out of memory. This can hap …

Azure Analysis Services Preview -How to add security group

Publié le 24 janvier 2017 sur microsoft sql server support blog
 

Problem: You are not able to add a security group as administrator on Azure Analysis Services Preview. The error is below Failed to save modifications to the server. Error returned: ‘The identity ‘DomainGroup’ has invalid identity pro …

Azure Analysis Services connection error “The connection string is not valid”

Publié le 24 janvier 2017 sur microsoft sql server support blog
 

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 …


Pages :