Power BI embed Azure SQL direct query error Couldn't load the schema for the database model Couldn'

Question

Couldn't load the schema for the database model

Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.
Please try again later or contact support. If you contact support, please provide these details.

Server xxxx.database.windows.net

Database xxxx

Correlation ID6961a444-0a98-0ead-b1b5-95952f16db63

ConnectionType{FieldValue}

Activity IDf13c0c9e-d4d5-410d-91f8-955658d9dfe3

Request ID5b1a8a3e-c687-b3b9-0d9c-1078ac99d16e

TimeWed Nov 22 2017 18:36:45 GMT+0400 (Arabian Standard Time)

Version13.0.3154.166

Cluster URIhttps://wabi-south-east-asia-redirect.analysis.windows.net/

I am using azure sql server direct query with Power bi embed. I have already given privacy level "public" rights to azure db from Power BI desktop.

Does direct query support report filtering ? I am using Power BI embeded javascript SDK.

Imported the reported to Azure and provided correct credentials

All other reports without direct query are working.

eric_zhang · Answer

mak82pk wrote:
Couldn't load the schema for the database model

Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again.Please try again later or contact support. If you contact support, please provide these details.

Server&nbsp;xxxx.database.windows.net
Database&nbsp;xxxx
Correlation ID6961a444-0a98-0ead-b1b5-95952f16db63
ConnectionType{FieldValue}
Activity IDf13c0c9e-d4d5-410d-91f8-955658d9dfe3
Request ID5b1a8a3e-c687-b3b9-0d9c-1078ac99d16e
TimeWed Nov 22 2017 18:36:45 GMT+0400 (Arabian Standard Time)
Version13.0.3154.166
Cluster URIhttps://wabi-south-east-asia-redirect.analysis.windows.net/
&nbsp;
&nbsp;
I am using azure sql server direct query with Power bi embed. I have already given privacy level "public"&nbsp; rights to azure db from Power BI desktop.
&nbsp;
Does direct query support report filtering ? I am using Power BI embeded javascript SDK.
Imported the reported to Azure and provided correct credentials
&lt;add key="powerbi:AccessKey" value="xxxxM9xNxxxxxxxxxT5L0UuRkh6SDhH02/djcCgyaxFodkA==" /&gt;&lt;add key="powerbi:WorkspaceCollection" value="xxx" /&gt;&lt;add key="powerbi:WorkspaceId" value="bf5fxxx0c6-xxxxxx" /&gt;
&nbsp;
All other reports without direct query are working.
&nbsp;

mak82pk
Per my test, DirectQuery works fine in Power BI Embedded. Did you update connection string and credential after importing the pbix file?
&nbsp;
By the way, the legency Power BI Embedded is being deprecated and will continue working&nbsp;till end of June 2018, just consider migrate it to Power BI Service.

mak82pk · Answer

No i&nbsp;did not make any changes to DB after import

eric_zhang · Answer

mak82pk wrote:
No i&nbsp;did not make any changes to DB after import

mak82pk
I don't think this snapshot from Power BI Service has anything to do with the error in your original post. You're using Power BI Embedded workspace collection, right? Have you ever tried to update connection string and credential as in my previous reply?

mak82pk · Answer

Yes but the code i am using does not take db connection string&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; public DashboardController()&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.workspaceCollection = ConfigurationManager.AppSettings["powerbi:WorkspaceCollection"];&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.workspaceId = ConfigurationManager.AppSettings["powerbi:WorkspaceId"];&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.accessKey = ConfigurationManager.AppSettings["powerbi:AccessKey"];&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; this.apiUrl = ConfigurationManager.AppSettings["powerbi:ApiUrl"];&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; public async Task&lt;ActionResult&gt; Report(string reportId)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; using (var client = this.CreatePowerBIClient())&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var reportsResponse = await client.Reports.GetReportsAsync(this.workspaceCollection, this.workspaceId);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var report = reportsResponse.Value.FirstOrDefault(r =&gt; r.Id == reportId);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var embedToken = PowerBIToken.CreateReportEmbedToken(this.workspaceCollection, this.workspaceId, report.Id);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; var viewModel = new ReportViewModel&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; {&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Report = report,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; AccessToken = embedToken.Generate(this.accessKey)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; };&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; return View(viewModel);&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }

eric_zhang · Answer

mak82pk
After importing the pbix file in direct query mode to Azure SQL to Power BI Embedded workspace on Azure, have you updated the connection string and credential(see how)? This is the prerequisite for embedding.

Forum Discussion

Power BI embed Azure SQL direct query error Couldn't load the schema for the database model Couldn'

5 Replies

Related content

Database connectivity.

Mirrored Snowflake Database Storage

Fabric Mirrored Databases

Mirrored Databases Auditing

Moving Mirrored SQL database between workspace