Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is there a straightforward way to programmatically filter individual embedded tiles? I'm trying to follow this: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-power-bi-tile but the syntax including table name and column name doesn't seem to work for me--double checked capitalization etc. against Power BI desktop model view, but there is no change in my embedded tile. I'm even trying to set an initial value and that's not working, is programmatically managing filter state on individual tiles simply forbidden?
some code to illustrate my point--front end:
let filter = {
$schema: "http://powerbi.com/product/schema#basic",
target: {
table: "Data",
column: "Company"
},
values: ["Apple"],
filterType: 1, // pbi.models.FilterType.BasicFilter
requireSingleSelection: true // Limits selection of values to one.
}
const embedConfiguration: IEmbedConfiguration = {
type: "tile",
tokenType: models.TokenType.Embed,
accessToken,
embedUrl,
id: tileId,
dashboardId: dashboardId,
filters: [filter],
};
and then using an embed url of
https://app.powerbi.com/embed?dashboardId=myDashboardId&tileId=myTileId&config=myConfig&$filter=Data/Company eq 'Apple'
, and yet I cannot see the effect of either of these efforts. Am I doing it wrong? Is there a better option?
HI @Anonymous,
AFAIK, current Power BI JavaScript not supported filtering Dashboards and Tiles.
Did you embed your dashboard into the power apps(Canvas apps) that you can use power app features to do advanced operations with embedded contents? If you change the type part to other supported values, did these function works?
Notice: power apps and power bi apps are different products and host on different platforms.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
23 | |
3 | |
2 | |
2 | |
2 |