Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am using power BI embedded in my web application. I am using javs script library 2.0 provided on Git. my filter is working as desired. The problem is report is loaded with all the data and filter is getting applied there after, and hence user will be able to have a glimpse of all records for which he soes not have access. How can I reduce this delay. We have also implemented RLS in data source which is a SSAS cube, how can we pass user information to PBI?
Follwoing is the java script code to call PBI report
var defaultFilter = {
target: {
table: "Table1",
column: "Column1"
},
operator: "In",
values: ["H "]
};
var embedConfiguration = {
type: 'report',
accessToken:’Token’,
id: ReportId',
embedUrl: 'https://embedded.powerbi.com/appTokenReportEmbed',
settings: {
filterPaneEnabled: true
}
};
var $reportContainer = $('#reportContainer');
var report = powerbi.embed($reportContainer.get(0), embedConfiguration);
report.on('loaded', event => {
report.getFilters()
.then(filters => {
filters.push(defaultFilter);
return report.setFilters(filters);
});
});
Any solution here?
Step by step to see this delay, since this Angular demo default filter doesn't work and javascript demo have no interface way to do that:
Come on.. we are already defining the default filter BEFORE to create the object. We know this daley can be fixed.
We are trying to do a workaround to use the same report for more than one client. Otherwise it will be impossible to managing that. Pleaseee, provide parameters for powerbi service!
Hey @nirajdubey this link really save my life 🙂 I'm not sure if it is applied for SASS
https://powerbi.microsoft.com/en-us/documentation/powerbi-developer-embedded-rls/
ONE line difference and a small adjustment on power bi desktop.
Also, they updated the sample https://github.com/Microsoft/PowerBI-Developer-Samples/tree/master/App%20Owns%20Data
Enjoy
I guess you can't apply RLS in SSAS, try the RLS in power bi.
User | Count |
---|---|
18 | |
11 | |
5 | |
4 | |
3 |