1

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:

  1. 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.

  2. 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.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Enrique Alberto Perez Delgado
  • 25
  • 1
  • 7

1 Answers1

0

Sounds like you're using Windows credentials. Have you tried using Database credentials?

enter image description here

Mike Petri
  • 570
  • 3
  • 10