How to display Top 100 records for any table selected by user in slicer?

[kadamsujit]

I have to build a Power BI report that displays Top 100 records for any table selected in the slicer or filter. The tables are basically all the tables in Azure DW. I am using stored procedure with table name passed as parameters. My main problem is how to dynamically handle different columns from different tables to display top 100 records in the table. Is it even possible?

For your reference the stored procedure code is below:

CREATE PROC [dbo].[USP_TOP100REC_TABLES] @TableName [VARCHAR](200) AS
DECLARE	@Query		VARCHAR(200)
SET @Query = 'SELECT TOP 100 * FROM ' + @TableName
EXEC(@Query)
GO

[v-yulgu-msft]

Hi @kadamsujit ,

In Power BI, I'm afraid such a requirement is not achievable right now.

Best regards,

Yuliana Gu