400 questions
0
votes
1
answer
205
views
Microsoft.AnalysisServices.Tabular Server.Connect() fails with valid token
I'm successfully connecting to a Power BI Service instance to run commands from C# code using AdomdConnection and have problems connecting to the same Power BI Service instance with Microsoft....
- 1,217
1
vote
2
answers
201
views
Operation returned an invalid status code 'Forbidden' Exporting Power BI Report to PDF
I have a Power BI report that pulls data from an Azure Analysis Services tabular cube. In a C# console app, I am trying to export this report to a PDF, while passing in an effective identity of the ...
- 61
0
votes
0
answers
65
views
Unable to process AAS model connecting to Azure SQL with Service Account
I have built a demo SSAS model that I am hosting on an Azure Analysis Services Server. The model connects to an Azure SQL database in my tenant (the Database is the default AdventureWorks provided by ...
0
votes
0
answers
67
views
Failed Azure Analysis Server Data "SaveChanges" - "'Error.cpp', line 116, function 'err::BaseError::ThrowFromTLS"
I have a SQL Server 2022 server where I am building a Azure Analysis Service(AAS) cube, amongst other code I have the following:
Tabular.Database d = ssasServer.Databases.FindByName(dbName);
d.Model = ...
- 2,743
0
votes
0
answers
35
views
Power BI Incremental refresh change precision over time
I have a semantic model refreshed every day. In this semantic model, there's a table with a incremental refresh.
In SQL Management Studio, I can see the daily partitions, and when the month is ...
- 232
0
votes
0
answers
79
views
Azure Analysis Service Tabular Cube Compatibility Level Confusion 1608 But API Returns 1600
I have a application written in C# that amongst other things connects to a Azure Analysis Service and moves and alerts tabular cubes, once of the functions I run is a "hotswap" function ...
- 2,743
1
vote
1
answer
46
views
SSAS Tabular - How to avoid the initial delay of the first query in Analysis Services?
I have a database in Analysis Services Tabular and a table with direct query.
When I'm creating a table (without relationships and nothing stranger) and after I do a simple query against that table ...
0
votes
0
answers
69
views
Fastest Read Speeds in Python from an Azure Analysis Database
Does anyone know which python library would provide the fastest read speeds from an Azure Analysis Database? Long story short, I have access to an external Azure Analysis Database (A Power BI Premium ...
- 45
0
votes
1
answer
44
views
Error while trying to get Roles to Azure Analysis Service using SPN and password in C#
I am trying get roles inside a database in Azure AnalysisServices.
I am using NuGet package Microsoft.AnalysisServices.retail.amd64
Below is the code that I am using:
using Microsoft....
- 659
0
votes
0
answers
2k
views
Connect 3 existing semantic model as a source for a PBI report
I'm a power bi administrator facing issue with the performance of a report.
The user has a report which connects 3 existing semantic models in power bi service.The user doesn't want to load the data ...
- 15
0
votes
1
answer
208
views
Response status code does not indicate success: 415 (Unsupported Media Type)
I am trying to a refresh on a single table in Azure Analysis services using PowerShell and Automation Runbook.
I am passing a bearer token to the header body but while testing it I am getting below ...
0
votes
2
answers
994
views
Connect Azure Analysis Services to Microsoft Fabric through SQL endpoint
I am trying to connect an Azure Analysis Services model to Microsoft Fabric through a SQL endpoint. When using my own account [email protected] I am able to get data. To schedule the processing of the ...
0
votes
1
answer
650
views
How to list the databases/models under Azure Analysis Services using Powershell?
I have a task that I need to automate. The task involves getting the list of Databases/Models present in the Azure Analysis Services model using Powershell Script
I have written the following ...
- 268
0
votes
1
answer
2k
views
Error when Refreshing Power BI Gateway - Mashup error
I have been experiencing a periodic refresh issue with multiple BI reports currently sitting on service. These are using gateways to pull data from either/or Analysis services or via a direct SQL ...
0
votes
1
answer
453
views
Function app not connecting to analysis services server getting Specified method is not supported
I am refreshing a data model in Azure analysis services using an Azure c# .net6 function app. I am getting that the Specified method is not supported when connecting to analysis services. my ...
0
votes
1
answer
504
views
what is the correct way to format a connection string for azure analysis services using Microsoft.AnalysisServices.NetCore
Creating a function app to refresh a data model in azure analysis services based on a timer trigger. Using Microsoft.AnalysisServices.NetCore package.
What is the correct way to format the connection ...
0
votes
1
answer
311
views
How to Kill sessions running for last 5 minutes automatically in azure analysis services?
I have a requirement to kill the active sessions currently running on Azure Analysis Services which are consuming high QPU and are running for more than 5 minutes.
I came across below article : which ...
- 147
0
votes
1
answer
753
views
how to link user managed identity to azure analysis services
I created a user managed identity in a bicep template. Is there a way in azure cli where i can link this user managed identity created to azure analysis services.
As well as this i need the ,managed ...
0
votes
1
answer
424
views
format for request to azure analysis services rest api
I am refreshing a data model in azure analysis services using a rest api.
Refrence doc: https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-async-refresh#base-url
I am getting ...
1
vote
1
answer
162
views
Unable To Open Tabular Cube From Azure Analysis Service With Compatibility Level 1604 In Visual Studio
The latest compatibility level supported by Azure Analysis Services is 1604, this is what is returned by the following C# API:
public int GetMaxCompatibilityLevel()
{
return ssasServer....
- 2,743
0
votes
1
answer
136
views
How to add a description to TMSL script for Azure Analysis Services
I'm trying to update a role in a Tabular model (compatibility 1500) that's hosted on a managed Azure Analysis Service instance (version 16.0.101.19). The member of this role is a security group so it'...
- 57
0
votes
0
answers
251
views
Invoke-ASCmd: use without UserCode/Password within a Devops pipeline
I want to make use of the Invoke-ASCmd without UserCode/Password within a Devops pipeline.
Now the code looks like:
$securePassword = ConvertTo-SecureString $password -AsPlainText -Force
$...
- 331
0
votes
1
answer
118
views
Cannot connect PowerBI to Azure Analysis Service
Everything worked well till today. Today PowerBI Service (and Desktop) cannot connect to Azure Analysis Service.
Message:
We can't connect to that SQL Server Analysis Services database. Please verify ...
- 63
0
votes
1
answer
678
views
Passing a parameter into an MDX Query using Power Query in Excel
I am using a parameter to build an MDX query to analysis services in a SQL Server Cube/Tabular Model. This is an example
AnalysisServices.Database("server_name", db_param, [Query = "...
- 536
0
votes
1
answer
475
views
Export excel form Power BI using Power Automate
I'm trying to extract data from a specific table in power bi and export it to an excel file for further analysis recursively (1 a week).
I came across a solution, but I am encountering some issues. ...
- 13