'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?

sqlvisual-studiossastabular


Solution 1:[1]

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.

Solution 2:[2]

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.

Solution 3:[3]

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.

Solution 4:[4]

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.

Solution 5:[5]

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

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 Dominic
Solution 2
Solution 3 Klaus K.
Solution 4 olf
Solution 5 CyNETT

Related Questions