CODEWITHSUNDEEP
sqlvisual-studiossastabular
Simon
Simon

Reputation: 13

Visual Studio SSAS Tabular Model does not show existing connections

I'd like to write a SQL Query to extract data from a SQL Table into the SSAS Table. I do not have this option available, as normally I should go over 'Model' > 'Existing Connections'. In my case, there is no option 'Existing Connections'. Anything I could be doing wrongly?

Upvotes: 1

Views: 7107

Answers (5)

CyNETT
CyNETT

Reputation: 51

As "Klaus K" mention: "Existing Connections" reappear, but ClientCompatibilityLevel = 400 removes Calculation Groups, so not very useful for me..

Upvotes: 0

Darwin Lloyd
Darwin Lloyd

Reputation: 11

I use VS2017 : In the "Tabular Model Explorer" right click on the 'Data Source' and you can see the option "Import New Tables".

Hope this helps.

Upvotes: 1

olf
olf

Reputation: 872

I know it's an old question, but I had the same problem today. It happens each time I open my project in VS 2017.

My solution is to open my Data sources and enter my credentials again. I guess that VS2017 does not have access to the data when you open the project (it probably does not save the password) and therefore it cannot retrieve the data.

Upvotes: 0

Dominic
Dominic

Reputation: 21

Had the same issue: The option doesn't show in the Model menu. Instead, I opened the Tabular Model Explorer window (View -> Other Windows). There you find a folder Data Sources containing the existing data sources. Select the data source and in the context menu you will find the Import New Tables option.

Upvotes: 2

Klaus K.
Klaus K.

Reputation: 1

Use a text editor to open the .bim file in the project. Scroll down the end of the file. You should see something like:

"annotations": [
  {
    "name": "ClientCompatibilityLevel",
    "value": "400"
  }

If the Value is 500 change it to 400. Save and reopen the solution. The "Existing Connections" should reappear in the Model dropdown. Had the same issue. I'd made a prior backup before it disappeared, which when I opened the backup solution it was there. So I compared the files, made the change and it reappeared.

Upvotes: 0

Related Questions