Forum Discussion
Sql data interactions
Hi weilip1803,
Based on your description, it seems that you want to use drill-down feature in Power BI. Currently, the feature is not available in Power BI but it is under review, please vote it and add your comments in the following idea. In addition, you can consider to create reports in SQL Server Reporting Services and use the drill-down feature.
https://ideas.powerbi.com/forums/282523-bi-in-sql-vnext/suggestions/7052191-drill-through-actions-parameter-passing-just
Thanks,
Lydia Zhang
What do you mean "make SQL query"? Power BI is an encapsulated reporting tool. It will slice and dice across the data it has loaded, but it cannot fetch a new SQL statement based on chart interaction. You should load the data you want to report on into Power BI, and then slice and dice from there