Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Advocate IIHi tessahurr ,
First off, thank you and the team for the work on this! This is something my team has been waiting for, and is super excited about - we can't wait to try it out... but are currently running into errors.
We are trying to connect to datasets in our workspace using this new functionality and are encountering the below error 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
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: 30c344e7-833a-42c8-b974-4a8b2202f1ad
Date (UTC): 12/17/2020 3:13:34 PM
We should have access to the datasets 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, and once again - thank you for the work on this feature!!
- jeroenterheerdt
can you give us more details on the type of workspace (pro/premium) and the model? Are you connecting to a model in "My Workspace"? Does the model have a measure-only table by any chance?
- MBonnett
jeroenterheerdt thank you for the response!
This is in a Premium Capacity Workspace and I am trying to connect to a very basic model with no measure tables (I have tested many different scenarios to try to get around this error), just to see if I can get it to work. My co-workers are having the same issue as well. Thanks again for any assistance!
- jeroenterheerdt
Interesting. You might be victim of deployment delays. Try again early next week. If it still does not work by then, please report back. Thanks, thanks.
