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 Reputation points
2024-05-31T06:52:56.3233333+00:00

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

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
443 questions
SQL Server Analysis Services
SQL Server Analysis Services
A Microsoft online analytical data engine used in decision support and business analytics, providing the analytical data for business reports and client applications such as Power BI, Excel, Reporting Services reports, and other data visualization tools.
1,258 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Greg Low 1,670 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.


  2. BhargavaGunnam-MSFT 28,531 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.

    User's image

    With compatibility level -1200:

    User's image

    With compatibility level -1400 or above User's image

    I hope this helps.