SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,730 questions
1 answer
One of the answers was accepted by the question author.
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?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 13%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
1 answer
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…
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
438 questions
Azure Functions
Azure Functions
An Azure service that provides an event-driven serverless compute platform.
4,276 questions
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,384 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,244 questions
asked 2024-02-19T11:10:09.8366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 73%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMP%3C/text%3E%3C/svg%3E)
Muhammad Pathan
25
Reputation points
commented 2024-02-26T08:22:59.33+00:00
PRADEEPCHEEKATLA-MSFT
77,336
Reputation points Microsoft Employee
1 answer
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…
asked 2024-02-17T18:17:27.0266667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 59%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAM%3C/text%3E%3C/svg%3E)
alaya mohsen
0
Reputation points
commented 2024-02-19T03:19:42.02+00:00
ZoeHui-MSFT
33,051
Reputation points
1 answer
Unable to connect to localhost in Visual Studio 2019 (tabular model designer)
I want to create Tabular Project in Visual Studio 2019. After opening Visual Studio 2019 i click on "Create New Project". Then i had clicked on "Analysis Services Tabular Project". Then configure new project and when i was about to…
asked 2024-02-17T16:48:59.9966667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(160, 78%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAP%3C/text%3E%3C/svg%3E)
Amey Pathare
0
Reputation points
commented 2024-02-17T18:25:40.6033333+00:00
Amey Pathare
0
Reputation points
3 answers
One of the answers was accepted by the question author.
Building a super-efficient incremental refresh process in SSAS
Suppose I have 2 years time entry data (~25M rows) by employee and day and project etc. At any point of time any rows within those 2 years can change (new rows added, existing rows modified or potentially some rows deleted too). The number of rows…
asked 2024-02-08T12:49:26.9366667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 53%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVD%3C/text%3E%3C/svg%3E)
Vivek Devalkar
122
Reputation points
accepted 2024-02-14T14:14:07.2433333+00:00
Vivek Devalkar
122
Reputation points
1 answer
Unable to open the Tabular Model Designer due to Access denied.
Hi, Last few weeks we had encountered an issue where all our cube was not able to be opened with an error access is denied. Besides that, we have also tried to open a cube from our local repo which also showed an error where access is denied. We have…
asked 2023-10-17T04:02:51.9066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 65%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENM%3C/text%3E%3C/svg%3E)
Nurshara Mazlan
0
Reputation points
answered 2024-02-13T02:29:09.3133333+00:00
Greg Low
1,495
Reputation points Microsoft Regional Director
1 answer
Is there any way to set a latitude and longitude attribute type for a dimension?
I am trying to connect from Power BI to an Analysis Services Cube (2016) using the live connection and a map visualizer. Is there anyway to define the latitude and longitude in Visual Studio for the dimension attribute so Power BI picks it up? I notice…
asked 2023-10-31T19:35:42.0066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 15%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAH%3C/text%3E%3C/svg%3E)
Andrew Hopkinson
6
Reputation points
answered 2024-02-12T11:37:38.04+00:00
Greg Low
1,495
Reputation points Microsoft Regional Director
1 answer
SSAS tabular cube occupies RAM dynamically depending on server RAM size
I have an SSAS tabular cube deployed on 2 servers. One server is having 512GB RAM (server1) and the other has 256GB RAM (server2). When we check the Memory details on task manager on both the servers, it shows 110GB (of 512GB) as occupied RAM on server1.…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 76%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVA%3C/text%3E%3C/svg%3E)
0 answers
Error While a partition is processed: "The JSON DDL request failed with the following error: The server sent an unrecognizable response.;Root element is missing"
We got this error when it was processing a tabular model partition in SSAS from an SSIS package. This is the JSON that process the partition: { "refresh": { "type": "full", "objects": [ { "database":…
asked 2024-01-10T18:43:53.01+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(6.4, 24%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIA%3C/text%3E%3C/svg%3E)
Irama Abello Moreno
0
Reputation points
commented 2024-02-12T10:47:41.44+00:00
Greg Low
1,495
Reputation points Microsoft Regional Director
1 answer
Question on Dimension Security in SSAS cubes
Dear Team, Looking for help on below technical knowledge. This question is for MSBI - "SQL Server Analysis Server " Is it possible to create a security for entire dimension in "dimension data" tab of "Roles" window. For…
asked 2024-02-08T16:43:40.5433333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 43%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPP%3C/text%3E%3C/svg%3E)
Prema Prabhu
0
Reputation points
answered 2024-02-08T19:55:55.2566667+00:00
Olaf Helper
40,816
Reputation points
1 answer
Get list Administrators - DISCOVER_XML_METADATA
Hi, Running an XMLA script to get all administrators of SSAS. See below. Do you have to be an administrator to run this script or is it possible to give the user that runs the script another role/access that do not give that user admin rights, but the…
asked 2024-02-08T13:03:27.45+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 69%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
Stefan
191
Reputation points
answered 2024-02-08T18:49:02.3566667+00:00
Javier Villegas
895
Reputation points MVP
1 answer
SSAS : Errors in the metadata file - error trying to update cube in a system table 'DataSource'
0 A few days ago, we started having an error with the processing in our cube. The cube is being processed by the job and returns the error: The following system error occurred: Invalid data. Failed to decrypt sensitive data. Possibly the encryption key…
asked 2023-01-11T19:12:32.4166667+00:00
Ricardo Castro
0
Reputation points
commented 2024-02-02T10:30:15.6133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 40%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKA%3C/text%3E%3C/svg%3E)
Kasireddy Alekhya Alekhya (MINDTREE LIMITED)
0
Reputation points
1 answer
VS solution cannot open .bim value of '311' is not valid
I have a VS solution tabular model .bim that has been created and deployed to our production and development environment. The data is being processed nightly through Azure. HOwever, I am now not able to open the .bim in the solution. I receive the…
asked 2021-04-26T14:52:40.99+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 4%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETD%3C/text%3E%3C/svg%3E)
Tina Douglass
1
Reputation point
commented 2024-02-01T09:02:12+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 55.00000000000001%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jürg Jenny
6
Reputation points
1 answer
Getting field datatypes from an SQL Analysis Services MDX SELECT query using .NET AdomdClient
Getting field datatypes from an SQL Analysis Services MDX SELECT query using .NET AdomdClient yesterday Let's say I have this MDX query against SQL Server's Analysis Service Adventure Works sample: select [Measures].[Customer Count] on columns,…
.NET
.NET
Microsoft Technologies based on the .NET software framework.
3,384 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,244 questions
asked 2024-01-17T07:12:10.8133333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 93%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Miha Markic
0
Reputation points
commented 2024-01-26T09:35:12.6933333+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(64, 85%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJX%3C/text%3E%3C/svg%3E)
Jiale Xue - MSFT
31,981
Reputation points Microsoft Vendor
3 answers
One of the answers was accepted by the question author.
error message om ssas
In my SSAS im getting the below message Errors related to feature availability and configuration: Exceeded the maximum number of partitions in a measure group. any suggestions on how to fix this?
asked 2024-01-17T15:22:15.48+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(294.40000000000003, 95%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZS%3C/text%3E%3C/svg%3E)
Ziya Scarlet
20
Reputation points
answered 2024-01-18T14:47:00.3466667+00:00
Pinaki Ghatak
2,320
Reputation points Microsoft Employee
1 answer
SSIS package is not opening
I am getting issue while opening any package in SSIS. The task with the name “SQL – Get Last Run Date” and the creation name “SSIS.ReplacementTask” is not registered for use on this computer. Contact Information: Execute SQL Task; Microsoft Corporation;…
asked 2024-01-17T09:11:57.8166667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 2%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMS%3C/text%3E%3C/svg%3E)
Manish Singh5
0
Reputation points
edited an answer 2024-01-18T02:15:02.94+00:00
ZoeHui-MSFT
33,051
Reputation points
1 answer
Problems opening a tabular model file in different computer where it was created (localhost issues)
Hi! I have been working with analysis services for years (both olap and tabular). In the past, I was able to share the original files of a tabular model with my team members. I found that when someone different from the creator tried to open the file,…
asked 2023-12-14T08:12:44.9666667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 98%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
Dani
0
Reputation points
commented 2024-01-12T18:28:12.9066667+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How do I change SSAS 2022 default compatibility level from 1200 to 1500
I installed SQL Server Analysis Enterprise 2022 and the default compatibility level is 1200. How do I change it to 1500? Thanks for the help!
asked 2024-01-03T14:03:15.0066667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 88%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Shaw, Bryan
20
Reputation points
accepted 2024-01-12T13:56:06.0166667+00:00
Shaw, Bryan
20
Reputation points
3 answers
One of the answers was accepted by the question author.
An error on ssas
Hi. When I use SSAS, an error occurred. Errors related to feature availability and configuration: Exceeded the maximum number of partitions in a measure group. Why? How can I fix this? Thanks a lot.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 55.00000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EL%3C/text%3E%3C/svg%3E)
2 answers
Visual Studio 2019 (SSAS) - Error when trying to open my model
The backstory: I work with SSAS and a tabular model via a VDI. The connection with my VDI went wonky and now there is a disconnect involving my tabular model. I'm only trying to open my tabular model (.bim) via SSAS, and I keep getting the error that…
asked 2022-08-17T22:03:59.19+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(304, 12%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETY%3C/text%3E%3C/svg%3E)
Tanner Yatsko
11
Reputation points
commented 2024-01-04T21:21:38.0866667+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(176, 48%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDP%3C/text%3E%3C/svg%3E)
Dmitrijs Pilāts
0
Reputation points