How to show table visual inside another table visual?

[billgundas]

How to show table visual inside another table visual?

[v-yalanwu-msft]

Hi, @billgundas ;

Sorry this is not supported, if you want to query the database and call, you need to refresh it, if you click Direct query is not currently supported.

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yalanwu-msft]

Hi,  @billgundas ;

You mean to implement in Desktop similar to Power Query, right?
If so, that won't work. Because you need to expand it in Power Query, you can take the tooltip method to display tables or views for different years.

Create report tooltip pages in Power BI - Power BI | Microsoft Learn

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[billgundas]

No, I don't want to implement in Desktop similar to Power Query. 
I want user to be able to make direct query calls to my database when they click on a year row, Power BI should be calling a function with that year as a parameter.

[billgundas]

Each row click here runs a query with a stored proc that is taking a parameter from this function call. What other options do i have to show the final dataset to the user?

[billgundas]

Basically, I would like to show the resulting dataset to user when they click a year. Any ideas greatly appreciated.