users input to select data

[Davesm]

i get sent a excel spread sheet with new accounts to search on every month. user wants a power bi report based on her input e.g 

account number 1, 2, 3 this month  and next month the account number change to 6, 7, 8 the account number are never the same.

In reporting services (ssrs) this was possible. 

[v-ssriganesh]

Hi @Davesm,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-ssriganesh]

Hi @Davesm,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-ssriganesh · Accepted solution]

Hi @Davesm,
Thank you for reaching out to the Microsoft Fabric Forum Community.

@lbendlin made a great point. if the dataset isn't too large, one of the simplest approaches would be to ingest all account data into Power BI and allow the user to filter dynamically using a slicer. This eliminates the need for monthly updates and ensures flexibility.

However, if your dataset is large or frequently changing, you can consider these approaches:

• Store your account list in an Excel file, connect it to Power BI, and refresh the data whenever the list changes.
• Create a disconnected table for account selection and use a slicer to filter reports dynamically.
  
  

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[v-ssriganesh]

Hi @Davesm,

I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.

[lbendlin]

How much data?  Might be easier to ingest all data and then let the user filter in the report.