SSAS Tabular model 2022 (Disappear specific data import feature)

Manikant Mahovia 41 Reputation points
2024-04-03T07:21:55.98+00:00

Hi All,

I am unable to find the below feature in SSAS 2022 version, does anyone know how to import specific data into SSAS 2022.

User's image

The screen below appears when importing data from an existing connection in SSAS 2022.
User's image

Thanks in advance.

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
436 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,243 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Amira Bedhiafi 15,046 Reputation points
    2024-04-03T07:59:17.7933333+00:00

    Following the screenshot from the documentation , in the Properties pane for the Model.bim file, change the property, DirectQuery Mode, to On.

    enter image description here

    https://learn.microsoft.com/en-us/analysis-services/tabular-models/enable-directquery-mode-in-ssdt?view=asallproducts-allversions

    0 comments No comments