Input string parameter in Power BI

1. Power Apps Integration

You can integrate Power Apps with Power BI to create a text input field. The input from Power Apps can then be used to call a stored procedure. Here’s a high-level approach:

• Create a Power App with a text input box.
• Embed the Power App in your Power BI report.
• Use the text input value from Power Apps to call the stored procedure in Power BI.

2. Using Query Parameters in Power BI

Although Power BI doesn’t natively support text input parameters in the report view, you can create a query parameter in Power Query:

• Go to Power Query Editor.
• Create a new parameter with a text data type.
• Use this parameter in your query that calls the stored procedure.

3. Custom Visuals or Slicers

While default slicers don’t support text input, there are custom visuals available in the Power BI marketplace that allow for text input. One such visual is the “Text Filter”:

• Import the “Text Filter” visual from the marketplace.
• Add it to your report and link it to your data.
• Use DAX or Power Query to utilize the text input in your stored procedure.

4. Direct Query and SQL Parameters

If your data source supports Direct Query mode, you can pass the parameter directly to the SQL query:

• Write a custom SQL query in Power BI.
• Use a parameter in your SQL query that takes the input from a text box created using custom visuals.