Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
347 questions
Content
1 answer
How to process data from sql server to azure analysis service without getting timeout?
Hello! Every day, I need to process data from SQL Server to Azure Analysis Services (which I use as a data source for my Power BI report). I have set up a runbook in Azure that uses a PowerShell script to accomplish this. I followed this tutorial:…
asked 2023-03-30T09:45:37.5033333+00:00
Thor
1
Reputation point
edited the question 2023-03-31T01:27:35.8233333+00:00
Seeya Xi-MSFT
15,196
Reputation points Microsoft Vendor
1 answer
Azure Analysis Services tabular model for 50 GB Data (Approx 99 Million Records))
looking for recommendation to deploy 50 GB Data in Synapse Analytics (Approx 99 Million Records), Please suggest if Azure Analysis services S0 is capable of deploying and processing this volume of data.
asked 2023-03-22T12:37:27.9533333+00:00
Abhijeet Kumar
0
Reputation points
commented 2023-03-30T19:44:18.0466667+00:00
HimanshuSinha-msft
18,621
Reputation points Microsoft Employee
2 answers
Unable to connect SQL server to Azure ML pipeline?
Hi, I am trying to connect sql server using pyodbc and to extract some procedure for Azure ML pipeline. Since I am not able to install pyodbc library in Azure ML, pipeline connection is not happening. Kindly let me know is there any alternative method…
asked 2022-03-17T06:56:59.34+00:00
MOHAMMED ABDULLA T
1
Reputation point
answered 2023-03-27T20:57:16.32+00:00
Thiago Barral
0
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Log Search API to Grab Information
Hello, Thanks ahead of time for any information you can provide. What I am attempting to do is this. I have a custom query that grabs the heal status of our vm. The in that query results i have the vms information like it if is health or unhealthy so…
asked 2023-03-24T20:21:10.3366667+00:00
LaVar Blalock
25
Reputation points
commented 2023-03-27T01:46:50.27+00:00
kobulloc-MSFT
13,786
Reputation points Microsoft Employee
1 answer
After cloning from Git the analsys tabler modle not showing the Tabular model explorer
Hi expert I am able to create Git Repo after downloading the cube from server Below is the options available but after cloning the Repo I am not able to see the Tabular Model Explorer even I tried to enable the from View --> other windows --->…
asked 2023-02-24T12:20:32.3366667+00:00
Hazarath Reddy Boreddy
1
Reputation point
commented 2023-03-08T22:18:49.73+00:00
KranthiPakala-MSFT
36,017
Reputation points Microsoft Employee
0 answers
API pull of Azure Analysis Service Last modified time
I am trying to extract the highlighted value from a Azure Analysis Service. Looking at the regular API, this value is not available: GET…
asked 2023-02-26T15:11:23.17+00:00
Lily
1
Reputation point
commented 2023-03-08T07:43:43.5466667+00:00
PRADEEPCHEEKATLA-MSFT
56,551
Reputation points Microsoft Employee
0 answers
Model (Bim files) repointing from Gen1 datalake in AAS to Gen2 datalake
Hi, I have around 30 models in AAS which are currently pointing to Gen1 datalake. I would like to repoint them to Gen2 datalake with minimum efforts. Is there any utility for the same?
asked 2023-02-28T15:12:12.65+00:00
Erika Gupta
0
Reputation points
commented 2023-03-06T15:33:36.08+00:00
Amira Bedhiafi
151
Reputation points
0 answers
Namespace error in Azure Function
I am trying to query Azure Analysis Services through Azure Synapse. As there is no connector to do so directly, I used Azure function to connect to AAS. But I am getting the below error: [Error] run.csx(7,17): error CS0234: The type or namespace name…
asked 2023-03-02T16:54:12.89+00:00
Mohit Pawar
0
Reputation points
commented 2023-03-06T10:12:42.53+00:00
Mohit Pawar
0
Reputation points
0 answers
How to pass values from lookup activity to Web activity in azure data factory
Hi, I am attempting to refresh an Azure analysis using Azure Data Factory. When I use hard-coded values for the table name and partition name in the Web activity, the pipeline runs successfully. When I use a For Each activity to iterate through a list…
asked 2023-02-28T14:09:48.87+00:00
muhammad abubakar
0
Reputation points
commented 2023-03-03T23:30:43.1466667+00:00
KranthiPakala-MSFT
36,017
Reputation points Microsoft Employee
1 answer
How to incrementally refresh Azure Analysis Services having synapse pool as source. Does “Default” processing option supports incremental refresh
Cube: Tabular (Azure Analysis Server)--- Source DB: Azure Synapse Pool --- Data Operation: Insert and update is happening on the source system Issue: Not able to get latest data from synapse pool in AAS cube, using "Default" processing…
asked 2021-01-29T18:41:35.153+00:00
Vipul Singh
21
Reputation points
commented 2023-02-21T12:31:58.6966667+00:00
Kim Beck
0
Reputation points
0 answers
Azure Analytics software audit - list of registry entries checked
A quick background summary to put this query into context. Our cyber insurance requires that there is no (manufacturer/supplier/third party) unsupported software on any of our 1000+ servers. I have run an Azure Analytics query to search for 3…
asked 2023-02-10T11:49:26.8+00:00
Duckfield, Sam D
0
Reputation points
commented 2023-02-15T11:37:09.3166667+00:00
ShaikMaheer-MSFT
30,426
Reputation points Microsoft Employee
2 answers
Azure Analysis Services - error when processing blob storage data
Hello, I'm facing an issue regarding access to Blob Storage Container from Azure Analysis Server Instance. I've created a tabular model that pulls the data from Blob Container, but when I'm trying to process the data from the container in SQL Server…
asked 2021-10-01T12:44:18.527+00:00
Matthew
121
Reputation points
edited an answer 2023-02-11T00:05:00.36+00:00
Yan Linn Naing
0
Reputation points
0 answers
Can we convert R script to M code (Power Query)
As we are having few scripts in R which we are consuming in another scope, as per the new scope that needs be migrated to M (Power Query). If so, are there any best practices to migrate existing scripts to M code. Do we have any tools that can be used…
asked 2023-01-27T12:38:18.8+00:00
Manohar Kondragunta
0
Reputation points
commented 2023-02-10T04:27:15.64+00:00
AnnuKumari-MSFT
21,406
Reputation points Microsoft Employee
2 answers
Composite SLAs
All, This is a very generic question. The below link talks about SLAs and how to arrive at Composite SLAs. Is multiplying percentages even the right way to arrive @ a Composite SLA for an application? …
asked 2020-10-12T04:40:28.657+00:00
grajee
331
Reputation points
edited the question 2023-02-09T05:32:53.95+00:00
PRADEEPCHEEKATLA-MSFT
56,551
Reputation points Microsoft Employee
1 answer
Processing Of Azure Analysis Server Failed
we are trying to refresh the azure analysis server using the Azure Logic apps. While I am trying to process i am getting the following error. {"message":"Retry attempts for failures while executing the refresh exceeded the retry limit set…
asked 2023-01-31T07:05:06.5666667+00:00
MAHESWAR KESS
0
Reputation points
commented 2023-02-06T19:01:37.1366667+00:00
BhargavaGunnam-MSFT
10,646
Reputation points Microsoft Employee
3 answers
Azure Analysis Services - Unable to delete an existing database using SSMS
Hi All, I have a database in analysis server which I want to delete completely. I guess that the database is corrupted somehow as I'm not able to connect that model to powerbi or do any operation on that model (simple operations too..for instance…
asked 2022-10-29T15:06:10.857+00:00
D U Maheswara Rao
1
Reputation point
answered 2023-02-03T13:43:36.4066667+00:00
Sanjaykumar Gajwani
0
Reputation points
1 answer
How to export list of dependencies from a tabular cube?
I have my cube already deployed: I am looking to map the dependencies of the cube; that is, the name of tables / data objects being used in these cubes. How can I output that list?? I would like to get the full list of all the sources like:
asked 2023-01-23T13:45:38.91+00:00
ovonemty
21
Reputation points
edited the question 2023-02-02T11:02:48.2866667+00:00
PRADEEPCHEEKATLA-MSFT
56,551
Reputation points Microsoft Employee
0 answers
How to create a gateway from azure analysis server to on prem server? The azure analysis server is getting data from on-prem server but it is not working as expected.
How to create a gateway from azure analysis server to on prem server? The azure analysis server is getting data from on-prem server but it is not working as expected. While refreshing any tables inside the cube, its throwing error.
asked 2023-01-23T12:30:58.8433333+00:00
Kumar, PPrabhat
1
Reputation point
commented 2023-01-27T05:17:14.58+00:00
PRADEEPCHEEKATLA-MSFT
56,551
Reputation points Microsoft Employee
2 answers
Unable to upgrade tabular level to compatibility level to 1500
We are in the midst of upgrading our tabular models compatibility level to 1500. They are currently on 1200 and they are on SSAS not Azure Analysis Services. We were successful in converting most of them to 1500 and deploy them.. However, we are not able…
asked 2020-05-20T15:20:30.617+00:00
Nama, Srikanth
1
Reputation point
edited the question 2023-01-24T18:19:01.5466667+00:00
KranthiPakala-MSFT
36,017
Reputation points Microsoft Employee
0 answers
Use last interactive login profile to connect to Azure Analysis Service with Adomd client
I successfully connected to my org AAS database with Adomd .NET client library using Microsoft.AnalysisServices.AdomdClient; Console.WriteLine("Starting program..."); AdomdConnection adomdConnection = new…
asked 2022-12-22T01:10:19.347+00:00
Huy Nguyen
21
Reputation points
edited the question 2023-01-24T04:00:30.0633333+00:00
KranthiPakala-MSFT
36,017
Reputation points Microsoft Employee