Forum Discussion

RYA's avatar
RYA
New Member
3 years ago

How to create User prompt for only querying a specific record/customer from DB

Hi, I have a usecase where I have to build a PowerBI customers report for several PowerBI endusers. The report is containing: Customer number, Customer Name, Account number, Account value, Account...
Need Help
Tips and Tricks
Tutorial Requests
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi RYA ,

You can refer the following links to get it by using Power Query Parameter:

Include Parameters within Power BI to Query a SQL Data Source

(x as text, y as text)=>let
    Source = Sql.Database("x", "y", [Query="select *#(lf)from z#(lf)WHERE [period_number]="&P2&"#(lf)AND [fiscal_year]="&P1&""])
in
    Source

PS: You can create a parameter to filter the customer...

Using Query Parameters in Filter Rows

Create parameterFilter the rows by the parameter

Best Regards

RYA's avatar
RYA
New Member
3 years ago

Hi Team_Rena

 

Im not sure that the solution can be used for published reports. At least i can't get a pop-up prompt where the end user has to make there input parameters which are Customer no. and date.

 

/Recep