Cannot load model

[miloooooz]

I got this error when I try to open the report I published to PBI service. At the very beginning I thought it was me not connect my database to service, but the error still exists after I setup the data source credential. I have no idea what is going on. Any help would be appreciated.

Underlying Error: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: QueryUserError
QueryUserError: Login failed for user '<token-identified principal>'.. The exception was raised by the IDbConnection interface.
Correlation ID: a965fed1-a08d-052f-ce16-332c54684790
Activity ID: bc55f587-63e2-4bc7-a8f0-60c025bb57cb
Request ID: a9cdf434-5a41-f8b3-3eec-c892b46e6178
Time: Sun Sep 26 2021 15:15:17 GMT+0800 (China Standard Time)
Service version: 13.0.16890.50
Client version: 2109.4.07853-train
Cluster URI: https://df-msit-scus-redirect.analysis.windows.net/

[ponnusamy]

@miloooooz : I would re-publish the report and try again. In the past, I had similar issues resolved by re-publishing.

If this post helps, then please consider Accepting it as the solution, Give Kudos to motivate the contributors.

[miloooooz]

I tried and it still doesn't work, really weird.

[aj1973]

Hi @miloooooz 

Can you refresh the report in your desktop? What type of source is it? Does it need a Gateway?

[miloooooz]

1. Yes I can refresh the report from the desktop.

2. The visual that cannot display uses SQL server as data source, I added the data source into the gateway, but the dataset setting says the gateway is not cofigured correctly. But do I really need a gateway to display my current report? I thought gateway is necessary only if I need to refresh the report. Anyways, I added the SQL server database into the gateway, but it shows like below. I don't know if it is the problem of gateway.

[aj1973 · Accepted solution]

Indeed you need a gateway, On premises Gateway. Or use that personal Gateway installed in your Laptop. But if the source is not in your Laptop then you need a to install an On-Prem Gateway

[miloooooz]

Problem solved, need to set database credential or add source to the gateway and wait for it. Thank you very much for your answer.

[miloooooz]

I do have the gatway mapping to the SQL server data source, now I think the problem is the mapping for my local file for other visuals within the same report. I don't know why but the gateway gives 400 error when I tried to add local file to the data source.