Azure SQL Database
An Azure relational database service.
5,199 questions
1 answer
"An operation that uses the database driver could not be completed. If the driver is a Microsoft driver, make sure the driver file isn't damaged, and if it is, reinstall the driver by reinstalling Microsoft Query."
One of the users receive this error. is this issue at our end or at microsofts ?
asked 2023-10-25T20:03:28.8633333+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, 5%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EZA%3C/text%3E%3C/svg%3E)
zubaid ahmed
0
Reputation points
commented 2023-10-26T08:47:18.04+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, 4%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
ShaktiSingh-MSFT
13,826
Reputation points Microsoft Employee
2 answers
无法连接到 http://localhost/olap/msmdpump.dll。
The connection either timed out or was lost. (Microsoft.AnalysisServices.AdomdClient) 响应状态代码不指示成功: 405 (Method Not Allowed)。 (System.Net.Http)
asked 2023-10-24T03:32:10.47+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(185.6, 0%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFQ%3C/text%3E%3C/svg%3E)
feng qiu
0
Reputation points
commented 2023-10-25T01:02:27.3666667+00:00
PercyTang-MSFT
12,426
Reputation points Microsoft Vendor
2 answers
One of the answers was accepted by the question author.
get Partition list in Tabular
Hi! How can I get a list of Partitions in Analysis Service? I'm using Tabular. Could anyone help me?
![](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(153.6, 39%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
2 answers
One of the answers was accepted by the question author.
Importing data from Excel in SQL
I am trying to import data from Excel into SQL using ETITLE: SQL Server Import and Export Wizard and I got below error: File path contains invalid Excel file. Please provide file with .xls, .xlsx, .xlsm, or .xlsb extension. What can I do to successfully…
asked 2023-09-28T07:07:06.4+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(80, 76%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVE%3C/text%3E%3C/svg%3E)
vincent Ewere
20
Reputation points
answered 2023-10-18T06:53:15.44+00:00
vincent Ewere
20
Reputation points
1 answer
Implementation of OLAP as a relational database
Hello . I am looking for a solution to the issue of OLAP cubes in the organization. Right now we have a task of taking one cube and replacing it with Tableau reports. In other words, this means taking an OLAP cube, flattening it into a relational…
asked 2023-10-12T09:30:41.39+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(156.8, 88%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
amir krugliak
0
Reputation points
commented 2023-10-15T07:49:49.88+00:00
amir krugliak
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Last Date Closing balance is not carry forward against same date?
I have facing issue, when i am applying date filter,after same date opening balance is not carry forward , below is data Create table #Tbl_Customer (C_ID int,C_Name varchar(50),Opening_Date date,Opening_value decimal(10,2)) Create table #tbl_Ledger (ID…
asked 2023-10-13T06:47:28.4433333+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(12.8, 75%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Analyst_SQL
3,551
Reputation points
accepted 2023-10-14T07:35:01.87+00:00
Analyst_SQL
3,551
Reputation points
1 answer
How do I pass all the JSON packets received in that particular tumbling window to the Javascript UDF function from the Azure Stream Analytics Query?
Below is my Azure Stream Analytics query. In this query, I have set the tumbling window for 10 seconds, and whatever data I will be receiving in these 10 seconds, I wanted to pass these complete packets in the "AggrFunction(IotMessage)" UDF…
asked 2023-10-13T07:09:56.4366667+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, 90%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDC%3C/text%3E%3C/svg%3E)
Deepak Chaurasiya
20
Reputation points
answered 2023-10-13T18:29:33.0366667+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, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
26,911
Reputation points Microsoft Employee
1 answer
Using 64bit HANA ODBC driver issue in VS2022 tabular project
Hello, I'm trying to develop a tabular project for SSAS 2019 on VS2022 17.2.2. The data source is our HANA database (64bit). THe SSAS 2019 enterprise is 64bit. The ODBC driver is "HDBODBC". It is a 64bit driver. As VS2022 is a…
asked 2022-05-28T06:11:10.88+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(156.8, 69%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKW%3C/text%3E%3C/svg%3E)
Kaniel Wang
1
Reputation point
commented 2023-10-11T18:41:14.5166667+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(195.2, 28.999999999999996%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jibitu, Meskerem
0
Reputation points
2 answers
SSAS related problem
New to SSAS. I have SQL Server, do I need to pay extra for ssas? By the way, when I look up information, I see that Azure Analysis Services has similar functions. Which one should I choose?
asked 2023-10-11T02:30:17.4933333+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, 83%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
NNJ
0
Reputation points
answered 2023-10-11T05:17:44.61+00:00
Olaf Helper
41,006
Reputation points
0 answers
VM Doesn't See AAD Cloud-Only Users But Sees Users Created From On Premises AD
Hello, I have an Azure virtual machine running SQL Server Analysis Services. This VM is joined to my company's domain. We recently migrated from a hybrid setup where we had an on-premise active directory running on a windows server, to a cloud-only Azure…
![](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(300.8, 54%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EF%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Not a legal OleAut date.. The exception was raised by the IDataReader interface
I have an SSAS Tabular project and the tables are coming from an Oracle database based on queries. When I proceed with process all, everything is fine but when I try to deploy the solution, the metadata is created successfully on the server and then…
asked 2023-10-06T10:56:30.24+00:00
Amira Bedhiafi
16,071
Reputation points
commented 2023-10-09T08:55:52.0333333+00:00
Amira Bedhiafi
16,071
Reputation points
2 answers
One of the answers was accepted by the question author.
Debit and Credit with Running Balance with Date filter
When i applying date between filter ,the last date balance must be opening in Balance ,but below query is not giving correct ouput. Create table #Tbl_Customer (C_ID int,C_Name varchar(50)) Create table #tbl_Ledger (ID int,E_Date date,Debit_Head_ID…
asked 2023-10-06T11:32:24.49+00:00
Analyst_SQL
3,551
Reputation points
accepted 2023-10-06T18:41:52.04+00:00
Analyst_SQL
3,551
Reputation points
1 answer
One of the answers was accepted by the question author.
Debit and Credit with Running Balance
I want Ledger Report of Customer 1001 'Akhter' with below Data Create table #Tbl_Customer (C_ID int,C_Name varchar(50)) Create table #tbl_Ledger (ID int,E_Date date,Debit_Head_ID int,Credit_Head_ID int,T_Amount Decimal(10,2) ) insert into…
asked 2023-10-06T06:58:30.1766667+00:00
Analyst_SQL
3,551
Reputation points
accepted 2023-10-06T10:33:24.5566667+00:00
Analyst_SQL
3,551
Reputation points
0 answers
How to create an average, rank, total measures over a field (by dynamic period) in SSAS?
Hi everyone, (I post here a question I created in stackoverflow, hopefully I will have better luck here) I'm new with SSAS technology and I have an existing cube that measures hits by page on web site. In few words the cube is structured as followed: a…
![](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(185.6, 68%, 27%)' 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
Scale up to a team can join to create a project SSIS and SSAS.
We have 2 servers, one is an APP server, the other is a DB server that shares the same domain. In the APP server, there is 1 SSIS project for ETL and 1 SSAS project for model building and analysis. But at a time only one person can access the server app…
1 answer
One of the answers was accepted by the question author.
get SSAS server admin information
I need to get SSAS server admin information. I know that can be found in the SSMS UI with the corresponding action. Is there any other way to get them? For example, T-SQL or other statements.
![](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(25.6, 93%, 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)
3 answers
One of the answers was accepted by the question author.
what is the difference
I learned that there are two query languages, MDX and DAX. I want to ask which features they apply to and what is the difference? Is it correct to add SSAS tag? Please let me know if this is not the correct tag.
0 answers
Data is get calculate after Opening date
I want ,when Opening_value and Opening_Date exist in tabel #tbl_Account_L_Four ,then opening_Value will be get from #tbl_Account_L_Four and Opening_Value ,if Opening_Date is null then data will get from #tbl_transection table. Secondly Opening_Date if…
asked 2023-09-20T08:25:32.1466667+00:00
Analyst_SQL
3,551
Reputation points
commented 2023-09-27T05:43:52.49+00:00
Analyst_SQL
3,551
Reputation points
1 answer
One of the answers was accepted by the question author.
I can't find the process feature in Visual Studio 2022
I can't find the process feature in Visual Studio 2022, it should be in the bar where the red line is.
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
439 questions
Visual Studio
Visual Studio
A family of Microsoft suites of integrated development tools for building applications for Windows, the web and mobile devices.
4,669 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,248 questions
![](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(256, 16%, 34%)' 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
Creating a measure ( like not exists for sql )
I would like to ask for your help with a question regarding Analysis Services (tabular). Here at the company, no one has knowledge, and I'm having to manage on my own. I need to create a measure that counts service request rows. These service requests…
asked 2023-09-12T16:03:54.7133333+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(35.2, 28.000000000000004%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERM%3C/text%3E%3C/svg%3E)
Robson Mantovani
0
Reputation points
commented 2023-09-26T09:02:33.8933333+00:00
PercyTang-MSFT
12,426
Reputation points Microsoft Vendor