Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

We have had an open support ticket with Microsoft on 2 error scenarios and were able to resolve them today after following the below instructions.  I wanted to add to this post just in case it could potentially help someone else.

Scenario 1: When trying to add a local model after establishing the live connection:

• An error occurred while loading the model. Verify that the connection information is correct and that you have permissions to access the data source.

 Scenario 2: When we make the local model first and then try to add the live dataset connection we then get this error:
Cannot load model

• Allows us to select the Dataset we would like to add to the model. Once we click "Create" it gives the below error:
• We couldn't connect to your Analysis Services database. Double check that your server and database names are correct, and make sure you have permission to access them.
  Bad Request
  Technical Details:
  RootActivityId: (ID)
  Date (UTC): (Date/Time)

To get this feature to work you must have the below criteria met:

From Microsoft Support:

In addition to the XMLA Endpoint property being enabled read-write by the capacity admin, the tenant-level setting Allow XMLA endpoints and Analyze in Excel with on-premises datasets must be enabled in the admin portal. If you need to generate AIXL files that connect to the XMLA Endpoint, the tenant-level setting Allow live connections should also be enabled. These settings are both enabled by default.