Skip to main content

Power BI

Needs Votes

PBI Desktop/Reports: Ability to capture all SQLs at report level

Vote (3) Share
Buddhi Gupta's profile image

Buddhi Gupta on 11 Jan 2021 20:29:04

In Power Query Editor, there are multiple transformations are applied and queries are sent to Database. To validate logic against Database, queries are to be generated and review.

The functionality of generating all queries using one button is available in IBM Cognos, Tableau at Report level. I think, it will be great addition to Power BI to provide such functionality. Currently it's only available for each query. It will create more difficulty when PBI datasets are used as source for multiple reports.

I hope this feature is available sooner than later to make it easy for analysis and maintenance tasks in BI Life cycle.

Thanks!