How to connect to data using DAX

Hi penguins_fly ,

DAX, which stands for Data Analysis Expressions, is a formula language used in Power BI for creating custom calculations on data already in your model. It's primarily used for data analysis and creating measures and calculated columns within your Power BI datasets. DAX does not directly connect to or import data. Instead, it works on data that has already been imported into Power BI.
To connect to data sources like SQL, Excel, web, and CSV, Power BI uses the "Get Data" feature available in Power BI Desktop. This process is part of the data modeling phase, where you import data into Power BI before applying any DAX calculations.
But in Power Query you can use M function to connect to the data source, please confirm if this is the question your interviewer is asking? But it is true that DAX cannot connect to the data source.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.