How to create prompts in power apps to filter out data in powerbi while opening.

[Veena_7]

I have a organization id and site id in my table. I wanted to show these 2 columns as prompt for user selection and depending on that report should load/show data related to prompt selection. Like any other BI tools cognos , microstrategy , I wanted to create prompt and depending on that powerbi should load the data. I need to build this because I have a large volumne of data which take around 3 hours to load. 
e.g if user selects org id : 1 , site id : 1000 then report should only load for these 2 values. Kindly help with some of the options.

[rnola16]

I do not see an option to enter parameter values on a defined report in 'Apps'. The report does however can be run with user defined parameters in Power BI Service in Workspace. Appreciate if anyone has any luck. Thanks.

[Anonymous · Accepted solution]

Hi Akash_Varuna ,thanks for the quick reply, I'll add more.

Hi @Veena_7 ,

Check if this article meets your needs.

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

This is the raw data from the database.

1.Creating Parameters

2.Modify M code

3.Create a table for the parameters and bind

Final output

Best Regards

[Akash_Varuna]

Hi @Veena_7 , You could achive this by creating parameters in PBI and then embedding the report on to Power Apps Could you please checke these 

• Create parameters in Power BI Desktop for organization ID and site ID, and use them in Power Query to filter data.
• Use DirectQuery mode to avoid preloading all data, ensuring real-time filtering.
• Embed the Power BI report in Power Apps, using dropdowns or inputs for users to select organization ID and site ID.
• Pass user selections as query string parameters to dynamically filter the Power BI report.
  If this post helped please do give a kudos and accept this as a solution
  Thanks In Advance

[Veena_7]

@Akash_Varuna : Thanks for your reply.

Even if we don't use power apps , we can edit parameters and change the selection and report will filter out data. but my question is
1. Importing data via oracle connection and having 12lakh rows (hige volume) take longer time to load initially
2. I don't want to do initial load itself in powerbi (import 12 lakh rows, instead , I want to create report and fetch only single selection value first and then create prompts for org id and site id )
3. when user will open the report that 2 prompt should appear for selection.

is this doable or do i need to all 12 lakh rows data first in import mode and then create prompt using power apps

[Akash_Varuna]

Hi @Veena_7 I understand but as i mnetioned couldnt you try for Direct Query and limit the data on filtering or Prompts ? You could create slicers which would act as promts and also set parameters based on organization id and so on