Forum Discussion
Power BI embed Azure SQL direct query error Couldn't load the schema for the database model Couldn'
No i did not make any changes to DB after import
mak82pk wrote:
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?
- mak82pk8 years agoHelper I
Yes but the code i am using does not take db connection string
public DashboardController()
{
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)
};
return View(viewModel);
}
}- Eric_Zhang8 years agoMicrosoft Employee
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.