PowerBI Service model issue for report after publish

[Anonymous]

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,

[venal]

@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.

[Anonymous]

@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,

[venal]

@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,

https://powerbi.microsoft.com/en-us/support/

[Anonymous]

@venal 

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)?

[venal · Accepted solution]

@Anonymous 

Please submit a support ticket with the erro message to investigate the issue.

[Anonymous]

@venal 

Thank you I will submit a support ticket.