Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
1,426 questions
1 answer
One of the answers was accepted by the question author.
How pricing will be calculated for data which is stored from dataverse table using azure synapse link
Hi folks, I am storing stale data from data verse table to azure data lake storage using Azure synapse Link. which actually stores data day by day for the whole year. ex, each day it transforms 10-50 records to azure data lake. So my…
asked 2022-10-28T07:02:29.8+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(0, 26%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Charles Michel Beskie (For Azure)
46
Reputation points
commented 2022-11-18T07:31:11.483+00:00
Charles Michel Beskie (For Azure)
46
Reputation points
1 answer
Chaos Studio - Error opening experiment designer
Home > Chaos Studio > Experiments > Create When I go to 'Experiment designer', I'm getting an error page. Text: "{ "shellProps": { "sessionId": "3e609a864ea04585b2a1096017d9e150", …
asked 2022-11-14T16:40:12.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 35%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EO%3C/text%3E%3C/svg%3E)
Orla
1
Reputation point
commented 2022-11-17T10:02:26.18+00:00
PRADEEPCHEEKATLA-MSFT
85,586
Reputation points Microsoft Employee
0 answers
Azure Analysis service Exception has been thrown by the target of an invocation
I recently downloaded Microsoft Analysis Services Projects 2022 from https://marketplace.visualstudio.com/items?itemName=ProBITools.MicrosoftAnalysisServicesModelingProjects2022&ssr=false#qna to VS2022 community and now I can deploy any package I am…
asked 2022-11-08T14:09:43.69+00:00
Gabe
1
Reputation point
commented 2022-11-14T09:24:47.997+00:00
PRADEEPCHEEKATLA-MSFT
85,586
Reputation points Microsoft Employee
0 answers
Is NETWORKDAYS function available on DAX for AAS model?
Hello I'm trying to use NETWORKDAYS function inside DAX code in my AAS model, but it is giving a Failed to resolve name error. Is the function available for usage within AAS models. Is there a specific compatibility level requirement? Thanks…
asked 2022-11-08T07:50:25.003+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(268.8, 48%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EV%3C/text%3E%3C/svg%3E)
Visakh
211
Reputation points
commented 2022-11-14T09:22:56.237+00:00
PRADEEPCHEEKATLA-MSFT
85,586
Reputation points Microsoft Employee
1 answer
Analysis Services REST API missing location header
The REST API to refresh the tabular model (https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-async-refresh) is supposed to return a Location header that can be used to obtain progress information. This has now stopped working.…
asked 2022-10-19T15:02:35.853+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(32, 53%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EIJ%3C/text%3E%3C/svg%3E)
Ivan Johannessen
11
Reputation points
commented 2022-11-11T17:15:54.703+00:00
Kazi Sabbir
1
Reputation point
2 answers
One of the answers was accepted by the question author.
How can I copy and duplicate an AAS cube?
We an Azure Analysis Services Tabular model which pulls from our Azure Synapse database. We want to create a duplicate of this cube with the exact same measures, calculations, etc. so that we can add tables that we don't want to add to the original one.…
asked 2022-08-02T13:55:05.757+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(35.2, 79%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
amzzz
61
Reputation points
answered 2022-11-04T09:59:32.027+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(28.799999999999997, 6%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Martin Rieth
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Azure Analysis Services Processing Error wo additional details
Error when refreshing Azure Analysis Service one of tabular models using On-Prem Gateway with Azure Function & Logic Apps. Gateway version 3000.146.10 (October 2022) Exception message: Failed to save modifications to the server. Error returned:…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 18%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
0 answers
Azure Analysis Services - Refresh Tabular Model Partition in "Add Mode" from Azure Data Factory
Hi, we are using Azure Data Factory to automate ETL and management of an Azure Analysis Services Tabular Model. We want to do an incremental refresh of the Sales Fact table on a regular basis, and given its size we only want to process additional…
asked 2022-09-30T08:18:12.54+00:00
Peter Rush
41
Reputation points
commented 2022-10-20T06:56:41.057+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,442
Reputation points Microsoft Employee
1 answer
Decision making factors for migrating SSAS from Azure VM to Azure Analysis Services
Hello, Recently we have upgraded our SSAS resources. Currently our SSAS is on Azure VM costing us based on this VM type 'Standard E32-8s_v3'. I am looking for a way to save more cost by selecting a better option. What can be a good option…
asked 2022-07-29T04:39:16.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(246.4, 68%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SRSYD
1
Reputation point
commented 2022-10-20T04:16:56.933+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 43%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Sumayya Sayed
1
Reputation point
1 answer
Getting started with monitoring of analysis service
I use a managed analysis services server in my subscription and would like to get started with some monitoring, What would be the most common and important metrics I should look at when defining alert rules? I reviewed this article and didn't…
asked 2022-10-19T07:29:42.887+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(262.40000000000003, 80%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
AssafL
1
Reputation point
answered 2022-10-19T10:58:39.953+00:00
Stanislav Zhelyazkov
22,251
Reputation points MVP
2 answers
One of the answers was accepted by the question author.
Data modification in log analytics before archiving it.
I have set up a connection between Azure DevOps and Log analytics workspace to get the audit data as a maintenance purpose. But before storing/archiving the data, I need to follow the GDPR rules i.e I have to remove the personal data before storing it…
asked 2022-10-12T09:41:20.623+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 4%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Abhishek Singh (Contractor)
21
Reputation points
accepted 2022-10-17T08:30:48.73+00:00
Abhishek Singh (Contractor)
21
Reputation points
2 answers
One of the answers was accepted by the question author.
Hiding AAS columns "...not intended to be used for data security" - why not?
Per this website: https://learn.microsoft.com/en-us/analysis-services/tabular-models/hide-or-freeze-columns-ssas-tabular?view=asallproducts-allversions The ability to hide columns is not intended to be used for data security, only to simplify…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 39%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
1 answer
Tabular Model not processing in Azure AS
We're testing migrating existing SSAS Tabular models from on-prem to Azure AS, but I'm running into processing errors with the Azure AS model. Background Simply SSAS tabular model - compatibility level = SQL Server 2016 RTM (1200) Data…
asked 2022-09-21T06:03:59.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(265.6, 35%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Scott Kent-Collins
1
Reputation point
commented 2022-09-29T01:11:35.563+00:00
KranthiPakala-MSFT
46,442
Reputation points Microsoft Employee
1 answer
Azure Analysis Service Tabular Model - TMSL Merge Partition script error
I am trying to merge existing table partition in Azure Analysis Service to main table using below TMSL script. { 'mergePartitions': { 'target': { 'database': 'AASDatabase', 'table': 'sales', …
asked 2022-09-15T17:06:20.407+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(156.8, 35%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENK%3C/text%3E%3C/svg%3E)
Naveen Kumar
1
Reputation point
commented 2022-09-27T16:17:50.03+00:00
ShaikMaheer-MSFT
38,401
Reputation points Microsoft Employee
1 answer
Automate analysis services cube refresh using service principal
We are using azure automation account to refresh our cubes but when we view the query sessions we see the queries using our login id's in the database. We want to use the service principal account to refresh the cube via azure automation account. Is…
asked 2022-09-06T15:24:46.493+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 9%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Swathi Sudheer
1
Reputation point
commented 2022-09-20T18:15:28.633+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 81%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPV%3C/text%3E%3C/svg%3E)
Prateek Vermani
1
Reputation point
0 answers
Azure analysis services tabular model
Hi Team, I have to migrate an existing Reporting application from custom code technology.Backend database is Oracle. I need to create a Tabular Model and need to know the below from the community: 1.What are the parameters on which number of tabular…
asked 2022-09-14T14:39:19.36+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(83.2, 27%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECR%3C/text%3E%3C/svg%3E)
Chandrima Roy
1
Reputation point
commented 2022-09-19T06:59:56.153+00:00
ShaikMaheer-MSFT
38,401
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Analytics around data entires being made in SQL tables?
We need to analyze how much data is being inserted every month or every day to understand the usage of the db tables in order to scale the DB accordingly.
asked 2022-08-24T20:24:29.677+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 35%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Vipul Sharma
21
Reputation points
accepted 2022-09-13T15:32:00.327+00:00
Vipul Sharma
21
Reputation points
1 answer
how to identify which cube is running or taking long time in azure analysis services?
AAS server is full, we want to kill long running query therefore wants to understand if we have any direct way of getting long running query details
asked 2022-09-01T08:54:04.603+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 17%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EN%3C/text%3E%3C/svg%3E)
Neha
101
Reputation points
commented 2022-09-12T18:41:41.397+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
Bhargava-MSFT
29,041
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Azure Synapse Spark Pool as Data Source for Analysis Services
Hi I'm trying to use the Synapse Spark Pool as a direct data source for an Analysis Services Tabular model. I can see that the latest version of Visual Studio Analysis Services project has a built in connector to a Synapse SQL pool, but not a spark…
asked 2022-09-07T08:29:04.907+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(16, 6%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDF%3C/text%3E%3C/svg%3E)
David Fletcher
41
Reputation points
accepted 2022-09-09T09:23:38.333+00:00
David Fletcher
41
Reputation points
1 answer
How to repoint ODBC datasource from one database to another so underlying tables can get refreshed?
I have a Tabular Model project (Azure Analysis Services Level 1500) in Visual Studio 2019. I have set up my odbc datasource to connect to my Snowflake server. From there I am able to import tables and view data too. My requirement is, currently I am…
asked 2022-09-05T05:47:20.507+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(9.6, 96%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAN%3C/text%3E%3C/svg%3E)
ANIRBAN Nag (IN)
1
Reputation point
commented 2022-09-09T02:20:38.18+00:00
ANIRBAN Nag (IN)
1
Reputation point