Integration with ArcGis
I am trying to integrate various shape files from ArcGis source database to Azure. While exploring I understand that cant connect these files using Azure Data factory and can use Python scripts (GeoPandas) can be able to read these files from ArcGis. My…
Analysis Service cube connector does not work with my Azure Service principal
Hi, I have two Analysis services Cubes - one is built upon DAX while the other is built upon M Code. After I created my Azure service principal, I successfully change the DAX cube connector and it works fine now. However, I try to change the connector to…
use powershell script to extract tables and relationships from tabular model into csv
I would like to automate the extraction of tables and the fields in the relationships for an Analysis Services Tabular Model. Ideally this would land in a csv file in Azure Blob Storage in a table format similiar to…
Why there are multiple records created in diagnostic log when a client application queries Azure Analysis Services data?
For an Azure Analysis Services server, I have added a diagnostic setting to send engine logs to a blob container. In the diagnostic setting, I have chosen the logs with engine as the category. The purpose of having this diagnostic setting is to monitor…
Were SSRS Report Models (SMDL) a better semantical layer for operational reports than Tabular Models (PBIX Power BI Dataset) ?
Is a Tabular Model (in Analysis Services or Power BI/PBI Dataset) really a replacement for the (deprecated) SSRS Report Models? Tabular Models are made for BI/dashboards/PBIX (Power BI Desktop) reports to do slice-and-dice analytics while Report Models…
Extract data directly from Azure Analysis Services using Azure Data Factory
Hi I am trying to get data from an OLAP cube in Azure Analysis Services (AAS) source https://asazure://...europe.asazure.windows.net/model to Azure Data Factory (ADF) using query EVALUATE SUMMARIZECOLUMNS (....) Can you suggest any way how to do it?…
Create a measures table in SSAS Tabular and Deploy to Azure
With the Import mode in Power BI , I used to create a table for measures. Now I want to do the same with SSAS Tabular and then deploy it.
Counting distinct data from FACT table returns correct numbers but SSAS cube does not
Hi, I have a problem with distinct count measures in SSAS cube. When I check my FACT table numbers - they are correct but distinct count measure (in combination with location data) in a cube shows different numbers. When I do not combine location data,…
How to connect to an AAS model via Visual Studio Code again after it has been renamed
I have an Analysis Services Model that was created on visual studio, which was then deployed onto Azure. I tried to rename this model via SQL Server Management Studio, and this seems to be fine and the new name appears when I view the model on the Azure…
During AAS refresh we have been facing issue stating "Additional error details: DM_GWPipeline_Gateway_CanceledError The operation failed due to an explicit cancellation"
The Error details is mentioned in the image.
How to solve the error "Not Supported in DirectQuery 1400 Mode" in AAS
I imported data into AAS, then I changed the DirectQuery Mode is ON. With the opening file, it was okay. However, when I closed and re-opened the file, it showed the error as below. I cannot open the model or change anything. When reopening, the…
Process Data + Process Recalc a AAS via Azure Data factory
Hello everyone, I am currently refreshing the AAS model in full mode using the REST API called from ADF, but the processing time of some tables is quite large. I have read some methods to reduce processing time, including the ‘ProcessData Plus…
Analysis service over Power BI embeded
Hello, We experience performance problems with our current Power BI embeded capacity. We are currently running everything on our embeded capacity, but are looking into other solution to handle more users. By moving our data model to Azure Analysis…
Is caching entire Azure analysis services cube/model possible using Azure cache for Redis?
Hello, I am trying to access Azure analysis services Model data using web analytics. Due to huge data on AAS, It has performance issues. So wanted to know if we can cache entire cube/model data in redis cache to get faster response? if not how can we…
Dependency analysis for 2016 windows server not supported?
We will scan the VMware environment of the customer , In the documentation (VMWare Dependency analysis agentless) I saw for dependency analysis its not supported for 2016 servers. I was wondering why 2016 is not supported and 2019 is supported?
Dynamics 365 User dataverse analytics refresh rate
Dear Azure Support, This monday we had a Go-live of our clients Dynamics 365 CE system. Now we would like to have an up-to-date User analytics. So, who has logged in etc. We found the D365 User Dataverse analytics but unfortunately the refresh rate is…
Tabular VS Multidimensional - why the latter are not supported in Azure Analysis Services
I want to understand the differences between both and why the multidimensional models are not supported in AAS?
GetConsoleWindow used in Microsoft.AnalysisServices.retail 19.67.0 causing issues in Mono
We have a C# program which uses TOM to synchronize an Analysis Services Model to individual Analysis Services instances on Azure. We have used this program for a few years now and run it daily for multiple servers on a Linux machine, using Mono. This…
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…
Help me decide between Azure data lake analytics and Azure Databricks
Both Azure Data Lake Analytics and Azure Databricks can be used for batch processing. Can you help me understand for which case we can use each one?