Forum Discussion
Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Hi jeroenterheerdt , we are unfortunately still running into the below connection errors. This is when trying to connect to any dataset, including a test dataset that has very little data loaded (from Excel). The error comes when we try to add the local model, or try to take a local model and add a live dataset connection (Zarek seems to be having these issues as well). I have the latest Power BI Desktop Version: 2.88.721.0
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: 8d8dba2e-4c1a-4f50-a68e-b0375e4bac61
Date (UTC): 12/21/2020 7:58:11 PM
There is details log I can send you if you would like, too. Thank you for the help on this, my team is very excited to try out this functionality!!
I'm getting the same errors as above (An error occurred while loading the model. Verify that the connection information is correct and that you have permissions to access the data source.) and assume it shouldn't be a deployment issue now - has there been any updates on this error? My colleague gets the same, we both tried connecting to datasets in premium workspaces
- jeroenterheerdt5 years ago
Microsoft Employee
can you please open a support case for this? If you can't let me know and we figure something out.
- soldous5 years ago
Advocate II
Hi jeroenterheerdt, MBonnett, jane01,
was the issue resolved with helping of the support ticket? We still have the same issue in our org.
Thank you for an update.