Stack Overflow
Stack Overflow

Questions tagged [azure-analysis-services]

Related to Analysis Services running as the platform-as-a-service offering in Microsoft's Azure cloud.

Based on the proven analytics engine in SQL Server Analysis Services, Azure Analysis Services is an enterprise grade OLAP engine and BI modeling platform, offered as a fully managed platform-as-a-service (PaaS). Azure AS enables developers and BI professionals to create BI Semantic Models that can power highly interactive and rich analytical experiences in BI tools such as Power BI and Excel. https://azure.microsoft.com/en-us/services/analysis-services/

379 questions
3
votes
1 answer

Azure Analysis Services vs Direct Query

I'm tring to assess the best approach, in terms of cost and performance, in accessing data and running queries on a dataset using Power BI with Azure Analysis Services or Power BI with Direct Query. I have trie to illustrate both approaches with the…
Carltonp
  • 1,166
  • 5
  • 19
  • 39
3
votes
1 answer

When writing a csv file to Azure Blob storage, can I configure SSIS to represent NULL as BLANK instead of \N?

I have an SSIS package that queries an Analysis services database and writes the results to Azure Blob Storage as a csv file. Package is very simple as below. My issue is that NULL values are represented as "\N" and I need them to be BLANK. There…
datalore
  • 31
  • 2
3
votes
0 answers

Install or use software on Azure Devops Hosted Agent

I am new to Azure Devops and hoping this is a simple fix. I have a powershell script that uses Tabular Editor to deploy .bim file to Azure Analyses Services. This works great on my local machine. I have tried to get this working in the devops…
DSiva
  • 53
  • 1
  • 4
3
votes
1 answer

Exception when trying to reference Azure Analysis Service Tabular Model C#

The problem I get is an exception when I try to reference Azure Analysis Service Tabular Model. Message=The value '2' is unexpected for type…
Essien
  • 67
  • 8
3
votes
1 answer

SSAS Tabular Model & Power BI - Week filtering in report

I created an SSAS Tabular Model in VS2017 and the model has a Date Table. In the Data Table, I have measures to obtain the current week of the selected day (for my model, always TODAY()), and the weeks start on Monday and end on Sunday. In my Power…
Cassandra Pratt
  • 73
  • 7
3
votes
2 answers

XMLA/TMSL from .Net Core

As the rest of the Azure world migrates to .Net Core it seems Azure Analysis Services is stuck on the .Net Framework. Is there a way to execute TMSL or XMLA against a SSAS Cube using frameworks available on .Net Core? This means AMO clients and…
CodeMonkey
  • 3,418
  • 4
  • 30
  • 53
3
votes
0 answers

Power BI Reporting cost optimization

We have a reporting solution wherein we transfer data from multiple databases to a single Azure SQL database, which is migrated to Azure analytical services, that are then used to generate the Power BI reports. These reports are embedded into a web…
Ankit
  • 97
  • 1
  • 8
3
votes
3 answers

Default filter in Power BI - Row Level Security not applied through LOOKUPVALUE

TL;DR: When using LOOKUPVALUE() against a table with Row Level Security, the RLS is not applied and all values are seen I have a requirement to have a 'default' value (location) picked in a Power BI report, based on the user. I am reporting against…
Nick.Mc
  • 18,304
  • 6
  • 61
  • 91
3
votes
2 answers

SSAS tabular model timeout raised during processing

When doing a Full Process on a tabular model to an Azure Analysis Service model I get the following error after 10 minutes into the processing: Failed to save modifications to the server. Error returned: 'Microsoft SQL: Execution Timeout Expired. …
Peadar Doyle
  • 1,064
  • 2
  • 10
  • 26
3
votes
2 answers

Azure Data Factory V2 how to process azure analysis service cube

In Azure Data Factory V2, how to process azure analysis service cube? I am able to use Azure Automation Account to run runbook powershell script to process cube automatically. However, I want to add cube processing into my ETL process developed on…
Edison
  • 287
  • 1
  • 6
  • 18
3
votes
1 answer

Is it possible to use msmdpump approach when connecting to azure analysis service

For on-prem analysis services (reference https://learn.microsoft.com/en-us/sql/analysis-services/instances/configure-http-access-to-analysis-services-on-iis-8-0) it is possible to configure http endpoint (which you can use for implementing custom…
Ondrej Svejdar
  • 21,349
  • 5
  • 54
  • 89
3
votes
2 answers

Exception when referencing SSAS Tabular model in C#

I am attempting to automate partition refreshes in Azure Analysis Services via C#. I have installed and referenced the latest 'Microsoft.AnalysisServices. ..' assemblies found…
Andrae Gaeth
  • 31
  • 2
3
votes
2 answers

How to authenticate with Azure Analysis Services from Azure batch and data factory

I have a c sharp class library that connects to Azure Analysis Services using the AMO library. I'd like to use this as part of my data factory pipeline to refresh cube partitions. This is done through Azure batch as a custom .net activity. var…
Neil P
  • 2,920
  • 5
  • 33
  • 64
3
votes
0 answers

How to refresh analysis services partitions / tables without causing "memory leaks"?

I'm using Microsoft.AnalysisServices.Tabular to test refresh / loading data into azure analysis services. Code is quite straightforward while (true) { var server = new Microsoft.AnalysisServices.Tabular.Server(); server.Connect( …
RassaR
  • 133
  • 8
2
votes
1 answer

Error adding local model for Power BI dataset

I'm having some trouble using DirectQuery for Power BI datasets and Analysis Services: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services I would think I meet all the prerequisites. "Allow…
Bryan Rock
  • 582
  • 1
  • 4
  • 13
1
2
3
…
25 26