Content
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:…


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.


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…


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…


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 --->…


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…


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?


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…


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…


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…


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…


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…


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…


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? …


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…


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…


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:


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.


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…


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…

