Need help with custom reporting

[jilek]

So I have a large dataset for my customers, the issue I am trying to overcome is that they all come to me with a list of contract numbers for whichever account they are interested in at that time.  They are looking to filter this dataset by those provided contract numbers and export that data.  How do I ingest that list from them and then have it filter that data for them on demand?

[jilek]

@amitchandak - I am sure that there will be some sort of power automate or scripting that will have to be done to acheieve this.  I am just trying to figure out that plan as I have never had to do something like this.

@v-yanjiang-msft - I did start out with your suggested route, but it got to where there were so many duplicate contract numbers that the customers would provide for me that I told them until they can get me a good list this wont be an option.

For now I was trying to give them some sort of custom on demand reporting that would allow them to provide the contract numbers and then select the reporting period they are looking for and the tool/utility would provide them the .csv or whatever with that data.

[v-yanjiang-msft]

Hi @jilek ,

If you don't want to search each contract number and select them in the slicer, at least the customer should have a list about which contract numbers they prefer to give you. Then you can create a new table by it like this:

Create relationship to the fact table with the contract number column.

And then filter the visual by the customer slicer.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[jilek]

just to add, these are large lists of contract numbers, a pain in the @$$ to select each one manually in a slicer.  

[amitchandak]

@jilek , I think you should if power automate can help in this case