Stack Overflow
Stack Overflow

Questions tagged [ssas-tabular]

The SQL Server Analysis Services (SSAS) tabular model is an in-memory, column store relational data warehouse constructed with tables which can have multiple columns of data. SSAS Tabular is geared for fast querying and high data compression. The Tabular Engine is the same one used in Power BI, Azure Analysis Services, and Excel Power Pivot.

869 questions
1
vote
2 answers

How to fetch column from another Dimension table without relationship

I have 2 dimension tables with no relation between them. 1 is Product Dimension table as ProdCode | ValidStartDate | ValidEndDate XX | 2012-01-01| 2016-12-31 XX | 2017-01-01| 2017-12-31 XX | 2018-01-01| 2020-12-31 2nd is Time table Year |…
LearnSQL
  • 47
  • 6
1
vote
0 answers

SSAS tabular dynamic Row Level Security without direct connection

Up until now my SSAS tabular OLAP cube is used directly by a select group of people, others connect with through Power BI with a service account. This way I can manage what my large user group is able to see through the designs of the Power BI…
Menno
  • 12,175
  • 14
  • 56
  • 88
1
vote
1 answer

Azure Analysis Service Tabular Model connecting to Power BI Service .NetCore Database.Model is null exception

In a Azure Function I have connect to the power bi service and can get a dataset by using the FindByName or GetByName but the Database.Model value is null. Which means i cannot refresh the dataset or update anything. While debugging can see all of…
ozhug
  • 983
  • 11
  • 19
1
vote
1 answer

DAX - Calcuate a many to many mapping?

I'm trying to build a calculated table, containing the mapping between different datasets. The keys I'm using to do the lookup can be repeated and I would like to generate the list of all possible combinations. In SQL, this would be a join which…
Neil P
  • 2,920
  • 5
  • 33
  • 64
1
vote
0 answers

MS SSAS Tabular model, unable to switch to DirectQuery mode

I have designed a model with 5 tables. During my first design, my tabular model was in in-memory mode. While I'm designing, I want the model to use direct query mode. For some reason, I cannot change to direct query mode using Visual Studio. When I…
Jacco de Zwart
  • 11
  • 4
1
vote
1 answer

Analysis Services Execute DDL Task connect string for Power BI XMLA endpoint

We have power bi premium and an XMLA endpoint enabled. I am trying to refresh partition in the dataset using a TMSL script. The microsoft doco says this should work with "Analysis Services Execute DDL Task in…
ozhug
  • 983
  • 11
  • 19
1
vote
1 answer

How to Encrypt Excel Connection String while connecting it to SQL server Analysis service?

I am pulling data from SQL Server Analysis service into Excel. I want Connection String To be encrypted. When I go to Data->Connection properties and click on save Password, I am able to see the password. Can any one Suggest me how to encrypt…
Chandu Nandina
  • 11
  • 2
1
vote
1 answer

SQL Server dates are converted to date/time in Analysis Services

I have a database in SQL Server that also has a related tabular database in Analysis Server. One of the tables has columns of type date in SQL Server: If I run a SQL select in SQL Server select * from app_dates , I get the dates: But if I run the…
ps0604
  • 1,227
  • 23
  • 133
  • 330
1
vote
1 answer

Onpremise SSAS Cube Credential refresh issue

We have created SSAS cube connected to Azure Data Explorer using .Net Framework Data Provider For SQL Server. We are using OAuth2 to authenticate data-source. We have configured SQL Server Job to automatically process cube using below command { …
arpan desai
  • 889
  • 2
  • 13
  • 23
1
vote
1 answer

Token expires to SPO list: how can I make this persist for data refreshes?

I have a data connection in my Tabular model that is 2019/1500 compatibility level. I have the model in VS 2019, and am refreshing data from an SPO list. The issue is that when I go to refresh the token expires and I have to manually go to the data…
DisplayedUserName
  • 33
  • 1
  • 4
1
vote
0 answers

How do I sort a column which has a Text Data Format by another a column which has a Text Data Format in a Tabular Project in VS?

I have two columns "Accounting Period" and "Accounting Period Desc" in my Tabular Model as given below. The "Data Format" property of both the above columns are set to "Text". I'm trying to sort the "Accounting Period Desc" column by the…
Panchali Nanayakkara
  • 67
  • 6
1
vote
1 answer

ssas tabular 2016 Many to many relationship

errori'm new here ,and in the ssas tabular modeling, im working on a project and i have to do a many to many relationship in ssas tabular 2016 BUT they give me this probleme. my model is like this where index is note a primary key in both tables and…
mohamed mohamed
  • 11
  • 1
1
vote
1 answer

SSAS error process : A request for a connection ... pool could not be granted

I got this error when I try to process (Full) my cube : The JSON DDL request failed with the following error: Failed to execute XMLA. Error returned: 'OLE DB or ODBC error: A request for a connection from the data source pool could not be granted.…
Ait Joe
  • 13
  • 2
1
vote
1 answer

SSAS Tabular using CSV files from SFTP

I wan to prepare a model in SSAS - Tabular using csv files placed in SFTP Folder.Is there any way I can connect to these CSV files as a source to my SSAS - Tabular Model? If not, what are options I have to get the them to my model? PS: I want to…
Raj Jayaswal
  • 468
  • 1
  • 9
  • 22
1
vote
0 answers

Showing Measure Value only the First Date & Last Date of the Date Slicer Power Bi

I am working on a Power BI Report (which is in direct query mode with SSAS tabular model as source). I need to create two measures opening base and closing base with below condition. opening base should be show value only for the minimum date range…
bmsqldev
  • 2,627
  • 10
  • 31
  • 65
1 2 3
…
57 58