431 questions with Azure Analysis Services tags

Sort by: Updated
1 answer

Azure Analysis Services Rolling Weekly Partitions

What is the best way to create rolling weekly partitions for Azure Analysis Services? We would like to be able to process the most recent week of data.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2021-01-26T02:23:22.61+00:00
James H. Robinson 161 Reputation points
commented 2021-02-02T17:31:26.803+00:00
HimanshuSinha-msft 19,361 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

How to connect to Azure Analysis Services from java or other languages and execute DMV queries without using SSMS or MSMDPUMP.dll

My requirement is to connect to Azure analysis services and retrieve tabular model's metadata. I am able to connect to this service from SSMS (Sql server management studio) and execute DMV queries. I would like to do this programmatically. What options I…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2021-01-16T11:31:26.75+00:00
Sibi Narayanaswamy 41 Reputation points
accepted 2021-02-02T14:20:04.013+00:00
Sibi Narayanaswamy 41 Reputation points
2 answers

Partition Processing - Tabular Model in Azure

We have a Tabular Model that exists in Azure - processed multiple times a day to catch intra-day transactions. For simplicity sake I will denote the Table Structure as: FactTable1 (Order Transactional) FactTable2 (Detail Transactional) DimTable1 …

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Stack Hub
Azure Stack Hub
An extension of Azure for running apps in an on-premises environment and delivering Azure services in a datacenter.
176 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,239 questions
asked 2021-01-27T21:58:25.697+00:00
Derek Price 26 Reputation points
commented 2021-02-01T09:03:12.37+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer One of the answers was accepted by the question author.

Powershell to identify whether the data source is legacy one

Hello. Is there any particular property via which we can identify through powershell whether the data source within an AAS is a legacy one ? Legacy : ConnectionString : Persist Security Info=false;User…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2021-01-27T04:57:00.613+00:00
Nandan Hegde 29,786 Reputation points MVP
accepted 2021-02-01T03:02:42.047+00:00
Nandan Hegde 29,786 Reputation points MVP
1 answer

SSIS Analysis Processing Task Error: Exception has been thrown by the target of invocation.

Hi I'm trying to process an object (Process Full) in the Azure Analysis Services through Analysis processing task and getting below error when executing the SSIS package. Exception has been thrown by the target of invocation. I'm able to test the…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,426 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,239 questions
asked 2021-01-26T00:05:09.273+00:00
Suresh Veesam 21 Reputation points
commented 2021-01-29T06:41:07.377+00:00
Lukas Yu -MSFT 5,816 Reputation points
1 answer

Able to deploy but unable to process the AS tabular model on Azure Analysis service

Able to deploy but unable to process the AS tabular model on Azure Analysis service . New AS service provisioned in Azure with the below compatibility I get the below error from VISUAL STUDIO Error message ------ Build started:…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2021-01-25T17:51:35.11+00:00
Mudassar A 481 Reputation points
commented 2021-01-25T23:04:47.237+00:00
MartinJaffer-MSFT 26,011 Reputation points
1 answer

How to set dynamically the database connection string in a tabular model

I am using configurations for deploying the same tabular model to different clients (same model, same db structure, only difference is the db connection string). Unfortunately the connection string is not part of the configuration properties. Is there…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 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,239 questions
asked 2021-01-06T12:57:36.557+00:00
Ralf Mark 1 Reputation point
commented 2021-01-18T01:32:50.673+00:00
Lukas Yu -MSFT 5,816 Reputation points
2 answers

Azure Analysis Services: Not able to connect to data source(SQL server) with Active directory(In Model.bim)

In credential section of Model.bim we define the way we are going to authenticate the data source(here SQL server) , right now i'm using DB user, DB password with AuthenticationKind="UsernamePassword" and it is working fine and able to refresh…

Azure SQL Database
Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 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,239 questions
Microsoft Entra ID
Microsoft Entra ID
A Microsoft Entra identity service that provides identity management and access control capabilities. Replaces Azure Active Directory.
18,947 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,532 questions
asked 2020-12-30T09:44:52.797+00:00
Pieboy 1 Reputation point
commented 2021-01-07T15:45:31.807+00:00
Saurabh Sharma 23,656 Reputation points Microsoft Employee
0 answers

Get record count of Partition

I have a partition processor in C# that creates and loads partitions in a 2 year rolling pattern once a day. When a partition is created with 0 records it is a valid partition and on subsequent loads, the partition state is checked and if Ready, it is…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2020-12-10T07:05:43.827+00:00
Bowles, Mickey 46 Reputation points
commented 2021-01-06T19:05:42.757+00:00
Bowles, Mickey 46 Reputation points
2 answers

Connecting Azure Analysis service and SSIS using service principal

Hello Team, We are trying to connect azure analysis services and SSIS using service principal. But when we are passing this in SSIS as username & password, it is getting failed again and again and throwing the below error : Test connection failed…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,426 questions
asked 2020-12-16T08:48:35.223+00:00
Dheeraj 6 Reputation points
commented 2020-12-29T11:16:59.22+00:00
HarithaMaddi-MSFT 10,126 Reputation points
2 answers One of the answers was accepted by the question author.

