Forum Discussion
To View Specific table name and column name
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
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
1 Reply
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