Error in Power BI Service report loading. The same report on Power BI desktop is working fine

[Anonymous]

Hi community, 

I would like to know how to solve this issue when I go to my report on PowerBI Service:

Cannot load model

Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.

Please check the technical details for more information. If you contact support, please provide these details.

Underlying Error: PowerBI service client received error HTTP response. HttpStatus: 400. PowerBIErrorCode: QueryUserError

QueryUserError: DataSource.Error: [ccon]ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: Bad Status: Unrecognized response with no error message header. Status code: 400.. DataSourceKind = Databricks. DataSourcePath = {"host":"no show for security reasons","httpPath":"no show for security reasons"}. OdbcErrors = #table({"SQLState", "NativeError", "Message"}, {}). [/ccon]. The exception was raised by the IDbCommand interface.

Correlation ID: dddd0384-76a0-bd49-8855-c0bd747d8c82

Activity ID: 4c0f7e22-dc78-4d7c-babd-8aa2c7b21def

Request ID: b7ba619d-6261-8462-e073-f60e2b7b7545

Time: Fri Jun 30 2023 08:28:36 GMT+0200 (Central European Summer Time)

Service version: 13.0.20957.59

Client version: 2306.3.14415-train

Cluster URI: https://36da45f1dd2c4d1faf135abe46b99921-api.analysis.windows.net/

Scenario:

- My datasource connection is Azure Databricks.

- I'm using DirectQuery.

- I'm not using calculated tables or similar.

- In PowerBI desktop everything is ok.

- I have tried this possible solutions without succesfully results:

https://www.youtube.com/watch?v=JJfjI3stnsA

https://stackoverflow.com/questions/73497033/connectivity-issue-from-power-bi-to-azure-databricks

- About the connector:

My authentication is by Azure Active Directory.

Has activated the SSO via Azure for DirectQuery queries.

Is working fine. Status:Online.

- About dataset:

Data source credentials for Databricks are ok.

No Gateway needed.

Refreshing updated sucessfully

- I have the admin role of my PowerBI service workspace where I'm publishing my report

- I have PowerBI Pro license

- The file size is: 1321 KB

- The data that I load from Databricks is around 1Mb

Thanks in advance 🙂 

Yineth

[Anonymous · Accepted solution]

Hello everyone, I have solved this issue with the help of technical staff team of Microsoft. 

There a configuration that need to be setted to guarantee the proper load of the model:

The "Report viewers can only access this data ..." checkbox should be disabled.

Thanks.