Forum Discussion
Report Builder - Paginated Report Parameters from a SharePoint List
I am new to Power BI Report Builder. I have created a paginated report with a SharePoint list (Daily Inspection) as the data source. I need to make a parameter that will show only one report at a time based on a field, SubmissionID number, ex: 202304061120. I was able to add the parameter in the UI, but the report does not filter with the selected SubmissionID. I assume I need to adjust the dataset query, which I just pulled from DAX. I created the data source in a .pbix file and uploaded to PBI Server. How do I add a parameter to SharePoint dataset query. See the current query produced by PowerBI below. Thanks!
// DAX Query
DEFINE
VAR __DS0Core =
SUMMARIZE(
'Daily Inspection',
'Daily Inspection'[BrakeCondition],
'Daily Inspection'[BrakeLeak],
'Daily Inspection'[BrakeLevel],
'Daily Inspection'[ClutchCondition],
'Daily Inspection'[ClutchLeak],
'Daily Inspection'[ClutchLevel],
'Daily Inspection'[Coolant Leak],
'Daily Inspection'[CoolantLevel],
'Daily Inspection'[Date],
'Daily Inspection'[Created],
'Daily Inspection'[EngOil Condition],
'Daily Inspection'[EngOil Leak],
'Daily Inspection'[EngOil Level],
'Daily Inspection'[Inspector],
'Daily Inspection'[RadCondition],
'Daily Inspection'[RadLeak],
'Daily Inspection'[Space],
'Daily Inspection'[SubmissionID],
'Daily Inspection'[Vehicle]
)
VAR __DS0PrimaryWindowed =
TOPN(
501,
__DS0Core,
'Daily Inspection'[BrakeCondition],
1,
'Daily Inspection'[BrakeLeak],
1,
'Daily Inspection'[BrakeLevel],
1,
'Daily Inspection'[BrakeLights],
1,
'Daily Inspection'[ClutchCondition],
1,
'Daily Inspection'[ClutchLeak],
1,
'Daily Inspection'[ClutchLevel],
1,
'Daily Inspection'[Coolant Leak],
1,
'Daily Inspection'[CoolantLevel],
1,
'Daily Inspection'[Date],
1,
'Daily Inspection'[Created],
1,
'Daily Inspection'[EngOil Condition],
1,
'Daily Inspection'[EngOil Leak],
1,
'Daily Inspection'[EngOil Level],
1,
'Daily Inspection'[Inspector],
1,
'Daily Inspection'[RadCondition],
1,
'Daily Inspection'[RadLeak],
1,
'Daily Inspection'[Space],
1,
'Daily Inspection'[SubmissionID],
1,
'Daily Inspection'[Vehicle],
1
)
EVALUATE
__DS0PrimaryWindowed
ORDER BY
'Daily Inspection'[SubmissionID]