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?
