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.
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…
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 …
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…
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…
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:…
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: 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…
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…
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…
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?
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…
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…
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…
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…
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…
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?
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 - 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…
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!…