cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
swt
Frequent Visitor

Detailed Lineage Data?

Coming from SAP BusinessObjects, one of the nicest features from an administrative perspective is the existence of add-ons that scrape the SQL queries from all reports on the server and store them in a table. This was key to conducting proactive impact analysis when changes were being made to tables in a database; we could easily query reports that utilize specific tables and fields.

 

Is there administrative functionality in the Power BI service - either native or through add-ons - that would allow us to see the SQL queries generated by every report or dataset, or even just the tables used in every report or dataset? All the better if it's in a single table. 🙂

 

The new lineage view doesn't quite do what we need, as it simply lists the aliased table and query names in a dataset, and it needs to be manually inspected dataset by dataset.

 

In case it's a factor, we're using an on-premises SQL Server database through a data gateway.

1 REPLY 1
GilbertQ
Super User
Super User

Hi there

If your queries are coming from your SQL Server database, I would suggest enabling SQL Server Profiler and logging all the queries into a table on your SQL Server to complete this.

Another option is you could possibly enable verbose logging on your On-Premise Gateway but this could potentially slow down your dataset refreshes.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors