My team is trying to connect to datasets in our workspace using the new DirectQuery for Power BI datasets and Analysis Services functionality and are encountering connection errors.
Power BI Desktop Version: 2.88.721.0
Connecting to a Power BI Premium Capacity
Attempted connecting to many different types of models in the Power BI service, even a basic model containing 1 excel sheet to see if we could get it to work
Dataflows work without issue, and connecting to 1 Live Dataset works without issue
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.
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: 8d8dba2e-4c1a-4f50-a68e-b0375e4bac61 Date (UTC): 12/21/2020 7:58:11 PM
We have access to the datasets and workspace so I don't know why we would be getting these errors. A single live connection works fine, but when we try to add the local model to create the composite model we get the errors. Does anyone have any thoughts on what we are missing?
Thank you for any help with this!
+ @jeroenterheerdt (additional details pertaining to the errors are below in additional post)