Forum Discussion
Error in Power BI Service report loading. The same report on Power BI desktop is working fine
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
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:
- 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