let clientId = "8eee109b-30a5-40d7-9f80-d1743745266b";
let tenant = "019dd3cd-6d48-4d28-aafc-00f1ea5bf100";
let authority = "https://login.microsoftonline.com/" + tenant;
const msalConfig = {
auth: {
clientId: clientId,
authority: authority,
},
cache: {
cacheLocation: "localStorage",
storeAuthStateInCookie: false,
},
system: {
allowRedirectInIframe: true,
asyncPopups: true
}
};
const loginScopes = {
scopes: [
"openid",
"profile",
"email",
"https://analysis.windows.net/powerbi/api/Report.Read.All",
]
};
const requestScopes = {
scopes: [
"https://analysis.windows.net/powerbi/api/Report.Read.All",
]
};
$(async function () {
const params = new URLSearchParams(window.location.search)
let reportId = params.get("reportId");
if (!reportId) {
DisplayError("!!The report is not configured with a valid report ID.");
return;
}
let aadApplication = new msal.PublicClientApplication(msalConfig);
// check if there is a cached identity for user
const currentAccounts = aadApplication.getAllAccounts();
if (currentAccounts.length > 0) {
// user identity found - get access token and embed report
accountId = currentAccounts[0].homeAccountId;
let tokenRequest = requestScopes;
tokenRequest.account = accountId;
let tokenResponse = await aadApplication.acquireTokenSilent(tokenRequest);
EmbedReport(tokenResponse.accessToken, reportId);
}
else {
// user identity not found - show Sign-in button added xfilter
$("#signin").click(async function () {
let aadApplication = new msal.PublicClientApplication(msalConfig);
aadApplication.loginPopup(loginScopes)
.then(function (response) {
EmbedReport(response.accessToken, reportId);
})
.catch(function (error) {
DisplayError("!User login was not successful. Please try again.");
});
});
$("#toolbar").show();
}
});
let EmbedReport = function (token, reportId) {
$("#toolbar").hide();
$("#error-panel").hide();
let padding = 8;
$("#report-container")
.width(window.innerWidth - padding)
.height(window.innerHeight - padding);
$("#loading")
.width(window.innerWidth - padding)
.height(window.innerHeight - padding)
.show();
let models = window["powerbi-client"].models;
//ikleiner
//https://community.powerbi.com/t5/Developer/Embedded-Report-add-filter-to-EmbedConfig/m-p/199918#M637...
//make sure you retype 'single quotes' if you copied from somewhere else
//added ikleiner 8/29/22
//let xfilter = params.get("filter");
//let xtable = params.get("table");
//let xcolumn = params.get("column");
//let xvalue = params.get("value");
const params2 = new URLSearchParams(window.location.search)
let xtable = params2.get("table");
let xcolumn = params2.get("column");
let xvalue = params2.get("value");
window.alert("<<table: >> "+xtable+ "<< column: >> "+xcolumn+"<<value: >>"+xvalue+"<<reportId: >>"+reportId );
//let xtable = 'Geo';
//let xcolumn = 'State';
//let xvalue = 'NJ'
const Filter1 = {
$schema: "http://powerbi.com/product/schema#advanced",
target: {
table: xtable,
column: xcolumn
},
operator: "Eq",
values: [xvalue]
}
const Filter2 = {
$schema: "http://powerbi.com/product/schema#advanced",
target: {
table: xtable,
column: xcolumn
},
operator: "Eq",
values: [xvalue]
}
//modified filters: to pass basicFilter construct 8-31-22 ikleiner
reportLoadConfig = { type: "report",
id: reportId,
embedUrl: "https://app.powerbi.com/reportEmbed",
accessToken: token,
tokenType: models.TokenType.Aad,
filters: [Filter1], //filter array here -can add multiple blocks like [filter1, filter2]
settings: {
filterPaneEnabled: true,
navContentPaneEnabled: false,
personalBookmarksEnabled: true,
panes: {
bookmarks: { visible: true },
pageNavigation: { visible: true }
}
}
};
let reportContainer = document.getElementById("report-container");
let report = powerbi.embed(reportContainer, reportLoadConfig);
//Add filter to the report
report.on("loaded", function () {
$("#loading").hide();
$("#report-container").show();
});
report.on("error", function (error) {
console.log(error.detail.detailedMessage);
DisplayError(error.detail.detailedMessage);
$("#loading").hide();
});
}
let DisplayError = function (msg) {
$("#error-panel")
.text("Error: " + msg)
.show();
}
