pbi report builder parameter
1 Topic
Power BI Report Builder
To Whom It May Concern: Note: (Heatlhcare Physicians Report) I am trying to build out a Power BI Report, using Power BI Report Builder. We are using Power BI Report Server ( ON PREMISES). The report is simple, pulling in Physician Contact Information. However, I have made several attempts at building a Parameter based on the Physician's Name. When I build the parameter out, run the report, I select a Provider, then View. The results are not a singleton record. I get all Physicians Names. Attempts: 1.) Created Parameter in Power BI Report Builder. Did not work. A.) The Different Report Parameter Properties I have tried: i.) Select from one of the following options: a.) Tried None b.) Tried Specifiy Values c.) Get values from a query. None of part 1.) Worked. Get Values from a query was close, but pulled all records. Its supposed to only pull Physician's Contact Info based on the Name Selected. 2.) Created Parameter in the SQL CODE: Delcared Parameter, and applied it in the Where Clause. No syntex errors. A.) Created Parameter in PBI Report Builder no succcess. Errors I have received in the past: 1.) ExecuteReader: CommandText property has not been initialized 2.) The report parameter 'SelectPhysName1' has a DefaultValue or a ValidValue that depends on the report parameter "SelectPhysName1". Forward dependencies are not valid. Please provide solution(s). Thank You. Mark Lynn.Solved1.4KViews2likes4Comments