Hello @Amit Kumar
Did you try to use Azure Data Studio or any other SQL client tool to connect to the SQL Pool and query the data?
Using Azure Data Share you can invite someone to access the data and then they have to load the data to a target database and then again it will be the user's responsibility to build any reporting on top of that Dataset!
I am afraid to say that there are no direct methods available to access Synapse SQL Pool, as I have seen REST APIs to manage the Pool. But we might have to create custom application in this scenario.