Forum Discussion

Candy_L's avatar
Candy_L
Frequent Visitor
3 years ago

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]               

 

No RepliesBe the first to reply