Published
Edited
Mar 5, 2020
2 stars
viewof clientId = storedText({"key": "pbi.clientId"})
viewof reportId = storedText({"key": "pbi.reportId"})
viewof dataSetId = storedText({"key": "pbi.datasetId"})
msalConfig = ({
auth: {
clientId: clientId,
authority: "https://login.microsoftonline.com/organizations",
//redirectURI: "http://localhost:8087"
},
cache: {
cacheLocation: "localStorage",
storeAuthStateInCookie: true
}
});
myMSALObj = new msal.UserAgentApplication(msalConfig);
accessToken = {
const tokenRequest = {
scopes: [ "https://analysis.windows.net/powerbi/api/App.Read.All"]
};
return new Promise((resolve, reject) => {
myMSALObj.acquireTokenSilent(tokenRequest)
.then(response => {
mutable userName = response.account.name;
resolve(response.accessToken)
})
.catch(err => reject(err))
})
}
reportsAndDatasets = ({
"datasets": [
{
"id": dataSetId
}
],
"reports": [
{
"id": reportId
}
]
})
generateTokenResponse = d3.json('https://api.powerbi.com/v1.0/myorg/GenerateToken', {
method:"POST",
body: JSON.stringify(reportsAndDatasets),
headers: {
"Content-type": "application/json; charset=UTF-8",
"Authorization": `Bearer ${accessToken}`
}
})
reportConfig = ({
type: 'report',
tokenType: pbi.models.TokenType.Embed,
accessToken: embeddedToken,
embedUrl: "https://app.powerbi.com/reportEmbed",
id: reportId,
permissions: pbi.models.Permissions.All,
viewMode: pbi.models.ViewMode.Edit,
settings: {
filterPaneEnabled: false,
navContentPaneEnabled: false,
pageView: "fitToWidth", // "actualSize",
/* Uncomment if you require a custom layout
layoutType: models.LayoutType.Custom,
customLayout: {
pageSize: {
type: models.PageSizeType.Custom,
width: 1500,
height: 1200
},
}
*/
}
})
report = window.powerbi.embed(elReport, reportConfig);
filters = [
{
"$schema":"http://powerbi.com/product/schema#basic",
"target":{"table":"Detailed Metrics 1","column":"Sub Category"},
"filterType":1,"operator":"In",
"values":subcategories,
"requireSingleSelection":false
}
]
report.setFilters(filters)
md`# Obtaining clientId, reportId & datasetId`
md`## ClientId
We need to register an App in Azure Portal (or
* CReate a new APplication (NAtive)
* In Azure Portal: allow implicit flow (in manifest)
* Confifure Web redirect URI
* Configure API permision Directory.AccessAsUser.All`
window.location.href
style_bootstrap
import {style_bootstrap, storedText} from "@elaval/utils"
import {checkbox, button} from "@jashkenas/inputs"
pbi = require('powerbi-client@2.8.0/dist/powerbi.js')
msal = require('msal@1.2.1/dist/msal.js')
Purpose-built for displays of data
Observable is your go-to platform for exploring data and creating expressive data visualizations. Use reactive JavaScript notebooks for prototyping and a collaborative canvas for visual data exploration and dashboard creation.
