Thanks for reaching out to Microsoft Q&A.
By saying azure table storage on top of azure synapse, I hope you are referring about external table.
Can I filter out the whole data from the specific table storage using Azure Synapse workspace without linking to power bi
yes with synapse table you can form your own query to filter out the table and even create it as a view... but for report you would need to use powerbi.
Or can i create the report by only using power bi
Yes you would need pbi to pull data from synapse and create a report dashboard.
If your question is something else, could you elaborate?
Please Upvote and Accept as answer if the reply was helpful, this will be helpful to other community members.