Couldn't load the schema for the database modelCouldn'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.
<add key="powerbi:WorkspaceCollection" value="xxx" />
<add key="powerbi:WorkspaceId" value="bf5fxxx0c6-xxxxxx" />All other reports without direct query are working.
By the way, the legency Power BI Embedded is being deprecated and will continue working till end of June 2018, just consider migrate it to Power BI Service.
No i did not make any changes to DB after import
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?
Yes but the code i am using does not take db connection string
this.workspaceCollection = ConfigurationManager.AppSettings["powerbi:WorkspaceCollection"];
this.workspaceId = ConfigurationManager.AppSettings["powerbi:WorkspaceId"];
this.accessKey = ConfigurationManager.AppSettings["powerbi:AccessKey"];
this.apiUrl = ConfigurationManager.AppSettings["powerbi:ApiUrl"];
public async Task<ActionResult> Report(string reportId)
using (var client = this.CreatePowerBIClient())
var reportsResponse = await client.Reports.GetReportsAsync(this.workspaceCollection, this.workspaceId);
var report = reportsResponse.Value.FirstOrDefault(r => r.Id == reportId);
var embedToken = PowerBIToken.CreateReportEmbedToken(this.workspaceCollection, this.workspaceId, report.Id);
var viewModel = new ReportViewModel
Report = report,
AccessToken = embedToken.Generate(this.accessKey)