Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi
I'm currently using Direct Query to connect Azure SQL Database with PowerBI.
I could see model on Power BI Desktop although couldn't see any data after publish and shows up an error "Could not load model".
I've tried to get and see a data with Database Admin Account although still not be possible.
Is there any way to solve this issue?
PowerBI Desktop Version: 2.80.5803.1061 64-bit
PowerBI Account: PowerBI Pro
OS Version: Windows 10
Thank you,
Solved! Go to Solution.
@Anonymous
Please submit a support ticket with the erro message to investigate the issue.
@Anonymous
Please try with the below steps.
1. Navigate to the workspace >> dataset >> dataset settings >> Data source credentials >> Edit Credentilas.
Note:- Use same credntilas and privacy levels in Desktop and Service.
If the issue is persits, Please share the error details.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
In case it does not help, please provide additional information and mark me with @
BR
venal.
Hi venal,
I tried steps using Database Admin Account credentials, although still not works.
Here is error details,
Unable to load the model
Unable to load the model schema associated with this report. Make sure you can connect to the server and try again.
You can try again later or contact support. If you would like to contact support, please contact us with the following details
Activity ID 65165e3d-ab9f-47cf-a953-69c09a9933f1
Request ID 3ed66d91-9a43-bda9-6a81-a27a6f79e5b5
Correlation ID ce7a47e6-3c50-fa32-8e3e-44b7afa84ef0
Time Mon 18 May 2020 17:31:00 GMT+0900 (Japan Standard Time)
Version 13.0.13248.257 of the service
Client Version 2005.1.00976-train
Cluster URI https://wabi-west-us-redirect.analysis.windows.net/
Thank you,
@Anonymous
how was the behaviour in power bi desktop?
Any Append/Merge?
If the issue is persists, please submit a ticket to investigate the issue,
Power BI Desktop's credential was Database Admin Account, so I reauthed Power BI (Browser) with Database Admin Account.
So I have nothing done with Power BI Desktop.
Should I merge again to Power BI (Browser)?
@Anonymous
Please submit a support ticket with the erro message to investigate the issue.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
39 | |
26 | |
21 | |
19 | |
10 |
User | Count |
---|---|
41 | |
36 | |
34 | |
20 | |
14 |