Actions in Analysis Services Tabular

One of the multidimensional feature not already available in tabular is the possibility to create actions. is there a roadmap about this feature?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 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,239 questions
asked 2020-12-22T09:27:47.07+00:00
Anonymous
accepted 2020-12-24T08:11:02.147+00:00
Anonymous
2 answers One of the answers was accepted by the question author.

Filtering data before loading in Dataset from Tabular Model

Hi All, I have created a Tabular Import Model with last 5 years of data which has approx 10 Miliions of rows which is required for trend reporting. Now I am trying creating a Power Bi Desktop report for last say last 7 days, where I have Date…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 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,239 questions
asked 2020-12-09T22:48:25.85+00:00
Swapnil 216 Reputation points
accepted 2020-12-16T14:40:18.56+00:00
Swapnil 216 Reputation points
1 answer One of the answers was accepted by the question author.

Ways to dynamically add a new column into Azure Analysis services

Hi All, Background, Power BI > Live connected to Azure Analysis Services > connected to Azure SQL Db I have instances where I need to introduce a new column after pivoting a key Attribute Value table i.e Next time around a new…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Not Monitored
Not Monitored
Tag not monitored by Microsoft.
35,360 questions
asked 2020-12-08T16:01:21.227+00:00
Dee18 31 Reputation points
commented 2020-12-14T16:21:21.693+00:00
Dee18 31 Reputation points
1 answer One of the answers was accepted by the question author.

Cannot deploy Tabular Model to AAS server due to invalid PostgreSQL credentials

Hello, I am having problem with cube deployment which is built on PostgreSQL database. Every time I try to deploy the model to AAS server, I receive following error: Cannot process database. Reason: Failed to save modifications to the server. Error…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2020-12-07T15:57:00.3+00:00
Matthew 121 Reputation points
commented 2020-12-11T12:50:55.41+00:00
PRADEEPCHEEKATLA-MSFT 74,641 Reputation points Microsoft Employee
1 answer

I can't update my Azure Analysis Services model

Hello, I lost my original file from my local laptop where I initially created my AAS model, so I went to the portal and downloaded the last deployed one : Now at first I was able to modify my measures and save my work but suddenly the…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2020-12-07T15:18:03.273+00:00
Adnane KHIRCHI 6 Reputation points
commented 2020-12-10T08:35:28.707+00:00
PRADEEPCHEEKATLA-MSFT 74,641 Reputation points Microsoft Employee
2 answers One of the answers was accepted by the question author.

What does the command ExternalCommandTimeout do?

I have a cube that crashes about 45 minutes in the processing and I got the tips to set the ExternalCommandTimeout default 3600 seconds to a much higher value, and it worked, the cube does now process completly. But what does it really do, what kind om…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 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,239 questions
asked 2020-11-18T21:52:33.313+00:00
Fredrik M 146 Reputation points
accepted 2020-12-06T21:14:53.13+00:00
Fredrik M 146 Reputation points
1 answer

the 'transactionId_s' field and 'transactionId_g' field in waf log

Why in my exported app gateway waf log, field 'transactionId_g' has a value and field 'transactionId_s' has no value?

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Application Gateway
Azure Application Gateway
An Azure service that provides a platform-managed, scalable, and highly available application delivery controller as a service.
930 questions
asked 2020-09-04T02:58:26.707+00:00
Zhang, Di 21 Reputation points
commented 2020-12-04T10:08:25.137+00:00
suvasara-MSFT 9,986 Reputation points
0 answers

Table.NestedJoin in Azure Analysis Services

We have an M/Power Query query in Power BI that uses Table.NestedJoin. However, we get errors when we try to use that same command in Azure Analysis Services. Does this command even work in AAS? I don't see any examples of it working properly. Is…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2020-11-19T23:25:27.723+00:00
James H. Robinson 161 Reputation points
commented 2020-12-02T20:00:32.137+00:00
HimanshuSinha-msft 19,361 Reputation points Microsoft Employee
1 answer One of the answers was accepted by the question author.

Azure Analysis Services - current connection metrics

I am doing load testing of Azure analysis services where I have established 500 different sessions. When my code was running for these 500 connections, I monitored current connections metrics on Azure portal. There I saw max 15 current…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
asked 2020-11-19T07:26:24.13+00:00
Kalpana Chauhan 21 Reputation points
accepted 2020-11-26T15:47:46.077+00:00
Kalpana Chauhan 21 Reputation points
0 answers

Building data model (schema) from data in PowerBI (or via export to Excel)

Hi, I am seeking to build a data model (schema) for data tables that I currently have in PowerBI. I am able to export the data to Excel but have been having issues building a schema for the tables. Would appreciate any help for this please. Thanks!…

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
431 questions
Azure Maps
Azure Maps
An Azure service that provides geospatial APIs to add maps, spatial analytics, and mobility solutions to apps.
567 questions
asked 2020-11-22T23:35:50.333+00:00
Rishi Sumit 1 Reputation point
commented 2020-11-25T20:33:24.027+00:00
MartinJaffer-MSFT 26,011 Reputation points