Given a scenario where you need to connect to and query datasets using the XMLA endpoint in Fabric, what steps would you take to ensure that you can successfully execute a DAX query to retrieve data from a tabular model? Describe the process in detail.