ODBC Connection Error- SSMS
We are getting ODBC/Connection Error for few of the jobs which are running in SSAS. while some other jobs are running fine with the same ODBC Connection. Error: Message Executed as user: NA\ps498921. Microsoft.AnalysisServices.Xmla.XmlaException: The…
SSAS : How to avoid 2 Billion distinct values in a Column limit
Hello All, We have our tabular models with 25+ Billions of records with aggregated fact tables. Recently when we processed our one of fact table, we got the error on a whole number data type column as Error: The 'column' of the 'table'…
SSAS Tabular model 2022 (Disappear specific data import feature)
Hi All, I am unable to find the below feature in SSAS 2022 version, does anyone know how to import specific data into SSAS 2022. The screen below appears when importing data from an existing connection in SSAS 2022. Thanks in advance.
i get an error when connecting sql server using SSMS .
Cannot connect to PANKAJ\SQLEXPRESS. =================================== A connection was successfully established with the server, but then an error occurred during the login process. (provider: SSL Provider, error: 0 - The certificate chain was issued…
EnableCrossDatabaseFolding for SSAS?
Is there any chance this option will be added also to SSAS? I'd like to no longer have to define views just to fake using only one database.
has inline function got any catch?
hi, I heard many people saying "functions are denounced in tsql" is there any catch? q1) need to know what are the cases where we should not use? q2) should we avoid scaler functions also? q3) should we avoid scaler functions if we have to…
unable to uninstall sql server 2019
while uninstalling sql server the below error is popping up kindly help
how to change tabular mode to multidimensional model?
Hi there, I am trying to deploy multidimensional project to sql server and get an error. I was installed a tabular database. How to change tabular to multidimensional? Or I need to reinstall SSAS?
Why can't I connect to analysis services from ssms?
I am getting the below error. Is there something I am missing? Unable to obtain authentication token using the credentials provided. (Microsoft.AnalysisServices.AdomdClient) There was an error parsing WS-Trust response from the endpoint. This may occur…
timestamp manupulation
Hey, here is the table & it contains timestamp at the end. check the output create table customer (CustomerName char(22), ContactName char(22), Address char(22), City char(22) , PostalCode char(22), Country char(22),time DATETIME DEFAULT…
Can Azure Migrate handle other SQL Server components?
Hello, I have just started to work on a migration project for a client that has the current onpremise environment on Win/SQL 2012 and want to replatform (migrate & upgrade) to Win/SQL 2019. They have cubes (SSAS), Reports (SSRS) and SSIS that need to…
json file in sql server
could you please explain how we can load below curly bracket files in sql server when there are multiple unwanted curly brackets are there apart from main data? in this case data is available in till Result only { "Generic": { …
Azure Analysis Server becomes unresponsive if tables are getting processed
We have multiple Power BI reports hosted on a server(S9V2) which has multiple databases. We have been noticing that whenever entities are getting processed, the reports are becoming very slow and even the processing of entities take more time than…
Cannot connect to SQL Management studio 19.3
Hi Microsoft team, I have been trying to connect to the SQL server for a long time now and i have been getting error message cannot connect to.... How can i overcome this challenge?
Partitioning dataset and Refreshing power BI
Hello, We had a dataset with 5 years data, then reduced the size to only 30 months data to improve performance. Now we want to automate Power BI refresh but getting an error: "This operation was canceled because there wasn't enough memory to finish…
We are using windows 2022 server with SQL 2022, the problem is that after sysprep execute ,sql analysis failed with Error:Failed to encrypt sensitive data. Possibly the encryption key is inaccessible because of improper service account change
After upgrade the image to win22 and sql22. Not able to run bam Analysis service getting error Microsoft.BizTalk.Bam.Management.BamManagerException: The BAM deployment failed. ---> Microsoft.AnalysisServices.OperationException: Errors in the…
multiple merge condition
Hey, due to multiple merged condition in same query, it is taking lots of time to run in sql tried partition but did not work . what can be best approach?
permissions to refresh a data model in azure analysis services
I am refreshing a data model in Azure Analysis Services using an Azure Function App (C# .NET 6). I am using the Microsoft.AnalysisServices.Tabular package available at https://www.nuget.org/packages/Microsoft.AnalysisServices.NetCore.retail.amd64. When I…
windows server 2008 and windows 10 and sql server 2000
I have a network around Windows Server 2008, and client workstations under Windows 7 and SQL Server 2000 database applications, everything works well by adding a workstation under Windows 10 and SQL Server 2000 locally it works well, but in network the…