Cannot deploy SSAS Tabular Model in Visual Studio 2019
I am trying to deploy a Tabular Model in a local instance of SSAS, I am using SQL Server 2019 Developer edition, and data of the model comes from the example ContosoDW database which is stored in a local instance of SQL Server.
I had two scenarios:
First, I connected using "Impersonate service account", but when I deployed the model it just deployed the metadata and not the tables (no error showed), so there is no data in the model.
Then, I changed to "Impersonate account", but after the tables were imported their names turned light gray and I wasn't able to select them, very weird.
I think it has something to do with the impersonation options and how to configure them, I am learning SSAS Tabular with a book, but the impersonation weren't available at the time.
Sounds like you're using Windows credentials. Have you tried using Database credentials?
- Query to concatenate row data in each group
- Combine 2 SQL Statements
- Converting SQL server timestamp to an epoch timestamp
- Change Date format from yyyy-mm-dd to mm/dd/yyyy Derived Column
- How do you send email with TSQL using a Agent Operator instead of an email address?
- Spark sending LIMIT to SQL Server on display function
- How can I manage Azure SQL user/login/credentials
- Can't add members to SSAS role through Visual Studio
- How to use Charindex for one or the other character
- SQL want to calculate time hours and mints of each emp
- Incorrect Syntax near ',' in SQL query execution in Spring JPA but executes successfully in database
- How to make multiple select into on the same table?
- Invoking a stored procedure with all combinations of values stored in multiple single-column tables
- Get Value From Json object contain table column using SQL Query
- Compute count(*) of unique occurrences into new column without group by in a single select query
- Is there any better option to apply pagination without applying OFFSET in SQL Server?
- How to get a list of tables with composite primary key in SQL Server?
- Calculating churn rate in SQL: how can I display both churned and not churned customer in % in a single query?
- How can you tell what Tables are taking up the most space in a SQL Server 2005 Database?
- What represents a double in sql server?
- Strange behavior of symfony doctrine during phpunit test - field becomes null in database
- Connecting SQL Server on Docker to Python
- Import multiple rows into a temp table in one round trip via SqlDataRecord
- How to find all trigger associated with a table with SQL Server?
- How to pass connection parameter "ApplicationIntent=ReadOnly" when using pymssql
- Incorrect syntax near ''
- SSRS Query execution failed for dataset
- Insert leading spaces, then the value to a varchar(10) column
- How to use order by with union all in sql?
- Is it good to create a nonclustered index on a column of type varchar?