Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi, I have a SharePoint site to manage projects, each time a new project is started, a new site is created for the project based off a template. In the new project site, I want to embed a power BI report (as part of the template) to show data for that project (the report currently holds data for all projects but can easilly be filterted). I can get as far as embedding the report in the site, and using the Power BI Developer Sandbox, I can set a report filter using a predefined filter value for the project code like below. But where I have gotten stuck is I want to be able to pass the project code from the SharePoint site and use it as the value in the filter. Not sure it's even possible though.
const basicFilter = {
$schema: "http://powerbi.com/product/schema#basic",
target: {
table: "Projects",
column: "Project Code"
},
operator: "In",
values: ["123456"],
filterType: models.FilterType.BasicFilter,
requireSingleSelection: true
}
await report.updateFilters(models.FiltersOperations.Add, [basicFilter]);
Solved! Go to Solution.
Hi @russell80 ,
The Get a site resource API Could retrieve properties and relationships for a site resource. A site resource represents a team site in SharePoint.
Please check if this API could help you.
For more details, please refer to:
Get a SharePoint Site - Microsoft Graph v1.0 | Microsoft Learn
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @russell80 ,
The Get a site resource API Could retrieve properties and relationships for a site resource. A site resource represents a team site in SharePoint.
Please check if this API could help you.
For more details, please refer to:
Get a SharePoint Site - Microsoft Graph v1.0 | Microsoft Learn
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
3 | |
2 | |
2 | |
2 | |
1 |
User | Count |
---|---|
10 | |
4 | |
3 | |
2 | |
2 |