Skip to main content
175 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
0 votes
1 answer
328 views

I am trying a approach to use the token generated using InteractiveBrowserCredential to connect to Power BI XMLA Endpoint. I was able to connect to the model using pyadomd locally but the same won't ...
Jai R's user avatar
  • 1
0 votes
1 answer
22 views

I am seeking to use the MS Fabric XMLA Read/Write endpoint to create and drop shortcut Tables in a Lakehouse. Based on this software, this is possible to do. I don't own the software and don't want ...
Dave.Gugg's user avatar
  • 6,801
1 vote
0 answers
100 views

I have a Azure Analysis Service database with a series of databases (cubes) present on it. These cubes have a standard data source(pulling data from a SQL Server 2022 instance) configuration looks ...
David Rogers's user avatar
  • 2,743
0 votes
1 answer
92 views

I'm trying to change the expression of an existing measure in a Power BI Semantic Model using Invoke-AsCmd in PowerShell. I have not been able to find any examples of this. What I have so far is this ...
saviourofdp's user avatar
  • 73
2 votes
1 answer
719 views

I am using pyadomd to connect into azure analysis services and trying to refresh a data model. The connection is successful but getting the following error "namespace http://schemas.microsoft.com/...
Muhammad Pathan's user avatar
  • 74
-1 votes
1 answer
467 views

I have an OLAP cube on SSAS (and XMLA script for processing). How can I call processing it via Python script? The only things I can find are about getting data from cubes (mdx/etc), and some popular ...
George Andersen's user avatar
  • 24
1 vote
1 answer
204 views

I am attempting to catalogue a set of olap-cubes from a SQL Server DB. In the analysis services (SSMS), I can right click a measure_group/table, click partitions, properties, and then use "Script ...
James's user avatar
  • 536
0 votes
1 answer
581 views

According to the documentation of tabular editor 2, it should be possible to create an xmla file which you can use for later deployments. But the -X argument never give any results. Using the -X ...
djva's user avatar
  • 1
0 votes
0 answers
339 views

I created a trace in SSAS but I'm unable to delete it. Fairly new to SSAS and not really sure how to get around this. Version: 14.0.249.83 Tried deleting it with this: <Delete xmlns="https://...
ppomki's user avatar
  • 1
0 votes
1 answer
262 views

I am trying to create a CI/CD pipeline in Azure DevOps for PowerBi models. I am facing issue with Tabular editor when trying to connect to Premium workspace using SP on powershell taks. SP is ...
choka's user avatar
  • 30
0 votes
1 answer
574 views

I am wondering how is possible to create a TMSL script from an tabular database (power bi service or SSAS) using some programing language. These kind of scripts are available in several tools, like ...
A Echague's user avatar
  • 3
2 votes
1 answer
54 views

We have produced some Excel files using Xmla Pivot Tables against Iccube schemas. Everything is working well except the fact that we noticed : Each Pivot Table on a single file (even single worksheet ...
Bertrand Miot's user avatar
  • 929
4 votes
1 answer
927 views

I have the following python code which works fine on run of the function but fails on second run. import adodbapi def connect_and_print(input_str): print("Function starting...", ...
Mike's user avatar
  • 164
2 votes
1 answer
532 views

I have generated a XMLA script from on premise SSAS cube , i need to execute this XMLA script in a automated way on Azure VM using powershell , the script should be idempotent in a way that if the ...
RRR's user avatar
  • 41
0 votes
1 answer
954 views

I'm looking for an automatic method for generating the file that is created in the first screenshot to see if it can be done: It is an xmla file detailing the structure of the tables within the ...
CDWatson's user avatar
  • 41
1 vote
1 answer
2k views

Is there a library to connect to a dataset using Python. I have uploaded blob as dataset in Powerbi. I want to access that dataset using XMLA endpoint. I tried using adodbapi but it isn't showing the ...
softwareDeveloperInProgress's user avatar
  • 55
0 votes
1 answer
398 views

I'm using Visual Studio (SSDT) to modeling and deploy my model to PowerBI Premium Workspace and create my report in PowerBI desktop, however now I've added new tables and applied changes on that and I'...
Marlon Batista's user avatar
  • 1
0 votes
1 answer
2k views

I am trying to issue an XMLA statement for "discover" to an Analysis Services Instance. Sending the XMLA from an XMLA window in Management Studio works fine and returns the desired result, ...
Ralf's user avatar
  • 548
1 vote
2 answers
3k views

I have a stored procedure which populates a few tables in a db which is the data source for a tabular SSAS cube. I want to process the cube as a final step in the stored procedure when I am done ...
Programnik's user avatar
  • 1,559
0 votes
0 answers
143 views

I am executing a power-shell script using Control-M tool using below command. powershell -command "& { F:\SAS01\Scripts\Powershell\Medicare} Powershell Script: Invoke-ASCmd -Server:Hostname -...
Mohan.V's user avatar
  • 141
1 vote
1 answer
446 views

I'm looking for a well documentated implementation of the XMLA protocole (proposed by Microsoft for OLAP engines). I'm looking for the server side implementation. I found this JAVA library: olap4j, ...
Hamza EL KAROUI's user avatar
  • 79
2 votes
1 answer
1k views

My question is: What would be the correct syntax to add 2 or more tables to an existing database using xmla file and SSMS? I have a model deployed to Azure Analysis Services server. So the database is ...
user12525899's user avatar
  • 133
0 votes
1 answer
1k views

I'm trying to create a way to partially automate creation of roles and role permissions in SSAS multidimensional cube. Due to some restrictions on my side this can only be done with using T-SQL to ...
Alex_404's user avatar
  • 409
3 votes
1 answer
308 views

I have some C# code using the undocumented Microsoft.AnalysisServices.Xmla.dll library which has been working fine for SQL 2016 SSAS. I generate the XMLA script, and then do: XmlaClient clnt = new ...
PLK's user avatar
  • 409
0 votes
1 answer
2k views

I've seen this error in C# before when referencing a class with private properties, but I'm at a loss here, as this class has public properties. It's actually a microsoft .dll I'm creating a new ...
coinbird's user avatar
  • 1,247

1
2 3 4