To View Specific table name and column name

[DivakarKrishnan]

Dear Team,

I am new to Power BI development.

I am facing one issue in existing Power BI workspace where data is not refreshed correctly.

Inside the edit queries, i can see multiple queries (sales1, sales2) and all are using Microsoft SQL DB. I want to see which SQL table /  specfic column has been used particularly in sales1 queres. Please let me know on how to check this asap. Thanks!

Thanks,

Divakar

[v-lili6-msft · Accepted solution]

hi, @DivakarKrishnan 

In Edit Queries, Click QUERY SETTINGS to view every step of the query 

or in Advanced Editor to see all the query.

You could see which SQL table /  specfic column has been used particularly.

And also you could refer to this blog:

https://www.mssqltips.com/sqlservertip/4563/power-bi-native-query-and-query-folding/

Please understand that this link is provided “AS IS” with no warranties or guarantees of content changes, and confers no rights.

Best Regards,

Lin