I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector & attaching the screenshot of the connector image. Compatibility level of the SSAS Tabular model: 1500 Working with Latest VS 2022. Please help me understand as this link shows https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-datasource#tab1400a there is an option to connect but I dont have it

It's possible you have an older model version. If I create a model with the older compat level, I see those options that you see above. If I create a model with the new compat level (you can change the default in Tools > Options > Tabular Model Designer) or on your existing project, you get the modern data experience (the one that looks like Power BI) for connections instead.

Thanks Greg Low Hi Aravind K Pachaiyappan As Greg pointed out, the issue you are experiencing is due to compatibility level. it seems like you are using Compatibility level 1200. I was able to repro the issue from my end. When I choose the compatibility level - 1200, I see the same options that you see. But when I use the compatability level 1400 or 1500 or 1600, I see the ADLS connection. With compatibility level -1200: With compatibility level -1400 or above I hope this helps.

I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector

Aravind K Pachaiyappan 0

I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector & attaching the screenshot of the connector image.
Compatibility level of the SSAS Tabular model: 1500

User's image

Working with Latest VS 2022. Please help me understand as this link shows https://learn.microsoft.com/en-us/azure/analysis-services/analysis-services-datasource#tab1400a there is an option to connect but I dont have it

Aravind K Pachaiyappan 0 Reputation points

2024-05-31T06:55:15.9533333+00:00

Attaching my screenshot which I missed
Bhargava-MSFT 31,121 Reputation points Microsoft Employee

2024-05-31T18:06:47.4266667+00:00

Hello Aravind K Pachaiyappan,

It seems like you are trying to create a tabular project using SQL Server Analysis Services( not Azure Analysis Services).

Azure Data lake blob storage is not a supported data source for SQL Server Analysis Services.

Please see the below document which has the list of supported data sources for SQL analysis services.

https://learn.microsoft.com/en-us/analysis-services/tabular-models/data-sources-supported-ssas-tabular?view=asallproducts-allversions

I hope this answers your question. Please let me know if you have any further questions.
Aravind K Pachaiyappan 0 Reputation points

2024-06-03T04:52:46.3566667+00:00

Hi , I am creating the Tabular model from Visual Studio 2022 (latest version) & the connection is to Azure - which means its the Azure Analysis services but the model is being created in Visual studio like how we usually do - attaching the screenshot of the AAS below for reference:
Please advice further & appreciate your help.
Bhargava-MSFT 31,121 Reputation points Microsoft Employee

2024-06-03T21:52:16.81+00:00

Thanks for the additional details.

What is your Visual studio version?

I am using "Version 17.10.1" and not able to see blob storage resource. If you are using the same version, can you please try with a different version?
Aravind K Pachaiyappan 0 Reputation points

2024-06-06T07:09:55.4366667+00:00

@Bhargava-MSFT Yes I'm using the exact same version of Visual studio "Version 17.10.1" , but aren't we supposed to use this version only which is the latest. Not sure if this is a bug from Microsoft Visual studio (If so, please help me understand) & also advise which version would be suitable for this (also tried with the previous version of 17.10.1 & it did not work.

2 answers

Greg Low 1,770 Reputation points Microsoft Regional Director

2024-06-06T08:04:04.1133333+00:00

It's possible you have an older model version. If I create a model with the older compat level, I see those options that you see above. If I create a model with the new compat level (you can change the default in Tools > Options > Tabular Model Designer) or on your existing project, you get the modern data experience (the one that looks like Power BI) for connections instead.
Please sign in to rate this answer.
Aravind K Pachaiyappan 0 Reputation points

2024-06-06T11:32:27.2066667+00:00

@Greg Low Hi Greg, My model's compatibility level is 1500 & its quite latest & still dont have that options available for ADLS connection

Aravind K Pachaiyappan 0 Reputation points

2024-06-10T06:32:20.5+00:00

@Bhargava-MSFT Please see my below screenshot which shows the compatibility level 1500

Bhargava-MSFT 31,121 Reputation points Microsoft Employee

2024-06-10T17:00:13.7966667+00:00

Aravind K Pachaiyappan

I was referring the compatibility level while connecting from the visual studio.

Please see my below screenshot.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Bhargava-MSFT 31,121 Reputation points Microsoft Employee

2024-06-06T17:50:37.9966667+00:00

Thanks Greg Low

Hi Aravind K Pachaiyappan

As Greg pointed out, the issue you are experiencing is due to compatibility level.
it seems like you are using Compatibility level 1200.

I was able to repro the issue from my end. When I choose the compatibility level - 1200, I see the same options that you see.

But when I use the compatability level 1400 or 1500 or 1600, I see the ADLS connection.

With compatibility level -1200:

With compatibility level -1400 or above

I hope this helps.
Please sign in to rate this answer.
Aravind K Pachaiyappan 0 Reputation points

2024-06-11T11:29:35.5166667+00:00

@Bhargava-MSFT Greg Low I thank both of you for taking the time to reply to my queries.

So for some reason I'm not able to see Azure from 1500 Compatibility level but when I create a model with 1600 - I was able to see Azure & the other options

One last query - Do you think we can extract the data directly from ADLS Gen2 (Gold layer views) instead of using the middle-man (Azure Synapse-SQL DW) as its costing us extra as we don't use SQL DW except for storing & pushing the data to AAS. This would help me a lot!
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

I'm using Visual studio 2022 & creating a tabular model but not able to connect to Azure Data lake blob storage - not even able to see that connector

2 answers

Your answer